Microsoft Power BI Private

Introduction to Power BI Training (PBI101)

2 days
Microsoft Power BI

Learn Power BI fundamentals: connect and clean data, model datasets, write basic DAX and M, create interactive visuals, and publish reports to the service.

Talk to a Learning ConsultantRequest a Private Class

Register or Request Training

  • Private class for your team
  • Live expert instructor
  • Online or on‑location
  • Customizable agenda
  • Proposal responses same day as request
Request Proposal

Course Overview

Build a practical foundation in Power BI. Participants will learn to connect to data, clean and reshape it with Power Query, create a basic data model, write introductory DAX and M formulas, and develop clear, interactive visualizations. The course also demonstrates how to publish reports to the Power BI service.

Course Benefits

  • Create a Power BI report and connect it to data sources such as Excel worksheets and tables.
  • Clean and reshape data in Power Query by removing rows and columns, splitting columns, creating columns, and unpivoting data.
  • Structure data with foundational data-modeling techniques.
  • Use basic DAX and M formulas to create calculated columns and measures.
  • Apply aggregate functions and conditional logic to derive useful results.
  • Build pie, donut, bar, column, card, and slicer visuals.
  • Make reports easier to explore with filtering and highlighting.
  • Understand how reports are published to the Power BI service.

Delivery Methods

Private Class
Delivered for your team at your site or online.

Course Outline

  1. Power BI Basics
    1. Connecting to Excel worksheets and tables
    2. Working in the Power Query Editor
    3. Removing unwanted rows and columns
    4. Splitting and creating columns
    5. Unpivoting columns
    6. Data-modeling fundamentals
  2. Data, DAX, and M
    1. Using basic M and DAX functions
    2. Creating calculated columns
    3. Creating implicit and explicit measures
    4. Calculating aggregate results
    5. Applying conditional logic
  3. Visualizations and Reports
    1. Creating pie and donut charts
    2. Creating bar and column charts
    3. Using card visuals and slicers
    4. Applying filtering and highlighting
    5. Publishing reports to the Power BI service

Class Materials

Each student receives a comprehensive set of materials, including course notes and all class examples.

Have questions about this course?

We can help with curriculum details, delivery options, pricing, or anything else. Reach out and we’ll point you in the right direction.

Talk to a Learning Consultant