3-Day Power BI Desktop Series 1 - Data Model, DAX & Dashboard Visualization Course (Exclusive Course)

Course Overview

This course is created, owned, and trained by its original creator, Mr. Alaster Leong. Learn from the original creator.

Disclaimer: If you are looking for a surface-level or spoon-fed Power BI Desktop course, this may not be the course for you, as we only provide in-depth training.

Skills in data analysis, reporting and the creation of dashboards are highly valued in today’s business environment. For the 16th consecutive years, Microsoft Power BI has been recognised as a Leader in the 2023 Gartner Magic Quadrant for Analytics and Business Intelligence Platforms.

As Microsoft Power BI continues to outperform its competitors, securing its position as the dominant leader of the world’s most powerful self-service business intelligence (BI) platform, it remains an indispensable tool for both seasoned data professionals and beginners alike. Microsoft Power BI can help you get more insights from your data on your computer or in the cloud.

Regardless if you are a data analyst, data scientist or even a power user of Excel who manipulates data for various reporting requirements to your organization, Power BI allows you to be productive and creative with what you build. With Power BI you can connect to hundreds of data sources, build complex relational models using simple and intuitive tools, and design stunning, interactive dashboards from scratch – all for FREE (You can download from here or refer to the installation guide here).

There is no beneficial use on using Microsoft Power BI without first knowing how to build the data model.

What sets us apart from other training providers providing Microsoft Power BI courses?

We do not have pre-built databases for you. This is a project-based learning course, where you will learn to build database from scratch from the raw data provided (just as it happens in the real world) , clean up the data, build the data model with table relationships and use DAX formulas to generate other required data and KPIs, and display out as a final report.
You will learn the importance of Data Normalisation and how it works.
We understand the frequent and significant changes to the Power BI interface, so we always update our Power BI Desktop training and materials to ensure they reflect the latest version of Microsoft Power BI Desktop. This way, you stay up to date with the most recent version.

Next, we will take your skills to the next level by delving deeper and acquiring a more thorough understanding of how Power BI handles time data to support the needs of Business Intelligence analysis by enabling you to manipulate data using time periods and build and compare calculations over those periods.

Lastly, you will finish off by learning the usage of various visualization tools in Power BI on the project you have built from scratch to add stunning and interactivity to your dashboard report.

Course Information

Fee

SGD 1,380.00 (Nett)

Absentees will be charged the full course fee

Includes lunch and two coffee breaks with light snacks, unless otherwise stated

Time

9:00am to 5:00pm (21 hours)

Mode

Classroom @ Hotel

Dates

15-17 Jan 2025
17-19 Mar 2025
19-21 May 2025
14-16 Jul 2025
15-17 Sep 2025
17-19 Nov 2025

Important Note

Closed Class

Important Note

Closed Class

Why Learn With Us?

Objectives

Upon completion of the course, learners will be able to:

Get started with Microsoft Power BI Desktop confidently
Connect to source data
Use Power Query
Transform and shape data
Use Database normalization
Build a relational data model
Understand basic DAX functions
Create calculated fields and measures using DAX formulas
Create KPIs using Matrix
Use some powerful Time intelligence DAX functions like DATESYTD, DATESQTD, DATESINPERIOD, etc.
Use various visualization tools like Slicer, KPI, Gauge, Map, Treemap, Bar, etc
Apply formatting to visual objects
Apply different types of filter to the visual objects
Apply Drillthrough Filters
Build a business dashboard with visualization tools
Edit report interactions between objects
Add and link bookmarks
Use “What-If” Parameters
Manage and view as roles

Who Should Attend

This course is for:

Anyone who is looking for a hands-on, project-based introduction to Microsoft Power BI Desktop
Data Analysts and intermediate-to-advanced Excel users hoping to develop advanced data modeling, dashboard design and business intelligence skills
Who wants to monitor their business metrics, department process or KPIs e.g. accountants, human resource, business, sales, finance, stock or forex traders, business owners etc
Aspiring data professionals looking to master the #1 business intelligence tool on the market

Methodology

This is a hands-on practical course. Trainer will walk through the topic step-by-step. Learners will be provided with exercise files on every topic to effectively apply what have been taught. A short Q & A session will be available after each topic.

Prerequisites

This course is designed for PC/Windows users (currently not available for Mac)

Must have at least Intermediate Excel skills
Proficient with Excel functions like IF and nested functions is a plus
Well versed with Excel Pivot Table is a plus
A laptop with Microsoft Power BI Desktop latest version installed (to align with the trainer Power BI Desktop interface and course material)

Things To Bring

A Windows operating system laptop with

Power BI Desktop latest version (FREE) pre-installed (personal laptop is preferred as some company laptops may have security restrictions)
Laptop power adaptor and a USB mouse

Download the Power BI Desktop step-by-step installation guide here.

Important Note:

This Microsoft Power BI Desktop training, including training materials we provide will always reflect the most recent version of Power BI Desktop. Thus, it is imperative that you ensure the most recent version is installed or updated before attending the class to align with the trainer Power BI Desktop interface and training material for a smooth learning experience.

Course Outline

1. Introduction to Microsoft Power BI Desktop

2. Connecting & Shaping Data

3. Creating Relational Data Model

Database normalization
Data tables vs Lookup tables
Primary and foreign keys
Creating table relationships
Managing & editing relationships
Active vs Inactive relationships
Relationship cardinality
Filter flow
Hiding fields from Report view

4. DAX Formulas

Calculated columns
Measures
DAX Syntax
DAX operators
Math & Stats functions
Logical functions
Text functions
Filter functions
Date & time functions
Iterator functions

5. Time Intelligence Formulas

Modify the project source path
Creating a Calendar table
Time Intelligence DAX functions – Running Totals
Time Intelligence DAX functions – Date Intervals

6. Dashboard Visualization

Familiarize the Report view
Inserting objects and basic charts
Working with formatting
Types of filter
Working with filters
Matrix visual
Date Slicer visual
Card and KPI visual
Text Card visual
Map visual
Treemap visual
Line and Area visual
Trend Lines and Forecast
Gauge visual
Editing report interactions
Drillthrough filters
Adding and linking bookmarks
“What-If” parameters
Managing and viewing as roles
Decomposition Tree (new visual)

7. Optional Topics

Importing custom visual
Phone layout
Publishing to Power BI Service
Data visualization best practices

Our Dedicated Lead IT Trainer - Mr. Alaster Leong

This course is created, owned and trained by Mr. Alaster Leong. Learn from the original creator of this course.

Alaster has been training adult learners in IT in both the private and public sectors since 1986. Alaster’s career before training centred around IT for over 12 years, as he held various roles within software development. He has earned himself a Microsoft Office Specialist (MOS) certification and he is an existing Trainer approved by People’s Association (PA). He was also a former Associate Trainer with the Civil Service College.

He specialises on training Microsoft Applications and Adobe Photoshop. Based on his vast experience and keeping abreast with the emerging trends, tools and technologies with the IT industry, especially software, he has extensively involved in developing several course outlines and course materials and conducting training to equip learners with skills in-demand or likely to be most important in the jobs of the future work.

Alaster constantly explore innovative and effective ways in imparting knowledge and engaging his learners at the same time. He also focuses his training on providing practical solutions to real-life problems, especially Excel. He is more than willing to help overcome various problems faced by his learners that arise in their workplace in applying their newly-acquired knowledge and skills any time after the course. He is well-known for his dedication, commitment and passion to training that makes him well-liked and appreciated by his learners.