1. Lack of a unified data source
Core data such as cash and sales were reconciled manually due to the absence of a single master data repository.
2. Decentralised Power BI usage
While Power BI was used for self-service analytics, it lacked governance, process controls, and content management.
3. Inconsistent reporting methods
Business reports were delivered via Excel and PDF through email, with varying development methods across SSRS, Excel, and SSAS-based reports.
4. Data silos and Excel dependency
Heavy reliance on Excel for downstream reporting and emerging siloed cloud data lakes added to the complexity.
5. Limited scalability and performance
The existing BI infrastructure had a single daily ETL refresh, creating a bottleneck and limiting real-time analytics capabilities.
6. No enterprise data strategy
There was no long-term roadmap for enterprise-wide data and analytics, limiting alignment and growth.