返回到 Design and Build a Data Warehouse for Business Intelligence Implementation
University of Colorado System

Design and Build a Data Warehouse for Business Intelligence Implementation

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.

状态:PostgreSQL
状态:Case Studies
课程小时

精选评论

TD

5.0评论日期:Jun 27, 2023

Good course. This course teaches you to connect data sources to Microstrategy, wrangle and prepare the data for designing visualizations and building dashboards and tell a story with data.

PN

5.0评论日期:Dec 8, 2016

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

MB

4.0评论日期:Jan 1, 2017

Mentor review for the final project takes long time to be completed.

OE

5.0评论日期:May 24, 2016

Excellent course..provides hands-on experience on designing a data warehouse for BI implementation

MJ

5.0评论日期:Feb 10, 2017

Excelent course. Much of your time will be needed to do the assignments.

DD

5.0评论日期: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.

PG

4.0评论日期:Aug 12, 2018

Very good except for the fact you had to wait for certain course aspects until the mark is officially given

RR

5.0评论日期:May 4, 2016

Well framed capstone project. no less than real project.

RT

5.0评论日期:Oct 8, 2017

Excellent Specialization. I will recommend this course to all my friends.

KP

5.0评论日期:Feb 11, 2017

Very useful,I will Recommend this course to my fellow mates .

SK

4.0评论日期:May 23, 2016

It was very challenging. Not everything was well prepared. But overall good! Thank you very much!

所有审阅

显示:20/42

David Antonio Martínez Cascante
5.0
评论日期:Dec 26, 2020
Shrey Pratap Singh
1.0
评论日期:Nov 23, 2016
Prasant Nayak
5.0
评论日期:Dec 9, 2016
Robert Leon Johnson
4.0
评论日期:May 30, 2016
Ankit Mittal
3.0
评论日期:Dec 9, 2016
Daniel Meyer
1.0
评论日期:Aug 22, 2018
Hussein Alkhasraji
1.0
评论日期:Sep 28, 2023
DevendraMehra
5.0
评论日期:Jun 28, 2016
Friso Spinhoven
4.0
评论日期:Nov 3, 2019
Sergey Kibish
4.0
评论日期:May 24, 2016
Manmeet Singh Bhogal
4.0
评论日期:Jan 1, 2017
Fernando
3.0
评论日期:Feb 6, 2017
LINGKAI ZHANG
1.0
评论日期:Apr 9, 2020
Daniel Berry
1.0
评论日期:Mar 6, 2017
Tam David
5.0
评论日期:Jun 28, 2023
5.0
评论日期:Jul 17, 2017
Obinna Ekeh
5.0
评论日期:May 25, 2016
Roberto Tellez
5.0
评论日期:Oct 9, 2017
Małgorzata Jedrasik
5.0
评论日期:Feb 11, 2017
Kasani Prabhakar
5.0
评论日期:Feb 11, 2017