About opseo
The opseo Group is a leading provider of out-of-hospital intensive care. With a network of specialised nursing services across Germany, it offers tailored assistance for patients in supported living communities and in their home environments. The company's mission is to enable those in need of care to lead a self-determined and dignified life through professional support.
Client | opseo Holding B.V. |
Industry | Pharmacy & Healthcare |
Technology | Microsoft Power BI, Microsoft Power Apps |
Focus | Data-Driven Business, User Experience Design |
Initial Situation at opseo
In an increasingly data-driven business world, effective reporting is essential to well-founded decisions and long-term success. opseo already had a Power BI report in place, but its complex structure meant that it was rarely used. Numerous navigation options and the cluttered visual design made it difficult for users to quickly access crucial information on the utilisation of nursing staff and care facilities. In addition, manual data entry by countless stakeholders reduced the accuracy and informative value.
To lower the hurdle for users and unlock more value from the data, opseo decided to team up with dotSource. Particular attention was paid to the following aspects:
- Support in improving data quality
- Enhanced acceptance and usability
- Greater transparency throughout the reporting process
Project Successes
Structured Requirements Elicitation and In-Depth User Insights
The project began with a joint requirements workshop to identify relevant stakeholders and their information needs. Together with users, various use cases were defined, key performance indicators (KPIs) were established, for example relating to patient care and capacities, and the framework for consistent data analysis was refined.
This collaborative approach laid the foundation for a user-centred redesign of the business intelligence landscape, taking into account opseo's corporate design.
Iterative Development and Practical Knowledge Transfer
An agile way of working with weekly meetings, a Kanban board and close collaboration with dotSource's design team made it possible to gradually improve the report. Users regularly tested prototypes, allowing opseo to gather feedback at an early stage and implement targeted optimisations.
Through pair programming sessions with dotSource's data experts, opseo's controlling team was empowered to independently make adjustments in Power BI. Training courses, internal information resources and regular drop-in sessions further strengthened users' understanding of data analyses.
Automated Data Checks and Effective Validation Processes
To enable KPI verification for the Power BI report, dotSource developed a Microsoft Power App. This gives managers the ability to examine irregularities directly and – if required – trigger changes in the source system. This in turn boosts data quality and increases both acceptance and use of the report, with monitoring time cut from several days to only a few hours.
This combination of optimised reporting, active user involvement and data-driven controlling creates a solid basis for efficient data and KPI management that lives up to the high standards of the care industry.
You Too Can Benefit from a Powerful Reporting Solution
- Efficient reporting structures for faster, well-founded analyses
- Intuitive dashboards with easy-to-use navigation
- Reduced manual effort through smart automation
- Flexibility and adaptability to cater to your industry's requirements
Data-Driven Business Consulting Session
Further Information
Our Data-Driven Business Services
Your Contact for Further Questions
