Qudits designed a department-wide self-service reporting service for a cantonal administration unit — from requirements gathering through the target and authorization architecture to first live dashboards. The result: up-to-date key figures instead of manual Excel work, and savings potential in the six-figure range per year.
Situation
Reporting ran on a grown, cost-intensive analytics landscape with over 1,000 reports and around 120 data sources — annual licensing costs in the range of CHF 150,000–200,000. Most of it was prepared by hand, the source systems were spread across numerous offices and followed no common logic. A unified target picture, a viable authorization model for sensitive data, and the information-security and data-protection foundation were all missing.
Solution
Requirements were gathered in workshops across all offices, and the existing reporting landscape with ten heterogeneous source systems was analysed. This produced an end-to-end target concept: a central data platform as an architectural building block, a role-based authorization model with multi-level sensitivity classes, the legal framework (protection needs, information security, data protection) and a migration roadmap — complemented by an internal data community for sustainable adoption. In parallel, first live dashboards for finance and HR controlling were built as a proof of concept. Qudits was responsible for stakeholder management and clarifications with subject-matter experts and developers.
Impact
The new service enables replacing the expensive legacy landscape without additional licensing costs — with savings potential of CHF 150,000–200,000 per year. Live dashboards replace manual preparation and deliver key figures daily. The role-based authorization model ensures data-protection-compliant handling of especially sensitive data. This lays the foundation for an administration-wide reporting standard and data-driven decisions — and data quality was noticeably improved during the survey.
Qudits’ role: Project lead & BI consultant
Facts & Figures
- Analysis of data from 4 offices and 10 source systems
- Over 1,000 reports inventoried
- Savings potential CHF 150–200k per year
- 1 consultant · ~8 months