Keystream Analytics approach
Keystream Analytics experts proposed a new BI solution by using the latest Data Warehouse technology and offering a self-service portal for business users in 4 effective steps:
1) Establish the Data – create new dimensions to the data to create intelligence led analytics and create a new optimised central data repository by centralising the data from CDS functions.
2) Build the Infrastructure – develop a multidimensional solution (Microsoft SSAS) to integrate data sources.
3) Build the Self-Service Portal – construct a portal and interfaces for end-user reporting via Power BI – all developed on a scalable cloud-based environment called Microsoft Azure.
4) Establish an effective BI Service – work with internal CDS workforce, CCG’s and partner organisations to establish reporting mechanisms, provide a self- service BI portal and produce standardised reports and visualisation for end users.
This approach provided CDS with improved tools and mechanisms to enable data-led insights and better decision making.