Power BI Desktop – Learn how to prepare, analyse data and how to design dynamic and interactive dashboards
Course goals
The aim of this video course is to learn to connect to one or more data sources, to prepare the raw data, to make sense out of it, and to build a modern-looking and engaging dashboard. By the end of the main modules, you will be able to practice and go through one or more exercises. The files required to do the exercises, and the solution files, can be downloaded.
Prerequisites
Target audience:
Any person who processes and analyses large volumes of data in order to create efficient and pertinent dashboards with Power BI Desktop.
Prerequisites:
Solid Excel skills are a useful prerequisite to this course.
Course goals
Course
This module provides educational videos of a total duration of 2 minutes.
Presentation of the course
• Presentation of the course
Course
This module provides educational videos of a total duration of 6 minutes.
Introduction
• Power BI Desktop presentation
• Work process and key concepts
• How this course is organised
Course
This module provides educational videos of a total duration of 56 minutes.
Connecting and preparing data
• Connecting to an Excel workbook
• Preparing the imported Excel data
• Importing an Excel file cross-table
• Exercise 1: Importing orders from an Excel file
• Connecting to a database
• Extracting, cleansing and filtering data from the imported base
• Creating columns from examples and adding conditional columns
• Connecting to other data sources (txt, csv, pdf, SharePoint list)
• Exercise 2: Importing the tables from the French Books Sales file
• Solution 1: Importing orders from an Excel file
• Solution 2: Importing the tables from the French Books Sales file
Course
This module provides educational videos of a total duration of 44 minutes.
Setting up the model
• Introduction and steps
• Setting up the relationships
• Creating the calendar table
• Creating the explicit measures
• Organising the fields in the Model view
• Exercise 3: Setting up the Financial file model
• Exercise 4: Setting up the Fench Books Sales file model
• Solution 3: Setting up the Financial file model
• Solution 4: Setting up the Fench Books Sales file model
Course
This module provides educational videos of a total duration of 48 minutes.
Creating a dashboard and visuals
• Creating a dashboard page
• Creating a bar chart
• Creating a line chart
• Creating a pie chart
• Displaying summary data with a card
• Displaying geographical data
• Creating a table
• Creating a cross-table
• Using slicers
• Exercise 5: Creating charts using the French Books Sales file
• Exercise 6: Creating a table and a cross-table using the French Books Sales file
• Solution 5: Creating charts using the French Books Sales file
• Solution 6: Creating a table and a cross-table using the French Books Sales file
Course
This module provides educational videos of a total duration of 31 minutes.
Creating DAX formulas
• The filter context and its propagation: Dax’s key concept
• Using the CALCULATE function
• Using the ALL function
• Counting with the COUNTROWS and the DISTINCTCOUNT functions
• Analysing trends using the DATEADD function
• Exercise 7: Use the CALCULATE, COUNTROWS and DATEADD functions to create a table using the French Books Sales file
• Solution 7: Use the CALCULATE, COUNTROWS and DATEADD functions to create a table using the French Books Sales file
Course
This module provides educational videos of a total duration of 8 minutes.
Interactions
• Mastering natural interactions
• Drilling into detailled data
• Exercise 8: Adjusting interactions in the French Books Sales file dashboard
• Solution 8: Adjusting interactions in the French Books Sales file dashboard
Course
This module provides educational videos of a total duration of 51 minutes.
Applicative design: dashboard design example
• The principles of applicative design (user experience design)
• Preparing the page backgrounds and the theme
• Adding visuals
• Adding buttons to the tabs
• Using bookmarks
• Adding slicers and dynamic titles
• Adding tooltips
• Using conditional formatting in tables
• Overview of the process
Course
This module provides educational videos of a total duration of 9 minutes.
Publication
• An overview of publishing on Power BI Service
• Publishing a dashboard and using it