StretchLearn Course

Turn a messy data file into a dashboard your whole team can click

No DAX, no SQL, no code. Learn Power BI Desktop the practical way: Get Data and clean it in Power Query, model your data by dragging relationships, design visuals with slicers and drill-down, then publish to the Power BI Service with scheduled refresh so your report updates itself.

Preview Curriculum Back to Catalog

Beginner9 hr 40 minSelf PacedRegistered

Course Overview

What this course is designed to develop

This course teaches anyone comfortable in spreadsheets to replace static, manually rebuilt reports with Power BI dashboards that refresh themselves. You connect to Excel, CSV, and folders, transform messy data in the Power Query Editor using filter, split, unpivot, and Group By with zero formula writing, then build a clean data model by linking a fact table to date and lookup tables. You design report pages with bar, line, card, matrix, and map visuals, add slicers and cross-filtering, create quick measures and the implicit measures Power BI generates for you, then publish to the Power BI Service, build a dashboard, set scheduled refresh, and share with row-level access. Each lesson uses a concrete sales file and flags the real traps, data-type errors, blank relationships, wrong aggregations, and refresh failures, so your reports stay trustworthy.

Learning Outcomes

What the learner should be able to understand, build, or execute.

Install Power BI Desktop and connect to Excel, CSV, and folder sources using Get Data without any code

Clean and reshape data in the Power Query Editor with filters, split column, unpivot, Group By, and applied-step editing

Build a star-schema data model by creating relationships between a fact table and date and lookup tables

Design report pages with bar, line, card, matrix, map, and KPI visuals plus formatting and conditional formatting

Add interactivity with slicers, cross-filtering, drill-down, drillthrough, bookmarks, and tooltips

Publish to the Power BI Service, pin a dashboard, schedule automatic refresh, and share reports securely

Curriculum Preview

Inside the curriculum: a structured path from fundamentals to execution.

Preview the course structure, see how the modules build on one another, and understand the path this program is designed to take you through.

Module 1

Module 1: Getting Started and Connecting Your Data

Install Power BI Desktop, learn the three views you will live in, and pull data in from Excel, CSV, and folders with Get Data. You leave with a real dataset loaded and ready to clean.

3 lessons

What Power BI Is and Setting Up DesktopContent · 45 min

Preview Enabled

Get Data from Excel, CSV, and FoldersContent · 50 min

LMS Access

A Tour of the Power Query EditorContent · 45 min

LMS Access

Module 2

Module 2: Cleaning and Shaping Data in Power Query

Do the real data work with point-and-click tools: fix data types, filter and remove errors, split and unpivot columns, and summarize with Group By, all recorded as repeatable steps.

3 lessons

Data Types, Headers, and Removing JunkContent · 45 min

LMS Access

Split, Merge, and Unpivot ColumnsContent · 50 min

LMS Access

Group By, Append, and Merge QueriesContent · 50 min

LMS Access

Module 3

Module 3: Modeling and Measures Without DAX

Turn loaded tables into a proper model: build a star schema with relationships, add a date table, and create the metrics you report using quick measures and Power BI's built-in aggregations, no DAX writing required.

3 lessons

Relationships and the Star SchemaContent · 50 min

LMS Access

A Date Table and Time IntelligenceContent · 45 min

LMS Access

Measures the Easy Way: Implicit and Quick MeasuresContent · 50 min

LMS Access

Module 4

Module 4: Designing Reports and Publishing to Share

Turn the model into visuals: build pages of charts, cards, matrices, and maps, add slicers and drill-down interactivity, then publish to the Power BI Service, build a dashboard, schedule refresh, and share securely.

3 lessons

Building Visuals: Charts, Cards, Matrix, and MapsContent · 50 min

LMS Access

Interactivity: Slicers, Drill-Down, and BookmarksContent · 50 min

LMS Access

Publish, Schedule Refresh, and ShareContent · 50 min

LMS Access

Built for Application

A complete learning path, not a one-off inspiration hit.

This program is designed around progression: focused lessons, structured modules, applied resources, assessments, and a course rhythm that turns information into usable capability.

Power BIPower Querydashboardsdata visualizationdata modelingbusiness intelligenceKPI reportingPower BI Service