Power BI practice exercises: learn Power BI by doing
Short, interactive exercises in a report editor that runs in your browser. Build the visual, write the DAX, clean the data, and get your answer checked in seconds. No install and no Power BI license needed.
184 hands-on exercises in 10 chapters, end-to-end dashboard projects, a DAX functions guide and PL-300 practice tests.
Reports & Visuals: Build cards, tables, matrices and charts from a star-schema model.
Filters & Slicers: Visual filters, Top N and slicers: show exactly the data the business asked for.
Report Pages & Interactivity: Multi-page reports: edit interactions, drillthrough, sync slicers, bookmarks, buttons and tooltip pages.
Power Query: Clean and shape raw files: headers, types, blanks, duplicates, split, unpivot, group, merge and append.
Data Modeling: Create and fix relationships in the Model view, and see why they matter.
Calculated Columns: Add new columns with DAX: margins, bands, regions and categories.
DAX Basics: Write your first measures: SUM, COUNTROWS, DIVIDE and iterators.
CALCULATE & Filter Context: The most important function in DAX, step by step.
Advanced DAX: Variables, ranking, iterators and dynamic labels.
Time Intelligence: Year-to-date, last year, month over month.
Who's behind Power BI Exercises: Alec, a student working toward a job as a Power BI analyst, who built the site to make learning Power BI easier for himself and now shares it with anyone on the same path.
The Fun Way to Learn Power BI Skills
Most people learn Power BI the hard way. They watch a few hours of tutorials, open Power BI Desktop at work, and then realize they don't remember which field goes where or why their measure shows the same number in every row. Knowing about a feature and being able to use it under pressure are two different things.
Power BI Exercises closes that gap. Each exercise gives you one realistic task and a report editor that looks and behaves like the real thing: a Data pane, a Visualizations pane, a Filters pane and a formula bar. You do the work yourself, and the site checks the result against the data, not against a screenshot.
Power BI Exercises Solves the "Boring Video" Problem
Video courses are easy to start and hard to finish. You pause, rewind, switch windows to copy a formula, and by the next module the earlier lessons are already fading. Watching someone else write DAX doesn't build the muscle memory you need to write it yourself.
Here there is nothing to watch. You read a short explanation, try it, and find out right away whether it worked. If it didn't, the feedback tells you exactly what is different: a missing filter, a measure in the wrong well, a relationship pointing the wrong way. You fix it and move on, which is how skills actually stick.
Power BI Practice for Busy People
You don't need a free weekend. Exercises take two to five minutes and focus on a single idea: a slicer, a relationship, a CALCULATE filter, a year-to-date measure. Do one on your lunch break and you have learned something you can use the same afternoon.
Your progress is saved in your browser, so you can stop in the middle of a chapter and pick up where you left off. Every chapter has a progress bar, and every lesson shows whether it is new, in progress or solved.
Have Fun While You Learn
Practice works better when it feels like progress. You earn points for every solved exercise, a bonus when you solve one without hints, and a daily streak for coming back. It is a small thing, but it turns "I should practice Power BI" into "one more exercise before lunch".
The exercises build on each other. You start with a single card and a column chart, then add filters and slicers, clean data in Power Query, connect tables in the model, and finish with variables, ranking and time intelligence in DAX.
Hands-on Exercises
You learn a tool by using it. Every exercise asks you to produce something: a visual with the right fields, a measure that returns the right numbers in every row, a query whose output matches the expected table. Because the answer is checked against the data, equivalent solutions count too, just like at work.
The sample company, Ridgeline Cycles, has products, customers, stores, monthly targets and two years of orders. It is small enough to understand at a glance and rich enough to practice the patterns you will meet in real reports.
Power BI Exercises for Beginners and Experts
If you have never opened Power BI, start with chapter one: your first card, a column chart, a table with totals. Each lesson explains one idea in plain language before you try it.
If you already build reports, jump to the chapters on CALCULATE and filter context, advanced DAX with VAR and RANKX, or time intelligence with year-to-date and last-year comparisons. Those are the topics that separate a report builder from a Power BI expert.
Learn DAX by Writing It
DAX is where most people get stuck. The syntax looks like Excel, but the results depend on filter context, and that only clicks after you have seen a measure return the wrong number and fixed it yourself.
The exercises take you from SUM and simple measures to CALCULATE, ALL, FILTER, variables, RANKX and time intelligence. The DAX functions guide explains each function with its arguments and examples, and links to the exercises that use it.
Prepare for the PL-300 Exam
The PL-300 (Microsoft Power BI Data Analyst) exam covers four areas: preparing the data, modeling the data, visualizing and analyzing the data, and managing and securing Power BI. The exercises practice the same skills, so every chapter you finish is exam practice too.
Closer to exam day, the PL-300 practice tests give you exam-style questions, case studies and a timed mode with a score out of 1,000. Every answer comes with an explanation, and a review of your weak topics shows what to practice next.
Practice for a Power BI Interview Test
Many companies give candidates a practical Power BI test: a dataset, a few questions and limited time to build a report. It is stressful when you see that format for the first time.
The assessment test practice page walks through the usual formats, the skills they check and a short preparation plan, with sample questions. Pair it with the exercises and the test feels like one more practice session.
Start Free, Upgrade When You Are Ready
You can start right now without an account. The first exercises in every chapter, the Sales Overview Dashboard project, the first PL-300 practice test and the full DAX functions guide are free.
Pro unlocks every exercise, every dashboard project with data downloads, every PL-300 practice test and the full Power Query and data modeling modules.
Frequently asked questions
Do I need Power BI Desktop? No. Everything runs in your browser, on Windows, Mac or a Chromebook. The editor follows the same layout as the real tool, so the skills transfer directly when you open Power BI Desktop at work.
How is my answer checked? Your visual, measure or query is evaluated against the real data model and compared with the expected result in every context: per category, per year and for the grand total. Different but equivalent DAX formulas are accepted.
Who is it for? Analysts, accountants, marketers, project managers and anyone who has to build reports. It is also good practice for the PL-300 (Power BI Data Analyst) exam.
How long does an exercise take? Most exercises take two to five minutes. Each one teaches one idea, so you can practice in a coffee break and still make progress.
Is it free? The first exercises in every chapter are free, with no sign-up. Pro unlocks the full path, projects and exam practice.
Start practicing
- All Power BI practice exercises
- Power BI practice projects
- DAX functions list with examples
- PL-300 practice test
- Power BI assessment test practice
- Your first card
- Sales by category
- Only 2025, please
- West coast bikes
- Add a report page
- Hide a working page
- Use the first row as headers
- Rename and set data types
- Connect Sales to Product
- Relate targets to the calendar
- Margin per sales line
- Premium or standard?
- Your first measure
- Counting orders
- CALCULATE: red products only
- % of all categories
- Margin % with variables
- Biggest order
- Sales year-to-date
- Same period last year