Enterprise Analytics Platform
Bell Canada
A single MicroStrategy Intelligent Cube, 77 attributes and 12 metrics, built on data from four separate systems, plus the KPI dashboard data products released from Dev to Prod on top of it.
77 attributes · 12 metrics · 4 source systems · Dev → Prod
Leadership needed one trustworthy place to read the numbers, instead of four systems that each told a slightly different story.
- 01Schema-first, or rename forever
- Broke
- Early on, renaming a field for the dashboard meant editing it in the BI tool, and every downstream report drifted out of sync.
- Why
- Renames were happening at the presentation layer, so each dashboard kept its own private version of the truth.
- Fix
- Set a schema-first rule: map every attribute to its source description first, and do renames once at the database-view layer. It became the team standard.
77attributes
12metrics