Download Course Book, Materials, and Exercises

Rule 4: Sorting

Rule 5: Filtering

Rule 6: Expand-Collapse

Rule 7: Data Analysis Type 1 - Summarize Values By

Rule 8: Data Analysis Type 2 - Show Value As

Rule 9: Data Analysis Type 3 - Insert Calculated Field

Rule 10: Date Analysis

Rule 11: Show Report Filter Pages

Rule 12: Copying Pivot tables

Rule 13: Pivot Charts

Rule 14: Dynamic Chart Labelling

Rule 15: Linking Pivot tables with Powerpoint

Rule 16: Pivot table options

Rule 17: Conditional Formatting

Rule 18: Get Pivot Data

Rule 19: Slicer

Module 2 Introduction

Enabling Power Pivot

Extract (Get data) from Text Csv

Extract (Get Data) from Excel

Extract (Get Data) from XML

Extract (Get Data) from MS Database

Project Management Case Study - Get Data

Project Management Case Study - Formatting Columns

Project Management Case Study - Adding Conditional Column Using DAX

Project Management Case Study - Creating Data Relationship

Project Management Case Study - LOOKUP DAX Function

Project Management Case Study - Creating Cost Column Using DAX

Project Management Case Study - Creating Measures

Project Management Case Study - Inserting Pivot tables from Data model

Project Management Case Study - Creating KPIs

Power Bi/Power Query Introduction

Get Data from Text CSV File

Get Data from Excel Part 1

Get Data from Excel Part 2

Get Data from Excel Part 3

Get Data from XML

Get Data from Web

Get Data from MS Database

Get Data from Folder

Conditional Column

Group By

Transform Vs. Add Column

Append Queries

Merge Queries

Model View

Summarize Values By and Show Value As

HR Training - Get Data and Clean Data

HR Training (Model View) - Manage Data Relationships

HR Training - Reports Part 1

HR Training - Reports Part 2

HR Training - Reports Part 3

Get Data & Transform

Reporting & Visualization Part 1

Reporting & Visualization Part 2

Filters & Slicers

Creating Bookmarks

Publish to Power BI Service

Mobile Layout

Final Message

Scheduling Your CDIP Exam