Enterprise Analytics Platform
Bell Canada
A single reporting cube in MicroStrategy that pulls 78 attributes out of four separate systems and feeds two dashboards, a team timesheet view and a director-facing view, from one shared source.
78 attributes · 4 source systems · Dev → Pre-Prod → 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.
78attributes
4source systems