Power BI
This training course is designed for users wishing to master the fundamentals of POWER BI, the Business Intelligence suite of analytical tools, that enables them to create reports easily, collaborate on dashboards and share insights. With this training course, master the basics of this tool and discover all its specific features with the assistance of our expert trainers.
All our training courses are led by experienced consultant-trainers recognized by their peers. Our trainers are certified in each of their areas of expertise, and share their consulting experience through the training sessions.
50% of the course is dedicated to case studies.
Provision of a learner account on our e-learning platform.
Access to an account on our e-learning platform.
Digital educational documentation provided during the training.
A sign-off sheet is signed upon completion of the course.
Competence is assessed throughout the course through practical exercises.
At the end of the day, a multiple-choice test will be carried out to validate the skills acquired during the course.
An assessment of learner satisfaction at the end of the course and a follow up assessment 3 months after its completion.
Training certificate issued to the learner
Introduction to Power BI
– Presentation of the Microsoft BI offering.
– Introduction to the Power Query editor.
– Extract, transform and load data.
– Use flat files, Excel, relational databases, SSAS and Web sources.
– Choose columns, select rows, filter, sort and delete duplicates.
Getting started with Power BI
– Clean and complete data.
– Split, format and define data types, assemble and merge tables.
– Create calculated columns.
– Stack and merge queries.
– Use Diagram View, design measurements with statistical functions.
– DAX functions for elaborate measurements.
– Use DAX Time Intelligence functions
Visualize your data with Power BI
– Create reports, pages, dashboards.
– Display data: Table, Matrix, Map.
– Use data and formatting parameters.
– Insert visual elements.
– Import visual elements (.pbviz).
– Add filtering tools, segments, KPIs.
– Layout for screen or smartphone.
The quality certification has been issued under the following category of action: TRAINING INITIATIVE.