Power BI Desktop - Fundamentals

Knowledge of the Windows work environment

At the end of the training, the participant will be able to:

• create reports with Power BI Desktop
• manipulate data in Power Query
• manipulate a data model in Power Pivot

Interface

• What is Power BI?
• Basic Concepts
• Components of Power BI Desktop:
  • Power Query
  • Power Pivot
  • Power View

Import data

• Load data from different sources:
  • Excel files
  • Text files
  • Relational Databases
  • Web Pages
• Updating Data

Data Model

• Create relationships in the data model
• Add measures (aggregate calculations) to a table
• Unidirectional and bidirectional filters
• Add a column of data
• Using date and time data
• Introduction to DAX (Data Analysis eXpressions)

Visualisations

• Create a simple report
  • Charts
  • Tables
  • Matrixes
  • Slicers
• Add visualisations
• Filter a page
• Filter a report
• Explore data from a visualisation (drill down)

Power Query

• Transform Data:
  • Sort
  • Filter
  • Exclude rows depending on their positions
  • Data types
  • Pivoting data
  • Unpivoting data
  • Group Data
• Duplicate a query
• Create a reference to an existing query
• Add columns:
  • Use the automatic features
  • Use functions
• Combine queries:
  • Append a query to another query
  • Merge queries
• Add parameters
• Create a function
• Overview of the advanced editor

Online Power BI

• Share data by using the Microsoft Power BI services

At the end of the training, the participants will receive a certificate of attendance delivered by the House of Training.