Course curriculum

  • 1

    Welcome to the Course !

    • Course Introduction

    • Download Course Book, Materials, and Exercises
  • 2

    Module 1: Excel-Pivot tables

    • Module 1 Introduction

    • Rule 1: Creating Pivot tables

    • Rule 2: Number Formatting

    • Rule 3: Design Report Layout

    • 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
  • 3

    Module 2: Power Pivot

    • 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
  • 4

    Module 3: Power BI

    • Power Bi/Power Query Introduction
  • 5

    Get & Transform Data

    • 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
  • 6

    Power Bi - Model View

    • Model View
  • 7

    Analyze Data

    • Summarize Values By and Show Value As
  • 8

    Power BI - HR Training Case

    • 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
  • 9

    Power BI - Sales Case Study

    • Get Data & Transform

    • Reporting & Visualization Part 1

    • Reporting & Visualization Part 2

    • Filters & Slicers

    • Creating Bookmarks

    • Publish to Power BI Service
  • 10

    Power BI - Design Mobile Layout

    • Mobile Layout
  • 11

    Summary and final message

    • Final Message

    • Scheduling Your CDIP Exam