CDMP Fundamentals • 100 Questions • 90 Minutes
← Back to Case Studies

MegaTelco's Self-Service BI Transformation

Data Warehousing and Business Intelligence Medium

💼 Scenario

MegaTelco is a telecommunications company with 30 million subscribers. The company's BI team of 25 analysts handles a backlog of 300 report requests with an average turnaround of six weeks. Business users frequently express frustration with the inability to get timely insights, and many have resorted to creating their own analyses using desktop tools and unverified data extracts. An audit reveals that 60% of executive dashboard metrics are calculated differently by different departments, resulting in contradictory numbers being presented in board meetings. Marketing reports customer churn at 2.1%, while Finance reports it at 3.4% due to different definitions and data sources. Revenue figures vary by up to 5% depending on which system generated the report. The CEO has mandated a self-service BI initiative to empower business users while ensuring data consistency. The initiative must reduce the report backlog by 80% within six months, establish trusted enterprise metrics, and maintain data governance controls to prevent the spread of inaccurate analyses.

Question 1: What should MegaTelco implement FIRST before enabling self-service BI for business users?

Question 2: How should MegaTelco resolve the conflicting churn rate metrics between Marketing (2.1%) and Finance (3.4%)?

Question 3: What governance model BEST balances self-service empowerment with data quality controls?