Customer: German Federal Police (Bundespolizei)

Challenge: Consolidate and consistently analyze data from disparate source systems for statistics, statutory reporting and deployment planning

Solution: Centralized, open-source-based BI and data warehouse platform using Pentaho, supported by it-novum with consulting, implementation, support and licensing

Result: Faster access to information, consistent analysis and more needs-based deployment of personnel.

Technologies: Pentaho Data Integration, data warehouse, reporting and analytics, geospatial visualization and standardized interfaces

Approach: Automated consolidation of data from statistics, command-and-control, flight schedule and time-recording systems into a central information base

Special challenges: Heterogeneous data sources, daily updates and evolving operational and statutory requirements; the open architecture supports flexible adaptation

Measurable success: Central processing of data across 20 statistical areas and daily processing of nationwide flight schedule data

Customer benefits: Faster statistics and reports, timely responses to external requests and reporting obligations, and more efficient deployment and roster planning

Long-term impact: An extensible data platform with strong integration capabilities and a technical foundation for legally permissible data exchange across public authorities