Power BI Advanced Course

Duration

7 hours

Training mode

Online via zoom or onsite

Cost

£1000 + VAT per participant
(volume discounts available)

Audience

Business Managers

Analysts

Business Intelligence teams

Data Warehousing teams

Requirements

Power BI Desktop needs to be installed

Basic Power BI understanding

Familiarity with Power BI and Power Query interface

Basic understanding of DAX and M syntax

Overview

You have started your journey with Power BI already but now you want to achieve more with it. You can! You just need a little more knowledge of coding in Power BI and good practices.

Having delivered 500+ Power BI projects, at Vidi Corp we aim to make our training as close to real-life experience as possible. We are not just trainers, we also bring valuable experience of hands-on Power BI work in the industry for various clients including the UK Ministry of Defense, Teleperformance and Google. We have been able to absorb the advanced knowledge of Power BI throughout our projects and we are keen to pass it to you!

This course will provide you with advanced understanding of DAX functions, good and bad data modeling practices and advanced ways to customise your data visualization.

Once you have this knowledge, you will become a shark in the ocean of data, free to hunt for those valuable insights!

What you will learn

1

Introduction
  • DAX and M applications
  • Implications of good and bad DAX/M practices
  • Implications of good and bad data modeling practices

2

M Coding
  • Working with simple M values (text, date, numbers,etc)
  • Advanced data types: lists and records, tables
  • Extracting and transforming values from lists and records
  • M expressions (let, if, each, etc)

3

DAX Coding
  • DAX formulas to filter a table (FILTER,, etc)
  • DAX formulas to ignore filter context (ALL, ALLEXCEPT)
  • CALCULATE function
  • SELECTEDVALUE function and using it to create interactive elements
  • Formulas to work with tables (LOOKUPVALUE, RELATED, etc)
  • Time Intelligence functions

4

Relationships
  • Building a date table
  • Cross filter direction intricacies (setting it to single vs both ways)
  • Many-to-many relationships
  • Ambiguity in table relationships
  • Supplementing relationships with dax (USERELATIONSHIP, TREATAS)

5

Data modeling
  • STAR Schema advantages and disadvantages
  • STAR Schema vs Snowflake
  • Single table schema

6

Data visualisation
  • The concept of data storytelling
  • Good and bad practices of designing data visualization

Video training resources

I Got Certified as a Microsoft Power BI Developer

Dashboard Design tutorial in Power BI

How to use Bookmarks in Power BI – 2023

How to use MERGE and APPEND queries in Power BI and Power Query

From our blog