Power BI Cursus E-Learning

• Language: English or Dutch
• Audience: Anyone who processes and analyses large amounts of data to create efficient and relevant dashboards with Power BI Desktop.
• Level: Basic
• Required knowledge level: Good Excel skills are a useful prerequisite for this course.
• Course duration: 5 hours (depending on personal speed)
• Online access: 24/7, 365 days after activation
• Certificate of Attendance included

The goal of this video course is to learn to connect to one or more data sources, prepare the raw data, extract something meaningful from it and build a modern-looking and attractive dashboard. At the end of the main modules, you can practice and go through one or more exercises. The files needed to create the exercises and the solution files can be downloaded.

Estimated time to study the essential module
Duration of the videos: 3 hours and 22 minutes Duration of the practical exercises: 1 hour and 45 minutes

• Presentation of the course

• Power BI Desktop presentation
• Work process and key concepts
• How this course is organised

• 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

• 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

• 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

• 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

• 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

• 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

• An overview of publishing on Power BI Service
• Publishing a dashboard and using it