Suggested from your browser region; change it any time. Payfast confirms the final currency and amount at checkout. Foreign-currency payments require a credit card.
Actual e-book cover. All business examples inside are fictional.
Data quality · practical e-book
Before You Build a Dashboard
Make the numbers easier to trust before you build the report. Learn how to inspect spreadsheets, resolve data issues with evidence and reconcile a result you can explain. Written for business owners, administrators and managers.
Checking availability...
Explore what is included below. Purchasing will open when the download is ready for release.
See what's insideQuestions before purchasing? Ask us about this product.
Inside the e-book
A clearer foundation
for every report.
Follow seven chapters from the business question to a repeatable review routine. No coding or dashboard software is required to read the book.
- 01
Start with the business question
Define the decision, population, period and sources before changing a file.
- 02
Recognise spreadsheet problems
Inspect row structure, required fields and the issues that could change your report.
- 03
Handle duplicates, gaps and labels
Use evidence to resolve repeated records, missing values and inconsistent categories.
- 04
Check dates, amounts and totals
Keep periods and units clear, test calculations and reconcile source to result.
- 05
Define metrics that mean the same thing
Document measures, compare like with like and avoid multiplying records when joining tables.
- 06
Follow a complete worked example
Trace a fictional order register from the original extract to a reviewed reporting subset.
- 07
Build a repeatable reporting routine
Assign owners, handle exceptions and use a pre-dashboard release checklist.
Look inside before you buy
Real pages from the e-book.
What you will practise
- Deciding what each row represents and how it should be identified.
- Handling duplicates, missing values, inconsistent labels and ambiguous dates.
- Reconciling a fictional order register from ZAR 6,750 to ZAR 3,600 in verified completed orders.
- Documenting definitions, exceptions, review decisions and a reporting routine.
Before you buy
- Format & requirements
- One standalone, searchable 37-page PDF with bookmarks. Read it in a PDF reader; use your own spreadsheet application if you want to practise the examples.
- Included material
- Seven chapters, original teaching tables, a fictional worked example, exercises with answers, a glossary, references and checklists inside the PDF.
- Scope
- General operational guidance. No workbook, software licence, live connection, consulting time or automated cleaning tool is included. The book does not provide an audit opinion or accounting, tax or legal advice.
- Use & licence
- For the purchasing individual: keep a personal copy, print a personal working copy and apply the methods at work. The book may not be resold or publicly redistributed. Contact us about team or classroom copies.
- International use
- English-language guidance with a fictional ZAR order-value example. Apply the definitions and units appropriate to your own reporting task.
Purchase & download questions
How do I receive the files?
Your existing website account is used at checkout. After PayFast confirms payment, return to the store and open My downloads using the same account. This e-book is delivered as one PDF: Before_You_Build_a_Dashboard.pdf.
Is this a subscription?
This is a one-time digital purchase with no recurring product subscription.
Can I download my purchase again?
Confirmed paid purchases remain available in My downloads with the same website account. There is no download expiry or download-count limit in the current store. Contact purchase support if a file is unavailable.
What if I need purchase support or want to request a refund?
Contact The Spokesdude Network with your purchase reference and a description of the issue. Check the Website Terms before purchasing; we will review requests under the applicable terms and consumer requirements.