Chevron Left
返回到 设计和开发数据仓库来实现商业智能

学生对 科罗拉多大学系统 提供的 设计和开发数据仓库来实现商业智能 的评价和反馈

4.6
224 个评分
30 个审阅

课程概述

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

热门审阅

DD

Jun 28, 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 09, 2016

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

筛选依据:

26 - 设计和开发数据仓库来实现商业智能 的 29 个评论(共 29 个)

创建者 Manmeet S B

Jan 02, 2017

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

创建者 Sergey K

May 24, 2016

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

创建者 Florian P

May 23, 2016

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

创建者 Daniel B

Mar 06, 2017

Unclear, ambiguous direction and material that is unhelpful for building the final project