Design and Build a Data Warehouse for Business Intelligence Implementation

This course is part of a Specialization (series of courses) called Data Warehousing for Business Intelligence.

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. 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.

Get Details and Enroll Now

OpenCourser is an affiliate partner of Coursera.

Get a Reminder

Not ready to enroll yet? We'll send you an email reminder for this course

Send to:

Coursera

&

University of Colorado System

Rating 4.2 based on 26 ratings
Length 7 weeks
Effort 6 weeks of study, 3-5 hours/week
Starts Jan 21 (2 days ago)
Cost $79
From University of Colorado System via Coursera
Instructors Michael Mannino, Jahangir Karimi
Free Limited Content
Language English
Subjects Data Science Business
Tags Data Science Data Analysis Business Business Essentials

Get a Reminder

Get an email reminder about this course

Send to:

What people are saying

We analyzed reviews for this course to surface learners' thoughts about it

bit sorted as in one review

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 taken care of Excellent contemporary course content and hands on course.

course..provides hands-on experience in one review

Excellent course..provides hands-on experience on designing a data warehouse for BI implementation It was very challenging.

discovered such kind in one review

I am thankful to the coursera team, who has discovered such kind of really good course and specialization.

left me wondering in one review

frustratingly, the assignments contained errors, inconsistencies, and vagaries that left me wondering if the professors did this on purpose, to simulate real world situations.

requires far too in one review

The capstone project is interesting but requires far too much time compared to the other courses and to what is announced.

sample dashboards provided in one review

The sample dashboards provided are not well done enough to be used in a professional setting.

Careers

An overview of related careers and their average salaries in the US. Bars indicate income percentile.

Warehouse Data Specialist $58k

Data Warehouse Marketing $81k

Specialist - Data Warehouse $87k

Data Warehouse Analyst 3 $107k

Data Warehouse Consultant $115k

Data Integration Engineer| Data Warehouse $116k

Data Warehouse Analyst 2 $121k

Data Warehouse - Architecture $147k

Data Warehouse Validation $152k

Data Architect Data Warehouse $167k

Data Warehouse Architect u2013 for Enterprise Data Warehouse $187k

Data Warehouse Development $249k

Write a review

Your opinion matters. Tell us what you think.

Coursera

&

University of Colorado System

Rating 4.2 based on 26 ratings
Length 7 weeks
Effort 6 weeks of study, 3-5 hours/week
Starts Jan 21 (2 days ago)
Cost $79
From University of Colorado System via Coursera
Instructors Michael Mannino, Jahangir Karimi
Free Limited Content
Language English
Subjects Data Science Business
Tags Data Science Data Analysis Business Business Essentials