Krifa had an outdated Data Warehouse systemthat only contained a portion of the data they wanted to report on. Therefore, other tools such as Excel were used to retrieve and process data. It made it difficult for them to get an overview of their data.
Krifa wanted to do much more with their data. This was data such as statistics on members, time spend on cases, absences, financial data, and member data which they wanted to compile for various statistical purposes. Meetings have been held to ensure the data collected complies with GDPR law.
Krifa had previously worked together with Kapacity in another case. Therefore, they chose Kapacity to help them in their desire for a better BI system.
A Microsoft solution has been established in Azure, consisting of several services to build three environments: a development environment, test environment, and production environment, shown on the illustration on the right. The solution is based on a framework that Kapacity have developed with a focus on a common working method – and quality, and hence faster development time. It is built as a PaaS (Platform as a Service) solution in Azure.
The solution exhibits a common set of dimension tables across the individual business areas, enabling Krifa’s business users to make queries across areas.