Cloud-based data analysis in the public sector

Public Government

Our client is a public administration sector and acts as the central coordinating and advisory body of a German state government, where it provides support for administrative and representative tasks.  The organization has awarded a long-term framework contract for licenses of a BI software with implementation and continuous managed service of the cloud infrastructure. The software was to be used as a central platform for data visualization and analysis for public offices.

Customer situation

  • The customer had not previously used a standardized, central business intelligence tool for data visualization
  • Distributing and displaying general information and statistical data was difficult to implement manually
  • The new solution needed to be suitable for public and internal user access
  • High cloud security standards according to GDPR and BSI had to be met
  • There was a lack of data protection, deletion, role and rights concepts that needed to be developed
  • Requirements and K.O. criteria regarding accessibility in the public sector had to be met by the new solution

Procedure

  • Collaborative design of a strategic roadmap
  • Design and implementation of an integrated Tableau Server landscape
  • Setup and management of Tableau Server instances in the Open Telekom Cloud
  • A data protection concept in accordance with GDPR was created and implemented with the customer's specialist departments
  • An accessibility assessment was carried out and improvements implemented
  • M2 supported the creation of dynamic, interactive dashboards
  • Training programs for self-service analytics and dashboard design were carried out

Project result

  • Successful implementation of a secure data visualization environment within the local administration network
  • Automated cloud configuration and Tableau deployment via Blue-Green process and Terraform API
  • Operation of the Tableau Server in a multi-zone architecture in Germany for increased reliability
  • Continuous monitoring and management of the infrastructure and the Tableau application
  • Coordinated data protection concept according to DSGVO
  • State-of-the-art dashboards for the visualization of data analyses