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

 

SAMPLE DATASETS FOR TRAINING

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

ONLINE RETAIL DATASET

ONLINE RETAIL TARGET DATASET

FINANCIAL
DATASET

 

©2020 by Adebola Udoh