Objectives
The objective of this training is to learn how to transform your data into clear and impactful insights through the creation of modern and interactive dashboards, with guided hands-on exercises.
Is it for you ?
Anyone who needs to process and analyze large volumes of data in order to design relevant and effective dashboards using Power BI Desktop.
Prerequisite
An intermediate level of Excel proficiency is a useful prerequisite for taking this e-training course.
Your benefits
- Discover the Power BI ecosystem and its workflow cycle
- Learn how to import and prepare your data with Power Query
- Effectively model your datasets using relationships and measures
- Design modern, interactive dashboards incorporating visuals
- Discover filters and interactions
- Publish and share your reports on Power BI Service or outside the platform
Content
Introduction and overview
- Overview of Power BI (Desktop, Service, Platform)
- Workflow
- Explore different common usage scenarios
Connecting and preparing data
- Connect to an Excel workbook
- Transform imported Excel data
- Import a pivot table from an Excel workbook
- Refreshing report data
- Connecting to a database
- Filtering data from the imported database
- Adding columns from examples and conditional columns
- Connecting to a semantic model
- Connecting to other data sources (txt, csv, pdf, SharePoint list)
See more + / -
Setting up the model
- Introduction and steps: role of the Model view
- Setting up relationships
- Creating the time table
- Creating explicit measures
- Organizing fields in the Model view
Creating a dashboard and visuals
- Create a template page for the report
- Enable and use the Interaction on object feature
- Create and format a bar chart
- Create and format a line chart
- Create and format a pie chart
- Representing global data with a map
- Representing geographic data
- Creating a simple table and a cross-tabulation table (matrix)
Interactions
- Using the Filters pane
- Setting default interactions
- Using segments
- Exploring data details with tooltips
- Deepening analysis with or without DAX formulas
- Changing the implicit measure aggregation function
- Use visual calculations
- Improve the display format of visual calculations
- Key DAX concepts
- Add with SUM and SUMX
- Count and enumerate with the COUNTROWS and DISTINCTCOUNT functions
- Use the CALCULATE function
- Analyze changes over time with the DATEADD function
Distribution and sharing
- Share a report outside the Power BI Service platform
- Publish or use a report published on Power BI Service
Supplementary book
This module offers you access to digital course materials.
Power BI Desktop – Everyday reporting and data analysis (3rd edition)
💡 Useful information
100% online training. Accessible anytime, from anywhere, giving a one year of access to the training. If you have any questions regarding registration, the language of instruction, or cancellation policies, please consult our FAQ .
Trainers
Private or personalized training
Do you have several employees interested in the same training course? Whether in person at your offices or remotely in virtual mode, we offer private training courses tailored to your team's needs. Group rates are available. Contact us for more details or request a quote online.
Request a quote