Objectives of the training
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.Targeted audience
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.Trainers
Benefits for Participants
⦁ 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
Course architecture
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)
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)
Pedagogical details
Type of training
Training Notes
100% remote training. Accessible anytime, anywhere. One year of access to training and digital manual.
Private or personalized training
If you have more than 8 people to sign up for a particular course, it can be delivered as a private session right at your offices. Contact us for more details.
Request a quotePrivate or personalized training
If you have more than 8 people to sign up for a particular course, it can be delivered as a private session right at your offices. Contact us for more details.
Request a quote