Chevron Left
Back to Design and Build a Data Warehouse for Business Intelligence Implementation

Learner Reviews & Feedback for Design and Build a Data Warehouse for Business Intelligence Implementation by University of Colorado System

4.6
stars
266 ratings

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

Top reviews

DD

Jun 27, 2016

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.

PN

Dec 8, 2016

Excellent contemporary course content and hands on course. Recommended for everyone who wants start or change into exciting career in DWBI.

Filter by:

1 - 25 of 38 Reviews for Design and Build a Data Warehouse for Business Intelligence Implementation

By Shrey P S

Nov 23, 2016

By David A M C

Dec 26, 2020

By Prasant k n

Dec 9, 2016

By Ankit M

Dec 9, 2016

By DevendraMehra

Jun 28, 2016

By Robert L J

May 30, 2016

By Friso S

Nov 4, 2019

By Sergey K

May 24, 2016

By Manmeet S B

Jan 2, 2017

By Fernando

Feb 6, 2017

By Daniel M

Aug 22, 2018

By abel.saenz@gmail.com

Jul 17, 2017

By Obinna E

May 25, 2016

By Roberto T

Oct 9, 2017

By Małgorzata J

Feb 11, 2017

By Kasani P

Feb 11, 2017

By Ranga

May 5, 2016

By Peter S

Aug 13, 2016

By Rakshit G

Jan 8, 2017

By BENSON E A

Aug 17, 2019

By Qiao D

Oct 20, 2017

By Pratik A

Aug 26, 2016

By Андрій Б

May 18, 2021

By DUYVANDS

Jul 20, 2021

By Rajat K j

Jun 4, 2016