Power BI Training
Power BI
Turn data into opportunity with interactive data visualization tools from Microsoft Power BI
French / English
Certificate
Overview
Power BI, Microsoft’s data visualization solution, allows you to create rich and interactive dashboards thanks to the multiple graphic elements it offers. This course will familiarise you with its environment and enable you to manipulate data and create your own reports.
Prerequisite
To attend this Power BI Initiation course in the best conditions, it is necessary to have a current practice of office automation
Goals
Connect, query and combine heterogeneous data sources
Designing measurements with the DAX language
Discover Power BI Online services
Modelling and preparing data
Creating and formatting reports with Power BI Desktop
Training Program
GETTING STARTED WITH POWER BI DESKTOP AND THE POWER BI SERVICE
- Overview of Power BI
- Power BI modules
- Power BI Desktop
- Power BI Online (Service)
- Mobile applications
- Power BI modules
- Power BI Desktop
- Power BI Online (Service)
- Mobile applications
GETTING THE DATA
- Connecting to data
- Data cleansing and transformation
- Process data that is not regularly formatted
- Data cleansing and transformation
- Process data that is not regularly formatted
MODELLING IN POWER BI
- Data model and relationships
- Creation of calculated columns
- Creation of measures
- The case of temporal data
- Time Intelligence functions
- Creation of calculated tables
- Creation of calculated columns
- Creation of measures
- The case of temporal data
- Time Intelligence functions
- Creation of calculated tables
CREATING REPORTS WITH POWER BI
- Creation of a simple return
- Combined graphics
- Use of segments
- Use of the cards
- Tables and matrices
- Point clouds
- Advanced graphics
- Gauges
- Colour management
- Improving formatting
- Creating Interactions between Visualisations
- Managing missing data
- Managing hierarchies and drill-down
- Combined graphics
- Use of segments
- Use of the cards
- Tables and matrices
- Point clouds
- Advanced graphics
- Gauges
- Colour management
- Improving formatting
- Creating Interactions between Visualisations
- Managing missing data
- Managing hierarchies and drill-down
DISCOVER THE DATA
- Data mining
- Create and configure a dashboard
- Ask questions in natural language
- Create custom Q&A's
- Create and configure a dashboard
- Ask questions in natural language
- Create custom Q&A's
PUBLISHING AND SHARING FROM POWER BI DESKTOP
- Publishing reports from Power BI Desktop to the Power BI service
- Print and export dashboards
- Publication and updating of data
- Integration with the Office 365 suite
- Introducing Power BI Mobile
- Creating user groups and security
- Workspaces and applications
- Use of gateways
- Power BI and OneDrive, Power BI and SharePoint
- Print and export dashboards
- Publication and updating of data
- Integration with the Office 365 suite
- Introducing Power BI Mobile
- Creating user groups and security
- Workspaces and applications
- Use of gateways
- Power BI and OneDrive, Power BI and SharePoint
LICENSING
- Free license
- Power Bi Pro
- Power BI Premium
- Power Bi Pro
- Power BI Premium
INTRODUCTION TO DAX (Data Analysis Expressions)
- Types of calculations
- DAX functions
- The variables in DAX
- Table relations and DAX
- DAX tables and filtering
- DAX functions
- The variables in DAX
- Table relations and DAX
- DAX tables and filtering
OUR BEST PRACTICES FOR USING POWER BI EFFECTIVELY AND EFFICIENTLY
- Optimisation of the data model
- Build a readable and attractive report
- DAX code management
- Metadata management
- Temporal data- Geolocation
- Build a readable and attractive report
- DAX code management
- Metadata management
- Temporal data- Geolocation
Project
01.
Final project to be carried out :
Create a Power BI report to analyse projects
