Power BI - Introduction

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

Show all sessions
Guaranteed to run
  • Duration: 1 day
  • Regular price: $500
  • Preferential price: $440

Course outline

It is strongly recommended that you have access to Power BI Desktop to take this course.
If you do not have access to Power BI Desktop, our team can provide you with the necessary tools for the course to run smoothly, at no extra cost.


Duration : 1 day

© AFI par Edgenda 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

Other(s) Module(s) for this course:

Power BI - Optimize your use | AFI Expertise

Power BI - Building reports and dashboards | AFI Expertise

Power BI - Discover Power Query and dynamically connect your data | AFI Expertise

Surround yourself with the best

Benjamin Ejzenberg
Benjamin Ejzenberg
Trainer
Benjamin has over 8 years of experience in different institutions in Canada and Europe as an expert in data analytics. Besides having an expertise in the Power Platform (Power BI, Power Apps and Power Automate), he masters Python, SQL and data science's tools. He holds several certifications such as PL-300 (Microsoft Power BI Data Analyst).
Nicolas Georgeault
Nicolas Georgeault
Trainer
My presence among the Microsoft community over the last 25 years has earned me the title of MVP 13 times by Microsoft. I particularly appreciate the space that's offered to explain things in a simple way and to ensure that knowledge is updated according to transformations. After all these years, I can say that my great understanding of the platforms enables me to anticipate their evolution while keeping a pragmatic eye on the challenges that come with this modernization. For these reasons, I am pleased to be part of our Microsoft training program.
Marwa Attafi
Marwa Attafi
Trainer
I accumulated more than 10 years of experience in IT before coming to Quebec. I have taught computer science and have been in charge of several business intelligence projects and computer science projects to help with decision support. I have a strong experience as an analyst of business intelligence solutions, ranging from the specification and analysis of needs to the generation of dashboards. My passion for this job, my great technical skills and my sharp analytical mind add to my skills to make me a valued and precious resource for my organization.
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.