Data Warehouse Design
Data Integration
Analytical Queries and Summary Data Management
Data Visualization and Dashboard Design Requirements
Wrap Up and Project Submission
Certification
You will get a certificate on completing this course.
University
The course is not from a very prestigious university.
Price
This course is costly - Rs. 4439/-.
Difficulty
The students of this course have found this course difficult.
Content
The students of this course have liked the content of this course.
Assignments
The students of this course have not liked the assignments of this course.
Teaching
The students of this course have liked how the instructor has taught this course.
Satisfaction
The students of this course are overall satisfied with this course.
Edvicer's Rewards
You can get a cashback of ₹ 300 on buying this course.
Limited Time Discount Offers
Save your money with Edvicer. Check out our premium courses with discount offers.
Save your money with Edvicer. Check out our premium courses with discount offers.
Map your Career
Not sure which job profiles this course will open for you? Check out our AI based tool to get a complete personalized career map.
Not sure which job profiles this course will open for you? Check out our AI based tool to get a complete personalized career map.
Certification
You will get a certificate on completing this course.
University
The course is not from a very prestigious university.
Price
This course is costly - Rs. 4439/-.
Difficulty
The students of this course have found this course difficult.
Content
The students of this course have liked the content of this course.
Assignments
The students of this course have not liked the assignments of this course.
Teaching
The students of this course have liked how the instructor has taught this course.
Satisfaction
The students of this course are overall satisfied with this course.
Edvicer's Rewards
You can get a cashback of ₹ 300 on buying this course.
The capstone course, Design and Build a Data Warehouse for Business Intelligence Implementation, features a real-world case study that integrates your learning across all courses in the specialization. In response to business requirements presented in a case study, you'll design and build a small data warehouse, create data integration workflows to refresh the warehouse, write SQL statements to support analytical and summary query requirements, and use the MicroStrategy business intelligence platform to create dashboards and visualizations. In the first part of the capstone course, you'll be introduced to a medium-sized firm, learning about their data warehouse and business intelligence requirements and existing data sources. You'll first architect a warehouse schema and dimensional model for a small data warehouse. You'll then create data integration workflows using Pentaho Data Integration to refresh your data warehouse. Next, you'll write SQL statements for analytical query requirements and create materialized views to support summary data management. For data integration workflows and analytical queries, you can use either Oracle or PostgreSQL. Finally, you will use MicroStrategy OLAP capabilities to gain insights into your data warehouse. In the completed project, you'll have built a small data warehouse containing a schema design, data integration workflows, analytical queries, materialized views, dashboards and visualizations that you'll be proud to show to your current and prospective employers.
Course Overview
Data Warehouse Design
Data Integration
Analytical Queries and Summary Data Management
Data Visualization and Dashboard Design Requirements
Wrap Up and Project Submission
Reviews from Coursera
I have submitted all my solution long back but the last submission which was suppose to been by mentor is pending from one and the half months.
Excellent contemporary course content and hands on course. Recommended for everyone who wants start or change into exciting career in DWBI.
Course is good but mentor grading needs to be a bit sorted as in they required almost 2 additional weeks to grade one assignment in total that is 1 month to grade an assignment so that needs to be take Read More ...
Awesome content ,very well drafted and explained course content. I am thankful to the coursera team, who has discovered such kind of really good course and specialization.
this is an excellent and rigorous course and a valuable preparation for working with data warehouses. frustratingly, the assignments contained errors, inconsistencies, and vagaries that left me wonderi Read More ...
Show more reviews
Write your review of Design and Build a Data Warehouse for Business Intelligence Implementation
![]() | ![]() | ![]() |
![]() | ![]() | ![]() |
![]() | ![]() | ![]() |