Monthly Subscription Starting at AED 99 + VAT

Design and Build a Data Warehouse for Business Intelligence Implementation
  • Level Foundation
  • Duration 45 hours
  • Course by University of Colorado System
  • Offered by

About

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.

Modules

Course objectives

    • 1 Videos
    • 1 Readings
Show info about module content

1 Videos

  • Course introduction

1 Readings

  • Slides for lesson 1

Course topics and assignments

    • 1 Videos
    • 1 Readings
Show info about module content

1 Videos

  • Course topics and assignments video lesson

1 Readings

  • Slides for lesson 2

CPI Card Group background

    • 1 Videos
    • 2 Readings
Show info about module content

1 Videos

  • Executive interview

2 Readings

  • Slides for lesson 3
  • Background on CPI Card Group

Course software requirements

    • 5 Readings
Show info about module content

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
Show info about module content

1 Videos

  • Executive interview

1 Readings

  • Slides for lesson 1

Case study requirements

    • 3 Readings
    • 1 Assignment
Show info about module content

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
Show info about module content

1 Videos

  • Executive interview

1 Readings

  • Slides for lesson 1

First Bank data integration background

    • 1 Videos
    • 1 Readings
Show info about module content

1 Videos

  • Executive interview

1 Readings

  • Slides for lesson 2

Pinnacol Assurance data integration background

    • 1 Videos
    • 1 Readings
Show info about module content

1 Videos

  • Executive interview

1 Readings

  • Slides for lesson 3

Case study requirements

    • 4 Readings
    • 3 Assignment
Show info about module content

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
Show info about module content

1 Videos

  • Executive Interview with Kellyn Gorman of Oracle

1 Readings

  • Slides for lesson 1

Case study requirements

    • 3 Readings
    • 1 Assignment
Show info about module content

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
Show info about module content

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
Show info about module content

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
Instructors

Michael Mannino

Jahangir Karimi
Instructors

Jahangir Karimi