top of page

COURSES

Here you find details of the Training Modules

POWER BI FOR BEGINNERS (ACCELERATED)

Objectives

  • Rapidly analyse, transform and present data

  • Understand the Power BI platform

  • Set up queries to extract and transform data

  • Create efficient data models

  • Design and publish interactive reports

  • Confidently use basic DAX calculations


Topics

​

MODULE 1

  • Introduction          

  • Loading Data

  • Data Modelling

  • Power Query Fundamentals

  • Basic M-Language

​

MODULE 2

  • Power BI Visualisations

  • Basic Visualisations​

  • Formatting Visuals

  • Types of Filters


MODULE 3

  • DAX Fundamentals

  • Calculated Columns

  • Calculated Measures

  • Power BI Service

  • Publishing and Sharing Reports

  • Creating Dashboards

  • Case Study​ Project

POWER BI FOR BEGINNERS (INTENSIVE)

Objectives

·         Rapidly analyse, transform and present data

·         Understand the Power BI platform

·         Set up queries to extract and transform data

·         Create efficient data models

·         Design and publish interactive reports

·         Confidently use basic DAX calculations


Topics

​

MODULE 1

·         Introduction          

·         Power BI Suite​

·         Loading Data (CSVs, Excel, PDF, Google Sheets, Web, Folders)

·         Understanding Relational Data Modelling/Relationships

·         Power Query Fundamentals

·         Cleaning Data​

·         Transforming Data

·         Basic M-Language

​

MODULE 2

·         Power BI Visualisations

·         Basic Visualisations​

·         Map Visualisations

·         Formatting Visuals

·         Types of Filters

·         Report Visual Interactions


MODULE 3

·         DAX Fundamentals

·         D​AX Functions

·         DAX Calculation Types

·         Calculated Columns

·         Calculated Measures


MODULE 4

·         Power BI Service

·         Publishing and Sharing Reports

·         Creating Dashboards


MODULE 5

·         End-To-End Case Study​ Project

·         Build Data Model

·         Create Report

·         Publish Report

POWER BI FOR DEVELOPERS

***Course Prerequisite***

Completed Power BI For Beginners / Power BI User

​

Objectives

  • Understand complex data modelling scenarios

  • Using M to extend the standard data extraction and transformation capabilities of Power BI

  • Advanced Data Visualisations beyond the basics

​

Topics

​

MODULE 1

  • M Query

    • M Syntax

    • M Query Basics

    • Variables and Parameters

    • Expanding Lists

    • M Query Functions


MODULE 2

  • Loading Data 

    • Google Analytics, Web Scraping, Power BI Data sets

    • Query Folding


MODULE 3

  • Advanced Data Modelling

    • Filtering

    • Cross-Filtering and Time Intelligence

    • Many to Many with DAX

    • Role Playing Tables with DAX


MODULE 4

  • Advanced Visualisations

    • Digital Story Telling

    • Bookmarks

    • Selection Pane

    • Drill through

    • Visuals with DAX

    • Custom Visuals

    • Custom Themes

    • Measures in Sub Folders


MODULE 5

  • Advanced DAX

    • D​AX Variables in Measures

    • ​​What If Analysis

    • ​Dynamic Measures

    • Financial Measures

​

MODULE 6

  • Power BI Administration

    • Data Refresh

    • Scheduling Data Refresh

    • Incremental Refresh

    • Implementing Row Level Security

​

  • Power BI Embedded

​

  • End-To-End Case Study​

    • Build Data Model

    • Create Report

    • Refresh Report

POWER BI FOR P6/PMO ANALYSTS

Learning more advanced features in the Visualisation

Resources: Resources and Tips

SAMPLE DATASETS FOR TRAINING

Here are customised sample data to be used during the training sessions

​

ONLINE RETAIL DATASET

​

Click to Download

ONLINE RETAIL TARGET DATASET

Click to Download

​

FINANCIAL
DATASET

Click to Download

Resources: Resources and Tips
bottom of page