Practice scorecard
Utilisation, billable hours, margin, concentration and receivables — every tile recalculates from the same SQL model
1
Before → after: 42 workbooks collapse into one SQL Server schema feeding one model
Every tile on the left is a real workbook type a 24-consultant Microsoft practice keeps by hand; the selected vertical's workbooks light up
—workbooks in scope (of 42) — timesheets, invoice trackers, budgets, pipeline, rate cards
8 tablesdim_date · dim_client · dim_consultant · dim_project · fact_timesheet · fact_invoice · fact_expense · fact_pipeline
—nightly refresh replaces the weekly manual consolidation
2
Billable hours & utilisation by month
Bars = billable hours logged in fact_timesheet · line = utilisation vs 75% plan
Billable hoursUtilisation %75% plan
3
Client revenue & project margin
Ranked by billed revenue in the period · bar = share of revenue · right column = project margin
4
Invoice ageing
Open invoices in fact_invoice as of 31 Aug 2026, issued in the period
5
Migration status
Workbooks consolidated into SQL Server tables, refresh times and data-quality issues resolved
6
Ask the data
AI layer on top of the model — natural-language question, governed answer
8
