Class Schedule and Materials - Last updated on Sept 9, 2019

The class content is organized by milestones and modules. Each module is provided in one ZIP file which includes a study guide, lecture notes, examples, and labs (with selected answers).

Milestone 0: BI Introduction

Module #1 BI Overview

Lecture Notes: A comprehensive overview of BI and analytics

View more on edocr

Module #2 Microsoft BI

lm2-msbi.zip

Introduction of Microsoft BI and Analytics products.

Milestone 1: Data Storage

Module #3 Dimensional Model

lm3-dimmodel.zip

Dimensional model is the basis for data warehouse design, OLAP, and dimensional analysis.

Module #4 Data Warehouse

lm4-dw.zip

Overview of data warehouse/mart and their designs

Milestone 2: Data Integration

Module #5 ETL

lm5-etl.zip

Introduction of ETL (extract, transform, load)

Module #6 Data Transformation

lm6-datatransformation.zip

Focus on data transformation with more details.

Milestone 3: OLAP

Module #7 OLAP

lm7-olap.zip

Introduction of OLAP concepts, technologies, and systems.

Module #8 MDX

lm8-mdx.zip

MDX is the query language to query OLAP cubes.

Milestone 4: Client Query and Report

Module #9 Excel Query

lm9-reporting-excel.zip

Excel provides easy to use PivotTable and cube functions to work with OLAP.

Module #10 Power BI Report

lm10-powerbi.zip

Power BI is the latest self-service BI trend for analysis and reporting.