What you learn in this Power BI course
  • Power BI and Excel
  • Connecting Power BI to data
  • Creating Power BI data visualizations
  • Publishing Power BI visualizations
  • Transforming Data with the Query editor
  • Data Modeling with Power BI
  • Using Data Analysis Expressions (DAX)
  • Refreshing data and setting refresh frequency
  • Understanding and Interpreting data
  • Using AI in Power BI

Power BI course - introduction - Course Dates

All classes are led by a live instructor. Class times listed are Eastern time.

Live instructor-led class online
$795.00
Live instructor-led class online
$795.00
Live instructor-led class online
$795.00
Live instructor-led class online
$795.00

Power BI Course Topics

Power BI and excel
  • Introduction to using excel data in Power BI
  • Importing and accessing excel data in Power BI
  • Using power view and power pivot to Power BI
Connecting Power BI to data
  • Data sources available to import into Power BI
  • Creating a connection to a data source
  • Connecting to databases 
  • Loading data from files
  • Getting data from services and content packs
Transforming data with the query editor
  • Understanding the query editor
  • Transform data using the query editor
  • Cleaning data and removing improper formatting
Data modeling with Power BI
  • Understanding data modeling
  • Types of data models
  • Creating and managing data relationships
  • Establishing relationship types
  • Loading data from individual tables
  • Working with and configuring tables
  • Introduction to data analysis expressions (dax)
  • Using dax in Power BI
  • Working with dax functions
  • Performing dax calculations
  • Calculating columns, measures, and tables
  • Working with times and dates
  • Understanding differences between live and refreshed data
  • Refreshing data and setting refresh frequency
Power BI data visualizations
  • Overview of Power BI data visualization
  • Creating visualizations in Power BI
  • Adjusting Power BI data visualizations
  • Adding text, images, and shapes
  • Editing colors in charts and graphs
  • Defining page size and object locations
  • Formatting Power BI visualizations 
  • Defining relationships between visualizations
  • Defining drill-downs to gather more data
  • Creating custom visualizations
  • Creating dashboards
Publishing Power BI reports
  • Publishing options for Power BI reports
  • Publish reports online
  • Printing Power BI reports
  • Using Power BI cloud-based services
  • Sharing reports internally and externally’
  • Managing security of Power BI reports and controlling access
  • Using row-level security
  • Using Power BI workspaces 
Understanding and interpreting data
  • Quick insights in Power BI
  • Ask questions of your data with natural language
Using AI in Power BI
  • Data interpretation capabilities with AI
  • AI reporting options

Power BI course instructors

AGI instructors are Power BI professionals and skilled teachers. You'll learn from a live Power BI professional that brings years of experience that will help you learn Power BI quickly and easily.

Grace
Grace

MS, Information Design

BA, Digital Communications

Adjunct Professor, St. Olaf

Shirley
Shirley

MLA, Harvard

MS, Bentley

BS, Bentley

Elizabeth
Elizabeth

BS, Finance

Teaching Assistant, Virginia Tech

Accounting & Finance Roles

Fred
Fred

MIT, Data Science

SCRUM Master

Certified Technical Trainer

Custom and private Power BI classes

This Power BI course is available as a private class. Curriculum can be customized for your specific needs. Power BI classes can be delivered at your location, online, or in our classrooms. For more information, call 781-376-6044 to speak with a training consultant or contact us.

Power BI course versions

There are three versions of Power BI. This Power BI course is beneficial for users of any of these three versions. You can use the free Power BI in Fabric, previously known as Power BI Desktop, or Power BI Pro, or Power BI Premium.  You will need Power BI Pro or Premium to publish reports, and the Premium version is necessary for accessing AI capabilities.

If attending a Power BI course in our classrooms, the app is provided. If attending an online Power BI course, please download the app before starting the course.

Who benefits from this Power BI course

This two-day course is useful for anyone who uses Excel and needs to visualize their data, going beyond Excel’s default charts and graphs. Whether you are a business analyst, data professional, or an Excel user, this course enhances your data manipulation and visualization skills. By seamlessly combining Power BI and Excel, you will be equipped with a holistic set of skills to efficiently manage, analyze, and create data representations and visualizations.

You can attend this PowerBI class with a live instructor online or in-person. You can also schedule this as corporate Excel training for your group or organization.

Suggested follow-up course: Advanced Power BI course for transforming data

Frequently Asked Questions for Power BI course - introduction

Which Excel course covers Pivot tables and V LOOKUP?

You will learn Pivottables and VLOOKUP in the intermediate Excel course. These topics are covered in-depth with hands-on projects, and the ability to ask questions from a live instructor.

Available Delivery Methods For This Class

CLASSROOM
LIVE ONLINE
PRIVATE
MY LOCATION