Read the chapter
Understand the business question, metric definitions and analytical method before opening the data.
LEARN · BUILD · EXPLAIN
From raw data
to real insight.
Your practical companion to Power BI for Business Intelligence and Data Analytics. Download original exercise files, test your calculations, and build projects you can explain with confidence.
JOMOVATE LEARNING EDITION 01 / 09
POWER BIfor Business Intelligence
& Data Analytics
& Data Analytics
FROM RAW DATA TO
PROFESSIONAL DASHBOARDS
LEARN BY DOING · 2026
Example dashboard
£281,000 NET REVENUE
JAN GROWTH OVER TIME JUN
3 portfolio projects
09Chapters
03Independent case studies
09Available download packs
100%Synthetic practice data
01 / LEARNING PATHStart with the question.
Start with the question.
Finish with the evidence.
The textbook follows the same professional workflow you will use in analytical roles. Each practice file is linked to a clearly defined learning objective.
Build the exercise
Download the chapter pack, follow the Power Query and Power BI steps, and keep your original source files unchanged.
Check and explain
Reconcile your numbers with the answer keys. Document what the results mean and what they cannot establish.
02 / DOWNLOAD LIBRARYEverything for your
Everything for your
next practical step.
Find the correct dataset or toolkit for each chapter. All downloads are original, synthetic educational ZIP files from the book’s supplied resource package. Try each exercise before viewing its answer key.
↓One complete archiveNorthstar, Riverton, Cedarbridge and Brightway · Ch. 2–7Download complete library ↗
Foundation
Understanding business questions & KPIs
No separate download · learn with the Chapter 2 sales data
Data preparation
Preparing messy datasets using Power Query
11 files · Practice dataset · 7.6 KB
Visual reporting
Building your first professional sales dashboard
Reuses the Northstar sales files from Chapter 2
Data modelling
Understanding data models and relationships
9 files · Practice dataset · 8.2 KB
DAX & measures
DAX made practical
13 files · Practice dataset · 11.3 KB
Research analytics
Survey and research analysis
12 files · Practice dataset · 16.2 KB
Finance & operations
Financial and operational reporting
16 files · Practice dataset · 11.8 KB
Communication
Presenting your analytical findings
11 files · Optional toolkit · 9.0 KB
Portfolio & career
Portfolio development and interviews
14 files · Optional toolkit · 14.8 KB
No chapters match your search. Try “DAX”, “survey” or “financial”.
CONTINUING WORKSHOP / BRIGHTWAY HOME LTD
One business. Six workshop datasets. A complete analytical story.
Work alongside the book's fictional Brightway team. The supplied pack contains six messy sales extracts, reference data, a customer survey, finance and operational records, an October refresh exercise and separate answer keys.
44,835raw sales lines43,018validated sales lines1,891clean survey responses
Core controls checked against the supplied reference CSVs. The entire printed manuscript has not yet undergone line-by-line reconciliation.
BRIGHTWAY WORKSHOP LIBRARYSix practical modules
Sales · Modelling · Targets · Surveys · Finance · Operations
Download Brightway pack Includes the learner datasets and the answer-key folder · approx. 3.9 MB03 / CASE STUDIESNot just tutorials.
Not just tutorials.
Portfolio-ready practice.
Northstar, Riverton and Cedarbridge demonstrate three specialisms. Brightway Home is the continuing case study linking the nine chapters.
01 / RETAIL ANALYTICS
£281kRevenue · Northstar Retail
Understand profitable growth
Transform raw sales into a star-schema model, DAX scorecard and actual-versus-target analysis.
Power Query · DAX · Data modelling02 / RESEARCH ANALYTICS57.46%Positive responses · Riverton College
Listen to the evidence
Analyse satisfaction questions, appropriate denominators, response distributions and research limitations.
Surveys · Likert scales · Ethics03 / PERFORMANCE REPORTING£22.7kBudget overspend · Cedarbridge
Connect spending to outcomes
Compare financial budgets with actual expenditure, service targets and operational performance.
Finance · Variance · Operations04 / READER SUPPORTGood data needs
Good data needs
good documentation.
Questions about using the files, validation or software updates? Start here.
Contact the learning teamAre the datasets free to download?
Yes. The chapter packs and Brightway workshops are provided as companion learning materials. Every sample organisation and dataset is fictional.
What software do I need?
Use Power BI Desktop on Windows for the exercises. A spreadsheet tool can help inspect CSV files. Some optional publishing exercises require the Power BI service and suitable permissions.
Why do Chapters 1 and 3 not have separate packs?
Chapter 1 introduces KPI logic and manual calculations. Chapter 3 uses the validated Northstar sales data prepared in Chapter 2, so you can reuse that dataset rather than download unnecessary duplicates.
Where are the Brightway workshop files?
You can download the complete Brightway workshop pack below, including the continuing sales, survey and finance/operations exercises and answer workbooks. Key CSV control totals have been independently checked.
How will errors or updates be handled?
Updated files will have a dated release record. Each download has a checksum in the resources manifest so later revisions can be identified.
Download privacy and file integrity
Downloads are provided directly as ZIP files; this learning page does not request logins or collect survey answers. Use the resource manifest to check file versions and SHA-256 checksums. No confidential organisational data is included in the supplied synthetic packs.