Achieved 80% reduction in reports, 60% fewer data requests, and 60–80% faster custom report creation with a modern BI platform ensuring governance and data quality.
Client
A major educational testing and assessment organization
Goal
To rationalize and modernize the system for BI reports and deliver a better UX with quality assurance at a reduced cost
Tools and Technologies
Power BI, Semantic Modelling, MSBI
Business Challenge
The client had a current set of 400+ Power BI and 600+ SSRS reports. A number of these were obsolete and had to be removed and archived.
Users faced multiple challenges that had to be identified by collating feedback so that appropriate solutions could be developed. The aim was to modernize and rationalize the system to achieve better governance and reduce costs of infra and support services.
Solution
- Collated user feedback to pinpoint key challenges and improvement areas
- Identified, removed and archived many obsolete and orphaned reports
- Built a holistic semantic model to support reports with self-serve BI capability
- Introduced new, rationalized, and interactive reports/dashboards
- Enhanced UI/UX design with a provision to introduce branding
- Developed a robust process for data governance and quality assurance
- Created extensive documentation to enable complete user self-serve capabilities
- Trained users on BI self-serve
Outcomes
- Achieved 80% reduction in the number of reports post-rationalization
- Ensured 60% reduction in requests/enquiries for data by making it readily available through documentation
- Delivered 60% to 80% reduction in time required to build new custom reports
- Enhanced user confidence in data generated
- Increased number of users and per report user views
