Power BI Training – Design a Report from Scratch
This Power BI Desktop training module can be organized in Luxembourg, Brussels, Paris or anywhere within your offices. It is intended for participants who wish to run through the entire process of designing a Power BI report from data transformations and modelling to writing DAX measures and bringing everything together into dynamic charts and dashboards.
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 canvas
- 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.
- Introduce parameters to toggle between measures on a report page.
- Insert page navigation.

Intermediate – 3 Days
1250€ face-to-face
1100€ remotely
Prices are without Tax and per person within a group including different companies.
Get in touch with us to schedule this course focusing on Power BI Desktop or to get a quote for custom content.