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

Created by: University of Colorado System

Taught by: Michael Mannino, Associate Professor
Business School, University of Colorado Denver
Taught by: Jahangir Karimi, Professor
Information Systems University of Colorado Denver

Basic Info	Course 5 of 5 in the Data Warehousing for Business Intelligence Specialization
Commitment	6 weeks of study, 3-5 hours/week
Language	English
How To Pass	Pass all graded assignments to complete the course.
User Ratings	4.6 stars Average User Rating 4.6See what learners said

Syllabus

WEEK 1

Course Overview

Module 1 introduces the objectives and topics in the course and provides background on the case and software requirements. The capstone course is organized around a realistic case study based on the business situation faced by CPI Card Group in 2015.

3 videos, 9 readings

Video: Course introduction
Reading: Slides for lesson 1
Video: Course topics and assignments video lesson
Reading: Slides for lesson 2
Video: Executive interview
Reading: Slides for lesson 3
Reading: Background on CPI Card Group
Reading: Overview of software requirements
Reading: Oracle database server installation
Reading: Pentaho Data Integration installation
Reading: Microstrategy Desktop installation
Reading: Database diagramming tools

WEEK 2

Data Warehouse Design

Module 2 presents the requirements of the first part of the case study involving data warehouse design. To provide a context for the case study, you can listen to an executive interview with a CPI Card Group executive.

1 video, 4 readings

Video: Executive interview
Reading: Slides for lesson 1
Reading: Data warehouse design background
Reading: Documents for the module 2 assignment
Reading: Documents to review after the assignment

Graded: Data warehouse design assignment

WEEK 3

Data Integration

Module 3 presents requirements for the second part of the case study involving data integration. To provide a context for the case study, you can listen to executive interviews with executives from CPI Card Group, First Bank, and Pinnacol Assurance.

3 videos, 5 readings, 1 practice quiz

Video: Executive interview
Reading: Slides for lesson 1
Video: Executive interview
Reading: Slides for lesson 2
Video: Executive interview
Reading: Slides for lesson 3
Reading: Data integration background
Reading: Documents for the module 3 assignment
Practice Quiz: Practice Quiz for module 5 assignment-Test DW

Graded: Assignment for module 3

Graded: Quiz for module 5 assignment-Production DW

WEEK 4

Analytical Queries and Summary Data Management

Module 4 presents requirements for the third part of the case study involving analytical queries and summary data management.

1 video, 3 readings

Video: Executive Interview with Kellyn Gorman of Oracle
Reading: Slides for lesson 1
Reading: Documents for the module 4 assignment
Reading: Solutions to challenge problems

Graded: Analytical Query Assignment

WEEK 5

Data Visualization and Dashboard Design Requirements

Module 5 presents the data visualization and dashboard design requirements for the fourth part of the case study.

2 videos, 4 readings

Video: Executive Interview with Matthew Caton of Data Source Consulting
Reading: Slides for executive interview with Matthew Caton
Video: Executive Interview with Tyler Wilson on BI Platform Capabilities at CPI Card Group
Reading: Capstone Project Data Visualizations and Dashboard Design Requirements
Reading: Earlier Assignments from Course 4
Reading: Q & A and Error Knowledge base

WEEK 6

Wrap Up and Project Submission

This is an extension of Module 5. The peer assessment from module 5 is moved to module 6 to give you more time completing the assignments in prior modules as well as for you to do your peer assessment in this module.

2 videos, 1 reading

Video: Executive Interview with James Gualke on the State of BI Maturity and Strategy at PDC Energy
Reading: Background Information on Data Visualization and Dashboard Design
Video: Course conclusion video lecture

Graded: Data Visualization and Dashboard Design Assignment

FAQs

When will I have access to the lectures and assignments?

What if I need additional time to complete the course?

What is the refund policy?

How It Works

Coursework

Each course is like an interactive textbook, featuring pre-recorded videos, quizzes and projects.

Help from Your Peers

Connect with thousands of other learners and debate ideas, discuss course material, and get help mastering concepts.

Certificates

Earn official recognition for your work, and share your success with friends, colleagues, and employers.

Creators

University of Colorado System

The University of Colorado is a recognized leader in higher education on the national and global stage. We collaborate to meet the diverse needs of our students and communities. We promote innovation, encourage discovery and support the extension of knowledge in ways unique to the state of Colorado and beyond.

Pricing

	Purchase Course	Audit
Access to course materials	Available	Available
Access to graded materials	Available	Not available
Receive a final grade	Available	Not available
Earn a shareable Course Certificate	Available	Not available

Ratings and Reviews

Rated 4.6 out of 5 of 160 ratings

good and challenge

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

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.

Great specialization, extenuates assessments, Oracle, ETL, and Microstrategy Excelent softwares, great challenge