Monthly Subscription Starting at AED 99 + VAT
- Level Foundation
- المدة 45 ساعات hours
- الطبع بواسطة University of Colorado System
-
Offered by
عن
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.الوحدات
Course objectives
-
1
Videos
-
1
Readings
1
Videos
- Course introduction
1
Readings
- Slides for lesson 1
Course topics and assignments
-
1
Videos
-
1
Readings
1
Videos
- Course topics and assignments video lesson
1
Readings
- Slides for lesson 2
CPI Card Group background
-
1
Videos
-
2
Readings
1
Videos
- Executive interview
2
Readings
- Slides for lesson 3
- Background on CPI Card Group
Course software requirements
-
5
Readings
5
Readings
- Overview of software requirements
- PostgreSQL Installation
- Pentaho Data Integration installation
- MicroStrategy Workstation Software Download and Installation for Microsoft Windows and Mac OS
- Database diagramming tools
CPI Card Group background
-
1
Videos
-
1
Readings
1
Videos
- Executive interview
1
Readings
- Slides for lesson 1
Case study requirements
-
3
Readings
-
1
Assignment
1
Assignment
- Reflective Quiz for the Module 2 Assignment
3
Readings
- Data warehouse design background
- Module 2 assignment
- Self-Evaluation for the Module 2 Assignment
CPI Card Group background
-
1
Videos
-
1
Readings
1
Videos
- Executive interview
1
Readings
- Slides for lesson 1
First Bank data integration background
-
1
Videos
-
1
Readings
1
Videos
- Executive interview
1
Readings
- Slides for lesson 2
Pinnacol Assurance data integration background
-
1
Videos
-
1
Readings
1
Videos
- Executive interview
1
Readings
- Slides for lesson 3
Case study requirements
-
4
Readings
-
3
Assignment
3
Assignment
- Reflective Quiz for the Module 3 Assignment
- Practice Quiz for the module 3 assignment-Test DW
- Quiz for the module 3 assignment-Production DW
4
Readings
- Data integration background
- Module 3 Assignment
- Extended transformation notes and examples
- Self-Evaluation for the Module 3 Assignment
Summary data management background
-
1
Videos
-
1
Readings
1
Videos
- Executive Interview with Kellyn Gorman of Oracle
1
Readings
- Slides for lesson 1
Case study requirements
-
3
Readings
-
1
Assignment
1
Assignment
- Reflective Quiz for the Module 4 Assignment
3
Readings
- Module 4 Assignment
- SQL Statements for the Module 4 Assignment
- Self Evaluation for the Module 4 Assignment
Case study requirements
-
2
Videos
-
4
Readings
2
Videos
- Executive Interview with Matthew Caton of Data Source Consulting
- Executive Interview with Tyler Wilson on BI Platform Capabilities at CPI Card Group
4
Readings
- Slides for executive interview with Matthew Caton
- Capstone Project Data Visualizations and Dashboard Design Requirements
- Earlier Assignments from Course 4
- Q & A and Error Knowledge base
Captsone Project Submission
-
2
Videos
-
1
Readings
-
1
PeerReview
1
Peer Review
- Data Visualization and Dashboard Design Assignment
2
Videos
- Executive Interview with James Gualke on the State of BI Maturity and Strategy at PDC Energy
- Course conclusion video lecture
1
Readings
- Background Information on Data Visualization and Dashboard Design
Auto Summary
Embark on a comprehensive journey into data warehousing and business intelligence with this capstone course designed for data science enthusiasts. Led by Coursera, this foundational course guides you through designing and building a small data warehouse based on a real-world case study. You'll learn to create data integration workflows, write SQL queries, and develop dashboards using the MicroStrategy platform. Over 2700 minutes, enhance your skills in data architecture, integration, and visualization. Subscription options include Starter and Professional, making it perfect for aspiring data professionals aiming to showcase their expertise.
Michael Mannino
Jahangir Karimi