Your training funded up to 50%

See available funding programs

Introduction to Power BI

Learn the basic concepts of Power BI and the features offered by the application in terms of report creation and content sharing.
Microsoft Partner

Upcoming sessions

Guaranteed to run

No date suits you?

Notify me when a session is added.

  • Duration: 1 day
  • Regular price: $500
  • Preferential price: $440

Course outline

Duration : 2 days

© AFI Expertise inc.

In today’s world, data analysis becomes extremely important when it comes time to make the right decisions. Interpreting data is therefore essential, which Microsoft’s Power BI enables you to do by organizing and visualizing it.

Audience

Anyone wanting to acquire the skills needed to become thoroughly comfortable handling data with Power BI.

Prerequisites

Sound knowledge of Excel

Objectives

  • Learn about Power BI software
  • Distinguish between various types of data
  • Identify the differences between a report and a dashboard
  • Import data into Power BI
  • Write formulas using the DAX language
  • Share a report or dashboard

Teaching method

Example- and demonstration–based instruction

Contents

Section 1: About data analysis

  • Overview of data analysis
  • Roles and responsibilities in the chain of analysis
  • Tasks of a data analyst
Section 2: Starting to build with Power BI
  • Using Power BI
  • Power BI’s various components
  • Getting acquainted with and using the Power BI service
Section 3: Getting data in Power BI
  • Getting data from files
  • Getting data from databases
  • Getting data from online services
  • Understanding the constraints for data connections
  • Selecting a storage mode
Section 4: Adapting the data model with DAX
  • About the DAX language
  • Using the CACULATE function
  • Using relationships effectively
  • Adding measures to the data model
Section 5: Creating reports in Power BI
  • Using visualizations in your reports
  • Adding visualization elements to reports
  • Choosing an effective visualization
  • Formatting and customizing visualizations
Section 6: Creating dashboards in Power BI
  • Creating dashboards
  • Setting up data alerts
  • Exploring data by asking questions (Q&A)
  • Adding a dashboard theme
  • Pinning a report to a dashboard
Section 7: Creating workspaces in Power BI
  • Sharing a report or dashboard
  • Integrating a report in Teams
  • Monitoring usage and performance

Surround yourself with the best

Pierre-Edouard Brondel
Pierre-Edouard Brondel
Trainer and Desktop Application Consultant
Renowned as an educational expert in the IT and office technology field who has accumulated more than 25 years of experience, Pierre-Édouard is first and foremost passionate about human capital.
Marc Maisonneuve
Marc Maisonneuve
Trainer and Professional Efficiency Consultant
Frédéric Paradis
Frédéric Paradis
Certified Trainer and Cloud Architect
As a certified Microsoft trainer, Frédéric describes himself as a Cloud magician who easily navigates the mythical space between technology and reality.
Virginie Louis
Virginie Louis
Efficiency Trainer, Facilitator and Spatial Intelligence Consultant
Virginie sees herself first and foremost as a facilitator: she strays from the standard training to provide solutions that are adapted to her clients’ realities and objectives.
Be aware of trends, innovations and best practices, every month.
Confidentiality
Training center accredited by Emploi-Québec, Accreditation : 0051460
GST : 141582528 – QST : 1019557738
© 2021 AFI
AFI Expertise

The AFI experience brought to you by Edgenda

At AFI, our focus is to offer you relevant training and impactful learning experiences in line with your transformation approach. Do you need support for your approach? Check out Edgenda’s services: Edgenda.com