Pro Kit · e-book + tools27 filesAbout 4 hours to read

Build Power BI reports whose numbers you can prove, from raw data to a shared app

A hands-on kit for analysts, finance and operations people and students: clean data in Power Query, model a star schema, write and test DAX measures, design accessible pages, secure them with RLS and publish with a readiness check.

  • A practice-files pack: star-schema CSVs, a messy export, Power Query scripts, 30 DAX measures, 24 test queries and expected results computed in Python
  • A 25-sheet master workbook with a measure test log that shows PASS or FAIL, an access register that flags RLS bypasses and a readiness verdict
  • Six fillable forms, from the requirements brief to the publish readiness check, and eight Word templates including documentation and a sign-off memo
  • An e-book of 12 chapters following one analyst's build, with 36 figures including real screenshots of the kit's own files

The Power BI Dashboard Builder Kit · Bodhih Pro Kits · 354 by Bodhih Training, trainers to 2,000+ companies since 2008.

Quick answer

How do you build a Power BI dashboard people can trust?

Agree the questions first, clean data in named Power Query steps and reconcile it, model a star schema with a marked date table, write measures and test each one against a total worked out another way, then check access, refresh and accessibility before publishing. The Power BI Dashboard Builder Kit from Bodhih Training gives you the files for each step.

Want the full free guide first? Read How to build a Power BI dashboard people can trust.

Sound familiar?

You already feel the problem. Here is what it is costing you.

Two totals, one meeting

The new report and the old spreadsheet disagree, the board meets on Thursday, and nobody can show which number is right.

Measures that run but are wrong

A ratio divides by the wrong year, a count adds lines instead of orders, a time measure stops at the last order date. Everything looks plausible.

Security that leaks quietly

Row-level security works in testing, then a manager added as a workspace Member sees every region.

A report only one person can run

Refresh depends on one laptop and one password, there is no documentation, and every change feels risky.

Now imagine this

Picture the next few weeks with the kit open beside you.

Picture the moment the old pack and your report disagree. Instead of arguing, you open the data quality log, read the row count after each Power Query step and show the seven duplicated lines and two test orders that explain the difference. The data owner confirms your total before lunch.

A week later Copilot drafts a year-over-year measure that runs and looks fine. You run the test query, see FAIL, and fix it before anyone else ever sees the wrong number. As you add each new measure you will notice how quickly testing becomes a habit.

On publishing day a colleague runs the QA checklist, the access register flags one manager in the wrong role, and the readiness check says NO-GO until it is fixed. Whether you start with the practice files tonight or the requirements brief tomorrow, you publish knowing what has been checked.

What’s in the box

27 files that do the work for you

The e-book shows you how. The tools make it happen. Here is exactly what you download.

E-book

The Power BI Dashboard Builder Kit (e-book, PDF)

The guide: methods, worked examples, scripts and exercises

🔒
Cheat sheet

Start here: Power BI build map

The whole job in twelve steps with the file for each, a 15-minute quick start, your first hour, your first week, the 30/60/90-day plan and the 'brand it in five minutes' box.

🔒
Cheat sheet

Situation router: which files to open, in which order

14 common situations, each with the files to open in order, plus the 15-minute quick start.

🔒
Spreadsheet

Power BI Dashboard Builder master workbook (25 sheets)

Tool notes, self-assessment and gap plan, licence planner, requirements, data-quality log, 30-measure library, measure test log with PASS/FAIL, access register with RLS-bypass flags, refresh and performance logs, readiness check, decision log, evidence register, RACI, roadmap, crosswalk, glossary, What changed, sources and a dashboard with five charts.

🔒
Spreadsheet

Business case calculator (three cases plus do-nothing, break-even)

Inputs, three cases with the low case first, break-even months, a 24-month cumulative chart and a summary for the sign-off memo. Every input is your estimate.

🔒
pack

Practice files pack (star-schema CSVs, messy export, Power Query, 30 DAX measures, test queries, Python expected results, tests)

18 files: sales (11,465 order lines), products, customers, dates and an RLS mapping table as CSV; a messy 610-row October export; clean_orders.pq and date_table.pq; the 30-measure library; 24 DAX test queries; expected results computed in Python with the standard library; and pytest checks. All fictional SAMPLE data.

🔒
Fillable PDF

Report requirements brief (one page before you build)

One-page fillable brief: purpose, audience, the questions and decisions, measures and grain, data sources and owners, refresh, security, devices, out of scope and sign-off.

🔒
Fillable PDF

Data source and refresh plan (gateway, schedule, owners)

Fillable plan for each data source: location, connection, gateway, credentials owner, refresh schedule and time zone, failure contacts, expected duration and what to do when refresh fails.

🔒
Fillable PDF

Measure spec and test card

Fillable card for one DAX measure: business definition, owner, DAX, format, the filter contexts to test, expected values and how they were worked out, actual values and the PASS or FAIL.

🔒
Fillable PDF

Row-level security role design and test record

Fillable record for RLS: who must see what, the role and DAX rule, the mapping table, the groups assigned, the Test as role results for each role and the workspace-role check.

🔒
Fillable PDF

Report QA checklist (before every publish)

Two-page fillable checklist across numbers, model, pages, accessibility, mobile, security, refresh, performance, Copilot and documentation, with sign-off by a second person.

🔒
Fillable PDF

Publish readiness check (go/no-go, printable)

Printable go/no-go check before an app is published: critical and non-critical criteria, evidence, the verdict rule and sign-off. The workbook's Readiness sheet works out the verdict by formula.

🔒
Word template

Leadership sign-off and decision memo

Two-page memo for the sponsor to approve a Power BI report build: the decision, scope, licences, data and security guardrails, test and QA rules, the business case with the low case first, risks, review date and signature block.

🔒
Word template

BI report standards and publishing procedure (policy and procedure starter)

Starter standard for a team that publishes Power BI reports: naming, workspaces, roles, modelling and DAX rules, testing, accessibility, security and sharing, refresh, AI use, documentation, the publishing steps and review.

🔒
Word template

Report and semantic model documentation template

Fill-in documentation for one report: purpose and owners, sources and refresh, Power Query steps, tables and grain, relationships, measures with tests, security, pages, AI-assisted items, known issues and change history.

🔒
Word template

Message and email library (18 messages)

18 ready-to-edit messages in 6 groups: kick-off and requirements, data and reconciliation, testing and Copilot, access and security, refresh and incidents, launch and review.

🔒
Word template

Scenario casebook (9 cases with model answers)

9 realistic cases from the US, Canada, the UK, Ireland, Australia and New Zealand, each with the facts, questions and a model answer that points to the kit's method and files.

🔒
Word template

AI prompt pack for Power BI (31 prompts with human-review rules)

31 prompts in 9 groups for Copilot in Power BI and any approved AI assistant: planning, Power Query, modelling, DAX, testing, pages and accessibility, report Q&A, documentation and stakeholder messages. Each with what to paste and what to check.

🔒
Word template

Worked examples: Daniel's filled requirements brief, measure test card and QA checklist

The three most-used templates filled in for the persona: the Sales Performance report brief, the test card for Sales YoY % (including the failed Copilot draft) and the QA checklist with the RLS finding and its fix.

🔒
Word template

45-minute team briefing plan and knowledge-check answer key

Facilitator plan for a 45-minute Power BI build briefing (timings, what to say, a live test demo with the practice pack, casebook discussion) and the answer key to the 14-question knowledge check.

🔒
Cheat sheet

DAX measure card: 30 essential measures, CALCULATE and filter context

The 30 library measures grouped by folder with one line each, how filter context and CALCULATE work as a mini-infographic, the five DAX habits and the mistakes that break totals.

🔒
Cheat sheet

Star schema and modelling card (decisions and mistakes to avoid)

One-page card: the star schema as a mini-infographic, fact vs dimension tests, date table rules, a decision card (if X, do Y) and the modelling mistakes to avoid.

🔒
Cheat sheet

Numbers that matter: report health card

The numbers that show whether a Power BI report can be trusted and is used: plain definitions, formulas, where each lives in the workbook and what to do if it moves, with the persona's SAMPLE values.

🔒
Cheat sheet

Tool notes and rules by market (Correct at November 2026)

Dated notes on Power BI licences, prices, limits, refresh, gateways, Copilot, RLS, workspaces, apps, sharing and accessibility, and the privacy and accessibility rules by market with official sources.

🔒
Import file

Power BI build knowledge check (LMS-ready)

14 scenario questions with four options, the correct letter and an explanation, ready to import into Bodhih LMS or any LMS.

🔒
Calendar plan

30-day practice plan and 12-week build (calendar)

36 events: 22 practice sessions on working days over 30 days, twelve weekly build check-ins and two quarterly reviews.

🔒
Import file

Task board: 30-day practice and 12-week build (CSV)

46 tasks with milestone, owner, due, type and status, ready to import into Planner, Trello, Asana, Notion or Jira.

🔒
Inside the e-book

Chapter by chapter

Each chapter opens with a real situation, gives you a method and ends with something to do today, using the tools in your kit.

Format
PDF e-book + XLSX + fillable PDF + DOCX + printable PDF + ZIP practice pack + ICS + CSV
Files
27 files plus a one-click ZIP
E-book
69 pages
Works with
Power BI Desktop (Windows) and the Power BI service, Excel, Google Sheets, LibreOffice, Word, Acrobat Reader, Google Calendar, Outlook, Planner, Trello, Asana, Bodhih LMS and other LMSs; Python 3.9+ for the optional scripts
Markets covered
US, Canada, UK, EU and Ireland, Australia, New Zealand and India; tools and rules dated November 2026
Spelling
British English with a US glossary
  1. Desktop, service and the right licence

    Desktop versus the service, Free, Pro and PPU, who needs which licence, and why Copilot needs capacity rather than a licence.

  2. Start from the questions, not the visuals

    A one-page requirements brief: questions in the user's words, the decision each supports, grain, users, security and sign-off.

  3. Power Query: clean once, repeatably

    Named Power Query steps, profiling on the whole data set, row counts after every step and a reconciliation the data owner confirms.

  4. Star schema: facts, dimensions, relationships

    Facts and dimensions, grain, keys, one-to-many single-direction relationships, role-playing dates and what to hide.

  5. The date table and time intelligence

    The date table rules, marking it, covering ship dates, and classic time intelligence you can test.

  6. DAX measures and CALCULATE

    Filter context, what CALCULATE adds, replaces and removes, and the 30-measure library in five folders.

  7. Test every measure against known totals

    Expected values by another method, 24 DAX test queries, a PASS or FAIL log and data tests in pytest.

  8. Report pages people can read and use

    Pages that answer the brief, accessibility checks (contrast, colour, alt text, tab order) and a mobile layout.

  9. Access: workspace roles, RLS and apps

    Workspace roles, apps and row-level security, why RLS filters only Viewers, and an access register that flags bypasses.

  10. Refresh, gateways and speed

    Import and refresh in plain words, gateways and owners, refresh limits, failure contacts and Performance Analyzer.

  11. Copilot in Power BI, with checks

    What Copilot in Power BI needs, what the research says about AI on business data, and draft, test, keep.

  12. Share, document and keep it healthy

    Apps, documentation, an independent QA check, a GO or NO-GO rule, the business case and the 30-day review.

What you get

Not just reading. Tools you will actually open again.

Start here

  • 00-Start-Here-Power-BI-Build-Map.pdf: the job in 12 steps with the file for each, a 15-minute quick start, first hour, first week and 30/60/90 days
  • Situation-Router.pdf: 14 situations and the files to open in order

Workbooks

  • Power-BI-Dashboard-Builder-Master-Workbook.xlsx: 25 sheets including Tool notes, Self-assessment, Gap plan, Licence planner, Requirements, Data quality log, Measure library, Measure test log, Access register, Refresh log, Performance log, Readiness, Decision log, Evidence register, RACI, Roadmap, Crosswalk, Glossary, What changed, Sources and a Dashboard with five charts
  • Power-BI-Business-Case-Calculator.xlsx: low, expected and high cases plus do-nothing, break-even months and a 24-month chart

Practice files

  • Power-BI-Practice-Files-Pack.zip: 18 files: sales (11,465 order lines), products, customers, dates and RLS mapping CSVs; a messy 610-row export; clean_orders.pq and date_table.pq; the 30-measure library; 24 DAX test queries; expected_results.py and clean_check.py (standard-library Python); pytest checks

Fillable forms

  • Report requirements brief
  • Data source and refresh plan
  • Measure spec and test card
  • Row-level security role design and test record
  • Report QA checklist (two pages)
  • Publish readiness check (go/no-go)

Word templates

  • Leadership sign-off and decision memo
  • BI report standards and publishing procedure
  • Report and semantic model documentation template
  • Message and email library (18 messages)
  • Scenario casebook (9 cases with model answers)
  • AI prompt pack for Power BI (31 prompts with human-review rules)
  • Worked examples: Daniel's filled requirements brief, measure test card and QA checklist
  • 45-minute team briefing plan and knowledge-check answer key

Cheat sheets

  • DAX measure card: the 30 measures, filter context and five habits
  • Star schema and modelling card with a decision card and mistakes to avoid
  • Numbers that matter: report health card
  • Tool notes and rules by market (Correct at November 2026)

Calendar, import and LMS

  • 30-day practice and 12-week build calendar (.ics)
  • Task board CSV for Planner, Trello, Asana, Notion or Jira
  • Knowledge check CSV (14 scenario questions) for Bodhih LMS or any LMS
Outcomes

When you have worked through it, you will be able to…

Every outcome is practised with a worked example and a tool, not just described.

  • Decide who needs a Free, Pro or PPU licence, and when capacity makes sense
  • Turn a vague request into a signed requirements brief with questions and decisions
  • Clean messy exports in named Power Query steps and reconcile totals with the source
  • Model a star schema with a marked date table that covers every related date
  • Write DAX measures with CALCULATE and explain what each returns in a matrix
  • Test every measure against an expected value worked out another way
  • Design pages that meet contrast, alt text, tab order and mobile checks
  • Set workspace roles, apps and row-level security so the filters really apply, and publish with a QA check and readiness verdict
Measure it

Know your starting point. Prove your progress.

People who measure before and after improve faster and can show it. AssessAll, our sister assessment platform, has AI-graded assessments that pair with this kit. Take one now, work through the kit, then re-take it.

Read a page

A taste of Chapter 7: Test every measure against known totals

Research on spreadsheets keeps finding the same thing: errors are common and hard to see, and careful inspection is what catches them [S3]. In the Enron spreadsheet study, nearly a quarter of spreadsheets with formulas contained at least one Excel error [S4]. A DAX measure is a formula too, and it fails in the same quiet way: it runs, returns a plausible number and is wrong. The AQuA Book calls checking that analysis does what it was designed to do "verification", and expects all analysis to be assured in proportion to its importance, with the assurer independent of the analyst [S9]. In a Power BI build, verification has a practical shape: for each important measure, pick a filter context, work out the expected answer by a different method (a query on the source, a pivot table, a script), run the measure in that context and compare. If the expected value comes from the same measure on another page, you have proved nothing.

From The Power BI Dashboard Builder Kit, Bodhih Training
Why this kit

The honest comparison

Free templates and typical adviceThis kit
Starting pointA screenshot of the old reportA signed requirements brief with questions, decisions and grain
DataFixed in Excel before loadingNamed Power Query steps, row counts per step and a reconciliation
MeasuresFormulas copied from forumsA 30-measure library with plain explanations
ProofCompared by eye with the old pack24 tests against expected results computed another way, logged PASS or FAIL
AccessAdd people to the workspaceApps, Viewer roles, tested RLS and an access register that flags bypasses
Hiring a consultant or buying trainingExpert help, priced by the day, that leaves when the project endsA method, files and checklists your own team keeps and reuses
Who it’s for

Made for you if…

  • Analysts asked to turn an Excel pack into a Power BI report
  • Finance, sales and operations professionals who build reports alongside their main job
  • Team leads and managers who must sign off reports others build
  • BI developers who want a repeatable testing, QA and documentation routine
  • University students building Power BI projects for courses or capstones (within their institution's rules on AI)
  • Small-business owners publishing their first shared reports
Being honest

Probably not for you if…

  • People who need help choosing the message and chart for an audience: that is our Data Storytelling and Dashboard Kit
  • Administrators looking for tenant configuration, capacity sizing or Fabric data engineering
  • Mac users who cannot run Windows: Power BI Desktop is a Windows application
  • Anyone wanting a certification guide, legal advice on privacy or accessibility, or a promise of a job or pay rise
Why Bodhih

Built by trainers, tested in real rooms.

Bodhih Training has designed and delivered corporate programmes since 2008. Bodhih Pro Kits package what works in those workshops into a guide plus the exact tools we use, so you can apply it the same day without a facilitator in the room.

2008Training organisations since
2,000+Companies served
200,000+Professionals trained
18,000+Programmes delivered
How it works

From here to using it in three steps

  1. STEP 1

    Tap Get the kit

    Name, email and country. UPI, card or netbanking in India; international cards everywhere else. No account to create.

  2. STEP 2

    Download instantly

    Your download page opens at once, with every file and a one-click ZIP. A permanent link lands in your inbox too.

  3. STEP 3

    Open the first tool

    Start with the quick-start chapter, then the main spreadsheet or planner. Most buyers use something from the kit the same day.

Ready when you are

Build one report you can prove

As you run the first test query and see PASS, you will feel the difference between a report that looks right and one you can defend. Start with the practice files tonight or the requirements brief tomorrow: either way, your next report is built to be checked.

$34one-time payment

Personal licence for the buyer's own use (and use with your own team or clients where the kit says so). Please don't share or resell the files. Team and company licences: solutions@bodhih.com. Not affiliated with or endorsed by Microsoft. Microsoft, Power BI, Power Query, DAX, Microsoft Fabric, Copilot and Excel are named descriptively only.

What buyers say

No ratings yet. Only people who have bought this kit can rate it - every buyer gets a one-click rating link a couple of days after their purchase.

Questions buyers ask

The Power BI Dashboard Builder Kit: FAQs

Read the free guideAlready bought? Resend my link

Do I need a paid licence to build Power BI reports?

No to build, yes to share. Power BI Desktop is a free Windows download, and a free account lets you keep content for yourself. To publish to shared workspaces and share, you need Pro or Premium Per User (Microsoft 365 E5 and Office 365 E5 include Pro); viewers need Pro or PPU too unless the workspace is on Fabric capacity of F64 or larger. The Licence planner sheet works it out; prices are on the dated Tool notes sheet.

What is a star schema in Power BI and why does it matter?

It is a model with a fact table of events (such as order lines) in the middle and dimension tables (product, customer, date) around it, related one-to-many. Dimensions filter and group; facts are summarised. It makes totals predictable, models smaller and measures simpler. Chapter 4 builds one from the practice files.

How do I test DAX measures?

Work out the expected value for a known filter context by another method, run the measure in that context and compare. The practice pack computes 24 expected results in Python, and test_queries.dax runs the matching DAX queries in DAX query view. The Measure test log shows PASS or FAIL with tolerances.

Does row-level security apply to workspace members?

No. Microsoft's documentation says RLS restricts data only for workspace Viewers; Admins, Members and Contributors are not filtered. Give report readers the app or the Viewer role. The Access register flags anyone who must be filtered but holds a higher role.

Do I need a gateway for scheduled refresh?

Only when the service cannot reach your source directly, for example a database on your own network. Cloud sources usually do not need one. Chapter 10 and the Data source and refresh plan cover the gateway owner, schedule, failure contacts and limits.

Can I use Copilot in Power BI with a Pro licence?

Not on its own. Microsoft documents that Copilot in Power BI needs paid Fabric capacity F2 or higher or Premium P1 or higher, plus a tenant setting and a supported region. Without capacity you can use an approved AI assistant with the prompt pack, pasting metadata rather than data. Either way, test every AI-written measure.

Is this kit suitable for beginners and university students?

Yes, if you can install Power BI Desktop and are willing to type formulas. The practice files and exercises start from loading CSVs. Students should follow their institution's academic-integrity rules on AI first. The kit does not promise grades, jobs or certification results.

Does it work on a Mac?

Power BI Desktop runs on Windows, so Mac users need a Windows machine or a Windows virtual environment their organisation allows. The workbook, forms, templates, practice CSVs and Python scripts work on any computer, and the Power BI service runs in a browser.

Does it work in my country?

The method works anywhere Power BI is used. The Crosswalk sheet lists privacy and accessibility rules for the US, Canada, the UK, the EU and Ireland, Australia, New Zealand and India with official links, correct at November 2026. Laws change, so check with your privacy team or adviser.

Can I use this with my team?

Yes, within your own organisation under the personal licence: run the 45-minute briefing, use the casebook and import the knowledge check into your LMS. Company and multi-site licences are available from solutions@bodhih.com.

How do I measure my starting point?

Score the twelve-practice self-assessment in the workbook. For an independent measure, AssessAll offers a Business Intelligence Dashboard Design Work Sample, a Spreadsheet and Data Literacy assessment and an SQL Query Writing Assessment with executed queries.

How do I turn this into a development plan?

Use the Gap plan sheet to rank your gaps by gap times impact, then set goals with the WOOP method described on Jobulary, and import the 30-day calendar so the practice is booked.

How much does The Power BI Dashboard Builder Kit cost?

₹1,299 including 18% GST for buyers in India, or $34 for buyers outside India. One-time payment, no subscription, with an automatic invoice.

How do I get the files after paying?

Instantly. Your download page opens the moment payment succeeds, and a permanent download link is emailed to you. Download each file separately or everything in one ZIP.

What software do I need?

Any of the usual tools: Excel or Google Sheets for spreadsheets, Word or Google Docs for templates, Adobe Acrobat Reader, Preview, Xodo or GoodNotes for the fillable PDFs, and Google, Outlook or Apple Calendar for the calendar plan.

Can I get a refund?

Because it is a digital download, kits are not refundable once downloaded. We always refund a duplicate charge or a failed delivery, and if a file is corrupted and we cannot fix it within 3 working days. Full terms: bodhih.org/refunds.

Can my company buy this for a team?

Yes. Team and company licences, and workshops on this topic run by Bodhih Training, are available. Write to solutions@bodhih.com or call +91 99000 11601.

$34