Since Leger des Heils had a new Enterprise Care Management System developed by Qubiz, they also had an extensive need for business intelligence. The main focus of the business intelligence solution, from a balanced scorecard perspective, was on:
monitoring the quality of care and allowing the customers (patients) to indicate how can the care services be improved
assessing the level of their personnel’s learning and growth needs
In order to give Leger des Heils the required controls and monitoring facilities, Qubiz developed a new Data Warehouse and Business Intelligence solution consisting of:
standard and ad-hoc reports for management and executives
an Online Analytics Processing (OLAP) tools for business analysts
a dashboard with key performance indicators (based on a balanced scorecard)
The solution consists of several components that allow Leger des Heils to be ready for the future and that fit their extension plans. These component are:
a data warehouse with data marts for historical data collection
SQL Server Analysis-based Cubes for analytical processing
Microsoft Excel-based dashboard (on top of the cubes) for business analysts
Since Business Intelligence involves a lot of business knowledge, we spend quite some time with our client so we could understand its decision-making needs. Using an agile project management approach, we identified the main user scenarios. Step by step, the ETL, the Data Warehouse and the Cubes were developed. We worked in multiple sprints (stages). After every sprint, which took 2 to 3 weeks, we presented the results to Leger des Heils’ business managers and analysts, so that they could steer for the next sprint.
The solution we built for Leger des Heils was designed from a business process-oriented point of view. Our focus was to create an information system that will provide full data history needed for compliancy and auditability.Starting from Leger des Heils’ operational database (ODS), we built a data vault that could enable historical detail reports, audit logs and more.
For this data vault we built several data marts that will allow the data warehouse’s users to retrieve the necessary information. For instance, we created a current financial monitor featuring multiple dimensions, including the organisation, the product/program, the time, and the client dimension.
Solution: Business IT Consultancy, IT Development Projects, System Development Capacity , System Maintenance & Support, Enterprise, Web, Professional Services
Client: Thomsons Online Benefits
Solution: Business IT Consultancy, IT Development Projects, System Development Capacity , Enterprise, Web, Media
Client: World-Leading Media Management Company