Description

Power BI, Microsoft's Business Intelligence solution, allows companies to aggregate, analyze and visualize data from multiple sources. At the end of this training, you will be able to create complex dashboards by mastering the advanced features of this software.

Who is this training for ?

For whom ?

Anyone wishing to consolidate and deepen their knowledge in the use of Power BI in order to design advanced graphical and interactive dashboards.

Prerequisites

Knowledge of the basics of Power BI or knowledge equivalent to that provided by the Power BI internship, design dashboards.

Training objectives

Exploit the M language to create optimized data models.

Design sophisticated measurements with the DAX language.

Create complex reports with Power BI Desktop.

Create a presentation and a scenario adapted to your message.

Training program

• Presentation, reminders and best practices
  • Reminder of the design cycle of a Power BI report.
  • Expression of the need and identification of data sources.
  • Connect and prepare the data.
  • Organize tables and relationships, define measures, visualization.
  • Understand the organization of a star model, fact tables, dimension tables.
• Use queries to design a suitable model
  • Merge queries to reduce flakes.
  • Aggregate and stack sources.
  • Import data from a list of sources.
  • Customize functions and pass parameters in M ​​language.
  • Handle errors
• Working with the Time dimension
  • Use variables in DAX to create a calendar, lists and functions to create a calendar in M.
  • Cumulate by periods. Compare periods. Cumulate over sliding periods.
  • Use Time Intelligence functions to create period comparisons, totals and rolling periods.
  • Use functions: DATEADD, DATESYTD, DATESBETWEEN, DATESINPERIOD, CLOSINGBALANCE
  • Work with multiple date and double relationship columns with USERELATIONSHIP.
  • Filter data for the current period.
• Exploit advanced DAX functions
  • The cumulative calculation with the EARLIER function.
  • The CALCULATE function with several conditions and the FILTER function.
  • The function for managing empty values: ISBLANK.
  • DAX table creation functions: FILTER, CALCULATETABLE, ADDCOLUMNS, SUMMURIZE, UNION, etc.
• Display, navigation and visualizations
  • Create a background, a theme, a report template.
  • Create "Master-Detail" reports using extraction filters.
  • Use the filters tab and the selection tab.
  • Use bookmarks for navigation and Storytelling.
  • Represent with images. Prepare dynamic comments and personalize them tooltips.
  • Define a personalized visual with the Synoptic Panel.