Trade fair organiser
Building a hybrid architecture for comprehensive data analysis
Starting point
- The system landscape for data analysis is outdated and consists of isolated solutions
- The reporting is based on Cognos 10 reports and an Oracle database. There is no DWH-layer architecture, only complex SQL scripts for data management
- Separate CRM data processing in Talend ETL with storage in Excel and PostgreSQL
- Cross-sectional analyses or the application of AI algorithms are impossible; standard reports are cumbersome to implement
Procedure
- Creation of a Big Picture architecture and a business object overview
- Detailed modeling of the data model in Data Vault
- 2-week sprints
- Takeover of project operations
Features/Project outcome
- Comprehensive platform with multiple layers made usable
- Consistent setup of the three environments: DEV, TEST, PROD
- Migration of many existing Cognos reports
- Tableau workshops for self-service analytics
Customer benefits
- Connecting any data sources to the central data lake platform
- Cross-business data model based on Data Vault for new cross-linkages
- Foundation created for the use of AI algorithms and real-time data supply
- Data lab environment for data experiments outside of the production loading paths
- Scalable data archive for long-term storage
- Independent analysis by specialist departments in Tableau, relieving the IT department

Johannes Heinen | Senior Manager / Authorised Officer