Power BI: Advancing Business Intelligence

You’ve been working with Power BI for a while, but you feel limited in your ability to create high-performing, effective reports. This training is for you! It will help you create more complex and user-friendly dashboards.

Course Description

Following the introductory course, this training will help you refine your business intelligence skills.

The topics to be covered are as follows:

Mastering Power Query

We’ll explore more advanced concepts in Power Query, such as merging or splitting queries, using parameters, query hierarchies, and best practices for data structure

Mastery of relational models

You’ll learn about the benefits of a relational model and all the key concepts needed to fully understand it, such as the difference between a Fact and a Dimension, the use of primary and foreign keys, and much more.

Advanced DAX

You will explore the DAX language and its most useful functions, such as aggregation functions, the CALCULATE function, variables, and time intelligence concepts.

The aesthetic appeal and advanced interactivity of a dashboard

You can take your use of visuals even further by incorporating elements such as buttons, drill-downs, bookmarks, or even field settings.

Overall objective

Participants will be able to design a comprehensive, robust, and optimal dashboard solution in Power BI, regardless of their data source.

Who is this training intended for?

This training is designed for professionals responsible for creating dashboards for their organization.

Benefits

Create more complex projects that integrate multiple types of information;
Understand best practices for dashboard ergonomics;
Enhance dashboards with a user experience (UX);
Create more complex automatic calculations, such as ratios or time-series comparisons;
Understanding the DAX programming language;
Understand best practices for dashboard usability.

Course Details

Quality and Continuous Improvement

Summary of the Basic Training Course
Working with data sources in Power Query
Merge queries
Query dependencies
Introduction to the M Language
Using Power Query parameters
Design of a star-delta circuit
Advanced calculations with CALCULATE
Using Variables in DAX
Time Intelligence Function
Using buttons, bookmarks, and drill-through
Dashboard Ergonomics
Field settings

Duration

2 days from 8:30 a.m. to 4:30 p.m.

Prices

Member: $935
Current: $1,225

Share via email Print the syllabus

Next session

No sessions are currently available.
You can sign up for the waiting list for this training.

Join the waiting list

Similar courses

Master dynamic tables with Power BI

Come discover Power BI, the leader in interactive, automated, and secure dashboards! A two-day training course to master this “Excel on steroids.” Make informed decisions quickly!

2 days from 8:30 a.m. to 4:30 p.m.

Member: $935 | General admission: $1,225