Microsoft Power BI Private

Data Analysis with Power BI (DATA210)

2 days
Microsoft Power BIData

Turn raw data into interactive Power BI reports and dashboards: connect and clean data, build a star-schema model and DAX measures, and publish live KPIs.

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

This course is designed for analysts and reporting staff who need to turn raw organizational data into interactive reports and dashboards in Microsoft Power BI. It covers the end-to-end workflow, from connecting and preparing data through modeling, visualization, and publishing live dashboards that stakeholders can monitor and share.

Course Benefits

  • Connect Power BI to different data sources, including Excel spreadsheets, relational and non-relational databases, and cloud services.
  • Use the Power Query Editor effectively to clean and transform data and to verify data structure and quality.
  • Build a star-schema data model with appropriate table relationships, filters, and hierarchies.
  • Create measurements, aggregations, and calculations using DAX to be able to better understand takeaways from datasets.
  • Create interactive and accessible dashboards that effectively tell the data story with compelling data visualizations.
  • Publish reports and assemble dashboards in the Power BI Service that show KPI trends and status indicators.

Delivery Methods

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

Course Outline

  1. Day 1: Connecting, Cleaning, and Modeling Data
    1. Getting Started in Power BI: Desktop views; report vs. dashboard vs. service distinctions; workspace navigation.
    2. Connecting to Data Sources: Excel files; relational databases; non-relational databases; cloud services; connector selection.
    3. Cleaning and Transforming Data with Power Query: Data and column profiling; removing duplicates; handling nulls; merging queries; append operations.
    4. Designing the Star Schema Data Model: Table relationships; cardinality; filter direction; hierarchies.
  2. Day 2: Measures, Reports, and Dashboards
    1. Building DAX Measures: Measures vs. calculated columns; aggregations; quick measures; formatting.
    2. Creating Interactive, Accessible Reports: Visual selection; page formatting; cross-filtering; accessibility standards.
    3. Publishing and Live KPI Dashboards: Publish to service; pinning tiles; dashboard assembly; scheduled refresh.
    4. Capstone Project: End-to-end build; dataset to dashboard; acceptance criteria check.

Class Materials

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

Class Prerequisites

Experience in the following is required for this Microsoft Power BI class:

Data Analysis Fundamentals or equivalent experience (proficiency with spreadsheet navigation, basic data manipulation, and descriptive statistics).

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