Power BI, Microsoft's Data Visualization solution, makes it possible to create dashboards that are rich and interactive using the various graphical elements that it offers. This course will familiarize you with its environment and will enable you to work with data in order to create your reports.
Training at your location, our location or remotely
Ref. PBI
3d - 21h
Would you like to transpose this course—without changes—for your company?
A la carte training
Do you want a training course tailored to the needs of your company and its teams? Your training will be built to measure by our experts!
Power BI, Microsoft's Data Visualization solution, makes it possible to create dashboards that are rich and interactive using the various graphical elements that it offers. This course will familiarize you with its environment and will enable you to work with data in order to create your reports.
Teaching objectives
At the end of the training, the participant will be able to:
Log in, query and associate heterogeneous data sources
Design measures with the language DAX
Discover Power BI Online Services
Model and prepare your data
Create and set up reports with Power BI Desktop
Intended audience
Anyone who wishes to consolidate information from Excel, databases, or other sources, in order to design interactive graphical dashboards.
Prerequisites
Regular use of a spreadsheet, notions about databases are desirable.
Course schedule
Introduction
Overview of Microsoft's BI solution.
The Power BI suite: Power BI Desktop, the service Power BI, and Power BI Mobile applications.
Extracting, converting, and loading data into Power BI.
Using flat files, Excel, relational databases, SSAS sources, Web.
Choosing columns, choosing rows, filtering, sorting, and deleting duplicates.
Hands-on work
Hands-on work
Converting data
Cleaning and completing data sets.
Splitting columns, formatting columns and defining the data type, joining and merging tables.
Creating calculated columns. Stacking and merging queries.
Hands-on work
Hands-on work
Defining the data model
Using Diagram view to define relationships between tables.
Designing measures with statistical functions.
DAX functions for designing elaborate measures: CALCULATE, ALL, ALLEXCEPT, FILTER, RANKX etc.
Using DAX Time Intelligence functions.
Hands-on work
Hands-on work
Designing the Power BI report
Creating reports, pages, and dashboards.
Displaying data: Table, Matrix, Chart.
Using data and formatting parameters.
Inserting visual elements. Using map visualizations.
Importing visual elements (.pbviz) from the gallery: Gauges, images, etc.
Adding filtering tools, segments, KPIs. Layout for monitor or smartphone.
Hands-on work
Hands-on work
The service Power BI online
Overview of the features of the Power BI service, storage, presentation, sharing.
Pinning visualizations into a dashboard.
Designing reports with the Power BI service.
What data sets are in Power BI ?
Demonstration
Demonstration
Practical details
Teaching methods;
Combination of lectures and hands-on work.
Customer reviews
4,6 / 5
Customer reviews are based on end-of-course evaluations. The score is calculated from all evaluations within the past year. Only reviews with a textual comment are displayed.
Dates and locations
Select your location or opt for the remote class then choose your date.
Remote class
No session at the moment, we invite you to consult the schedule of distance classes.