Health

Make the most of working time: create reliable reports and clear indicators

In a hospital environment where time management directly impacts the quality of care and team efficiency, a Swiss healthcare institution is struggling to reliably make use of the hours recorded by its staff. In the absence of clear indicators, analysis remains limited, decision-making slows down, and adjusting projects in line with ongoing activity becomes more difficult. To structure its data and optimise resource allocation, the organisation has turned to Qim info.

Manual time tracking: an incomplete view of team activity

Currently, staff members manually enter their working hours into Excel spreadsheets. While this tracking method is simple, it does not allow for the generation of reliable indicators or for accurately assessing the time spent on different projects. The analysis remains partial, making it difficult to detect trends, discrepancies, or changes in time allocation.

This lack of visibility hinders decision-making and complicates resource management. In an environment where work organisation directly affects the quality of care, these limitations also weigh on the organisation’s ability to manage projects effectively.

Work time reporting: extracting clear indicators from recorded data

Staff members want to make use of the hours they’ve entered to better understand how their time is distributed across different projects. To meet this need, the collected data must be structured and translated into clear indicators that allow for:

accurately measuring the time dedicated to each task,
tracking activity trends over time,
identifying patterns that support better work organisation.

Qim info quickly identifies that the challenge is not simply to optimise an Excel file, but to design a complete chain for processing, analysing, and visualising HR data.

Automated reporting: a structured approach in four key steps

Qim info designs a bespoke reporting solution, structured around four key stages:

Data preparation,
Extraction, transformation, and modelling,
Creation of indicators and reports,
Documentation of the system.

A data specialist is assigned to lead the entire project in close collaboration with internal teams. Their expertise ensures consistency in data processing and the reliability of the indicators produced.

Discover the role of a data manager.

Structuring Excel data for automated reporting

The teams continue using their usual tool for data entry: Excel. Qim info steps in early to structure the files and make them compatible with the reporting process. This initial step ensures that the data can be effectively used within an automated framework.

Processing HR data with SQL Server to ensure reliable analysis

The Excel files are automatically imported into a Microsoft SQL Server database. The data is extracted, cleaned, and modelled to feed into the reports. This processing guarantees the quality and structure of the information required for analysis.

Creating automated indicators and interactive reports with Qlik Sense

The prepared data then feeds into automated reports and dynamic dashboards built with Qlik Sense. Indicators are updated automatically whenever the Excel files are modified, ensuring a reliable and continuous view of activity. Thanks to these visual reports, teams gain a clear overview to analyse working time, monitor project progress, and adjust their organisation in real time.

Documenting the solution to ensure autonomy and sustainability

To ensure teams can work independently, Qim info provides detailed documentation: update procedures, report user guides, and best practices. This deliverable supports the adoption of the solution and ensures its long-term sustainability.

HR Reporting Tools: Why Choose Excel, SQL Server, and Qlik Sense

Each tool used in this project meets a specific functional need: ease of data entry, processing performance, and clarity of analysis. Qim info selected these technologies for their complementarity, reliability, and ability to integrate into a fully automated process without disrupting users’ habits.

Excel: simplified time entry

A universal tool already well mastered by the teams, Excel remains a natural entry point for recording working hours. By structuring the files and adapting their format, Qim info transforms this everyday usage into a reliable data source, ready for analysis.

Microsoft SQL Server: reliable processing of HR data

SQL Server centralises the files, orchestrates data processing, and prepares the indicators needed for reporting. Its robustness ensures consistent calculations and long-term system stability.

Qlik Sense: clear visualisation and intuitive analysis

Qlik Sense showcases the transformed data through visual and interactive dashboards. Users can easily access indicators without needing technical skills, encouraging adoption and simplifying analysis at all levels of the organisation.

Results achieved: reliable data, simplified reporting

In just 25 days, Qim info implemented a complete solution that enables the organisation to:

centralise recorded data in a structured database,
automate the processing of recorded working hours,
generate up-to-date reports without any manual intervention,
visualise clear indicators to better monitor projects over time.

Access to reports is simplified, the information is reliable, and the entire system integrates seamlessly into the teams’ existing practices.

Qim info expertise: BI support and HR data enhancement

Qim info’s Data & Innovation division supports organisations in implementing Business Intelligence (BI) solutions by building robust data environments aligned with business needs. With teams based in Geneva, Lausanne, Zurich, Basel, Annecy, and Lyon, we operate locally or remotely to design automated reporting systems that ensure reliable indicators and facilitate decision-making.

Beyond the technical aspect, each project aims to empower teams, streamline operational analysis, and establish a sustainable use of HR data.

Looking to automate your reports, structure your data, or gain clearer insights into your activity?
Contact our experts to co-create a tailored solution.