Course : Power BI: Advanced

Power BI: Advanced

4,4 / 5

Power BI, Microsoft’s Business Intelligence solution enables companies to aggregate, analyze, and visualize data from multiple sources. By the end of this training, you’ll be able to create complex dashboards through proficiency in the advanced features of this software.

Inter

In-house

Custom

Practical course in person or remote class

Ref. BIG

Price : 1620 € E.T.

2d - 14h00

Dates and Registration

Teaching objectives

At the end of the training, the participant will be able to:

Use the language M to create optimized data models
Design sophisticated measures with the language DAX
Create complex reports with Power BI Desktop
Create a presentation and scenario tailored to your message.

Intended audience

Anyone who wants to consolidate and expand their knowledge in the use of Power BI in order to design advanced-level graphical and interactive dashboards.

Prerequisites

Knowledge of Power BI basics or knowledge equivalent to that provided by the course “Power BI: Designing Dashboards” (code PBI).

Course schedule

Overview, refreshers, and best practices

Refresher on the design cycle of a Power BI report.
Connecting and preparing data.
Understanding the structure of a star schema, fact tables, and dimension tables.
Expression of need and identifying sources of data.
Organizing tables and relationships, defining measures, visualization.

Using queries to design an appropriate model

Merging requests to reduce snowflakes.
Aggregating and stacking sources.
Importing data from a list of sources.
Customizing functions and passing parameters in M.
Managing errors.

Hands-on work

Designing a single table from multiple queries. Importing a set of workbooks and files in batches. Designing a function for cleaning up text.

Working with the Time dimension

Using variables in DAX to produce a calendar, lists, and functions to produce a calendar in M.
Cumulative sum by period. Comparing periods. Cumulative sum over sliding periods.
Using Time Intelligence functions to create period comparisons, cumulative sums, and sliding periods.
Using the functions: DATEADD, DATESYTD, DATESBETWEEN, DATESINPERIOD, CLOSINGBALANCE.
Working with multiple date columns and double relationships with USERELATIONSHIP.
Filtering data over the current period.

Hands-on work

Creating a calendar table incorporating paid holidays. Measuring progress. Doing a cumulative sum over 12 sliding months.

Using advanced DAX functions

Calculating a cumulative sum with the EARLIER function.
The CALCULATE function with multiple conditions and the FILTER function.
The function of managing blank values: ISBLANK.
DAX table creation functions: FILTER, CALCULATETABLE, ADDCOLUMNS, SUMMURIZE, UNION, etc.

Hands-on work

Taking advanced measurements. Creating cumulative sum and sorting columns. Filtering sorted columns. Working with tables in memory.

Display, navigation, and visualizations

Creating a background, a theme, a report template.
Using bookmarks for navigation and storytelling.
Representing with images. Preparing dynamic comments and customizing tooltips.
Defining a personalized visual with the Synoptic Panel.
Creating Master Detail reports using drillthrough filters.
Using the filter pane and selection pane.

Hands-on work

Defining a graphical identity and incorporating it into a report template. Setting up navigation and exploration tools. Presenting a scenario.

Practical details

Teaching methods;

Combination of lectures and hands-on work.

Customer reviews

4,4 / 5

Customer reviews are based on end-of-course evaluations. The score is calculated from all evaluations within the past year. Only reviews with a textual comment are displayed.

Dates and locations

Select your location or opt for the remote class then choose your date.

Remote class