Name: Design and Build a Data Warehouse for Business Intelligence Implementation
Brand: University of Colorado System
Availability: OnlineOnly
Rating: 4.6 (42 reviews)

返回到 Design and Build a Data Warehouse for Business Intelligence Implementation

学生对 University of Colorado System 提供的 Design and Build a Data Warehouse for Business Intelligence Implementation 的评价和反馈

4.6

星

292 个评分

课程概述

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

26 - Design and Build a Data Warehouse for Business Intelligence Implementation 的 42 个评论（共 42 个）

创建者 Qiao D

•

Oct 20, 2017

Very practical and useful

创建者 Pratik A

•

Aug 26, 2016

Excellent course to learn

创建者 Андрій Б

•

May 18, 2021

It's a very good course.

创建者 DUYVANDS

•

Jul 20, 2021

overall a good course

创建者 Rajat K j

•

Jun 4, 2016

Very Beneficial !!!

创建者 Carlos P

•

Oct 16, 2017

good and challenge

创建者 Sachin G

•

May 15, 2016

Awesome Course!

创建者 Abhinav R

•

Jun 25, 2021

Amazing Course

创建者 Saad H M A

•

May 27, 2025

ممتاز

创建者 Nazarii M

•

Apr 28, 2022

супер

创建者 E.Naveen K

•

Nov 18, 2016

Great

创建者 Олеслав-Іван Б

•

Apr 13, 2022

Cool

创建者 Jordi P L

•

Aug 12, 2016

创建者 Matthew D

•

Oct 3, 2017

I loved the 1st 4 weeks of this capstone course which focused on data warehouse design, data integration and writing queries. All of the assignments were challenging but fair. Unfortunately, I do not feel the same way about the data visualization module. The sample dashboards provided are not well done enough to be used in a professional setting.