Tabellab
Data & Analytics Intermediate

Why Two Reports Disagree: KPI Definitions, Grain, Order vs Ship Dates, Time-Zone Cut-Offs, Duplicates, Returns, Currency Rates, Late Data and a Reconciliation Bridge

Find out why the finance report, the marketing dashboard and the BI report show three different numbers for one KPI – in 20 hands-on labs on definition cards, date fields, time zones, duplicates, returns, currencies, grain, late data, bridges, tolerances and a reconciliation dashboard, with every cell checked as you go.

20 lessons 20 labs Certificate

  • One-time payment
  • Instant access right after payment
  • Secure checkout with Stripe

About this course

In 20 hands-on spreadsheet labs you find out why three reports show three different numbers for one KPI – and close the gap to the cent. You write metric definition cards, walk revenue from paid to net, total by order, ship and payment date, convert UTC cut-offs, remove duplicate events, book returns under two policies, exclude test orders, convert three currency rates, fix order-to-line fan-outs, compare ratio of totals with average of ratios and count distinct customers. Then you size late-data restatements, cross-tab channels, build a reconciliation bridge, apply tolerance rules, check a metric catalogue, monitor twelve months and finish with a sign-off dashboard.

Why learn with Tabellab

  • Practise in a real spreadsheetEvery lab runs in your browser and checks your cells instantly.
  • Verifiable certificatePass the final exam and get a certificate with a public verification code.
  • Try before you buyLesson 1 is free, with no sign-up or card needed.
  • Who is behind TabellabBuilt by Babala Software in Füllinsdorf, Switzerland. Questions? hello@tabellab.com · Imprint

Lessons

  1. Three Numbers for One KPI: The First BridgeLabFree
  2. The Metric Definition Card: One KPI, Computed from Its CardLab Locked
  3. Gross to Net: Discounts, Tax and Shipping Step by StepLab Locked
  4. Which Date? Order, Ship and Payment MonthsLab Locked
  5. Time-Zone Cut-Offs: UTC vs Local Month EndLab Locked
  6. Duplicates: Resent Order Events and First OccurrencesLab Locked
  7. Cancellations and Returns: Order Month vs Return MonthLab Locked
  8. Test and Internal Orders: Exclusion Rules and ImpactLab Locked
  9. Currency: Daily Rate vs Monthly Average vs Budget RateLab Locked
  10. Grain: Order-Level Shipping Joined to LinesLab Locked
  11. Ratio KPIs: Ratio of Totals vs Average of RatiosLab Locked
  12. Distinct Counts: Monthly vs Sum of Weekly CustomersLab Locked
  13. Late Data: Preliminary vs Final and the RestatementLab Locked
  14. Channel Attribution from Two SystemsLab Locked
  15. The Reconciliation Bridge: Report A to Report BLab Locked
  16. Tolerance Rules and Sign-Off: OK, Review or BlockLab Locked
  17. The Metric Catalogue: Completeness & Conflicting DefinitionsLab Locked
  18. Monitoring: Twelve Months of Differences and AlertsLab Locked
  19. Explained Differences by Cause: The Ranked ViewLab Locked
  20. Final Project: The Reconciliation DashboardLab Locked

Learner reviews

Be the first to review this course.

Write a review

Your rating

Reviews are checked before they appear. By submitting you confirm the images are yours and may be shown on this page. Privacy