Course Overview-Course objectives
Course introduction
()
Slides for lesson 1
Course Overview-Course topics and assignments
Course topics and assignments video lesson
()
Slides for lesson 2
Course Overview-CPI Card Group background
Executive interview
()
Slides for lesson 3
Background on CPI Card Group
Course Overview-Course software requirements
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
Data Warehouse Design-CPI Card Group background
Executive interview
()
Slides for lesson 1
Data Warehouse Design-Case study requirements
Data warehouse design background
Module 2 assignment
Self-Evaluation for the Module 2 Assignment
Data Integration-CPI Card Group background
Executive interview
()
Slides for lesson 1
Data Integration-First Bank data integration background
Executive interview
()
Slides for lesson 2
Data Integration-Pinnacol Assurance data integration background
Executive interview
()
Slides for lesson 3
Data Integration-Case study requirements
Data integration background
Module 3 Assignment
Extended transformation notes and examples
Self-Evaluation for the Module 3 Assignment
Analytical Queries and Summary Data Management-Summary data management background
Executive Interview with Kellyn Gorman of Oracle
()
Slides for lesson 1
Analytical Queries and Summary Data Management-Case study requirements
Module 4 Assignment
SQL Statements for the Module 4 Assignment
Self Evaluation for the Module 4 Assignment
Data Visualization and Dashboard Design Requirements -Case study requirements
Executive Interview with Matthew Caton of Data Source Consulting
()
Slides for executive interview with Matthew Caton
Executive Interview with Tyler Wilson on BI Platform Capabilities at CPI Card Group
()
Capstone Project Data Visualizations and Dashboard Design Requirements
Earlier Assignments from Course 4
Q & A and Error Knowledge base
Wrap Up and Project Submission-Captsone Project Submission
Executive Interview with James Gualke on the State of BI Maturity and Strategy at PDC Energy
()
Background Information on Data Visualization and Dashboard Design
Course conclusion video lecture
()