Understand the Power BI features

• Why is Power BI becoming the leading BI software?
• Introduce the Power BI suite.
• Understand the report design cycle.

Build your own report template

• Create a custom theme in line with your corporate identity.
• Import custom visual elements from the gallery.
• Design a reusable report template.

Clean and transform data

• Connect to a variety of data sources: CSV, Excel, PDF, Web, SQL, SharePoint, etc.
• Control the data quality and data type.
• Rearrange your data transformation steps.
• Replace values.
• Sort, filter, and delete columns.
• Create query references and duplicates.
• Merge columns.
• Create indices.
• Add conditional results.
• Create a column based on a transformation algorithm.
• Stack queries.
• Isolate duplicates.
• Document the steps and structure the queries.
• Handle errors.
• Develop a general understanding of the M language and improve queries.

Create a Star Model

• Design an efficient Power BI model.
• Establish and manage relationships.
• Create and manage hierarchies.

Focus on the key DAX functions to establish your measures

• Create a calculated column/measure/table.
• Use the DIVIDE, RELATED, COUNTROWS, DISTINCTCOUNT functions.
• Put DAX into practice with various Excel-like, dates, conditional, aggregate and iterative functions: DATEDIFF, IF, AVERAGE, SUM, SUMX.
• Apply filters on your measures with CALCULATE.
• Introduce time intelligence within your report by comparing periods, cumulating results and evaluating rolling totals: CALENDARAUTO, DATEADD, DATESYTD, DATESINPERIOD.
• Evaluate percentages and conditionally remove filters on measures: ALL, ALLEXCEPT, ALLSELECTED.

Produce a report on the canevas

• Produce a visual, Pivot table and essential charts.
• Sort on a bar chart and on a Pivot table.
• Apply conditional formatting within your visuals to highlight results.
• Insert map visuals.
• Leverage data and formatting settings.

Make your report more interactive

• Insert synchronized slicers.
• Use bookmarks to switch between views.
• Use parameters to toggle between measures on a report page.
• Insert page navigation.

Intermediate – 3 Days

1450€ face-to-face

1300€ remotely

Prices are without Tax.

Get in touch with us to schedule this Power BI course or for a quote if you are interested in organizing this training within your company.