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.
- 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
- Three Numbers for One KPI: The First BridgeFree
- The Metric Definition Card: One KPI, Computed from Its Card Locked
- Gross to Net: Discounts, Tax and Shipping Step by Step Locked
- Which Date? Order, Ship and Payment Months Locked
- Time-Zone Cut-Offs: UTC vs Local Month End Locked
- Duplicates: Resent Order Events and First Occurrences Locked
- Cancellations and Returns: Order Month vs Return Month Locked
- Test and Internal Orders: Exclusion Rules and Impact Locked
- Currency: Daily Rate vs Monthly Average vs Budget Rate Locked
- Grain: Order-Level Shipping Joined to Lines Locked
- Ratio KPIs: Ratio of Totals vs Average of Ratios Locked
- Distinct Counts: Monthly vs Sum of Weekly Customers Locked
- Late Data: Preliminary vs Final and the Restatement Locked
- Channel Attribution from Two Systems Locked
- The Reconciliation Bridge: Report A to Report B Locked
- Tolerance Rules and Sign-Off: OK, Review or Block Locked
- The Metric Catalogue: Completeness & Conflicting Definitions Locked
- Monitoring: Twelve Months of Differences and Alerts Locked
- Explained Differences by Cause: The Ranked View Locked
- Final Project: The Reconciliation Dashboard Locked
Learner reviews
Be the first to review this course.