Master Dynamic Tables with Power BI

Come discover Power BI, the leader in interactive, automated, and secure dashboards! A 2-day training course to master this “Excel on steroids.” Make informed decisions quickly!

Course Description

The 14-hour Power BI training course immerses you in the Power BI ecosystem, with a focus on data transformation, creating dynamic dashboards, and cloud-based sharing. Computer proficiency—particularly with Excel—is recommended to get the most out of the course.

The content is divided into four parts:

Explore visuals using sample data provided by Microsoft to discover the features of visuals and interactivity on the canvas.
An Introduction to Power Query, a tool for connecting to various data sources and automating refreshes.
Manage relational models and use DAX to effectively manage data tables and dynamic calculations.
Focus on the Power BI Service, Microsoft’s cloud-based platform, by learning how to set up automated data refreshes and manage sharing and secure access to dashboards.

The instructor, Matthieu Lirette-Gélinas, who holds degrees in electrical engineering and engineering management and is a partner at Maverick Analytik, shares his knowledge and experience to help you master Power BI and get the most out of it.

General Objective

The goal of this training is to help participants become familiar with the Power BI ecosystem and its various tools, such as data transformation, creating dynamic dashboards, and cloud-based sharing.

Who is this training course intended for?

This training is open to everyone.

Benefits

Identify the key factors for success and the main pitfalls to avoid in a change management process
Identify the phases and key steps of the change management process
Build your credibility as you implement change on the ground (or as you roll out the change)
Develop Your Change Implementation Strategy

Course Details

Using Visuals: Using the sample data provided by Microsoft, we will explore the various features of visuals and interactivity on the canvas.
Power Query: We'll explore a data processing tool that allows you to connect to a wide variety of data sources. It will make it easier to automate data refresh processes.
Relational Models and DAX: We'll explore how to manage multiple data tables in Power BI that interact to provide the information you need. We'll also cover the DAX programming language, which we'll use to define dynamic calculations.
Power BI Service: We will discuss the features of Microsoft's cloud-based service. It allows you to set up automated refreshes and manage sharing and secure access.

Assignment Due

To earn the "Digital Strategist" certification, participants must complete an assessed project. They will need to design a dashboard in Power BI using fictional data. The project file can be submitted to the instructor for evaluation.

Duration

2 days from 8:30 a.m. to 4:30 p.m.

Rates

Member: $935
Current: $1,225

Share via email Print the lesson plan

Next session

No sessions are available at this time.
You can sign up for the waiting list for this training.

Similar Courses

Power BI: Advancing Business Intelligence

You've been working with Power BI for a while, but you feel limited in your ability to create high-performance, effective reports. This training is for you! It will enable you to create more complex and user-friendly dashboards.

2 days from 8:30 a.m. to 4:30 p.m.

Member: $995 | Regular: $1,295