Bank
Building a data warehouse for company-wide reporting using Continuous Integration and Continuous Delivery
Starting point
- The control capabilities of the bank should remain ensured even after the planned migration of the core banking system
- A new data warehouse (DWH) is required as the foundation for future bank management
- The existing reporting system will be replaced by Tableau
- The implementation will be carried out using the technologies Exasol and Tableau, complemented by Jenkins and Docker for Continuous Integration (CI) and Continuous Delivery (CD)
Procedure
- Project approach using the Kanban method with Scrum elements for agile development
- Integration of a mixed team with the business department
- Setting up a CI/CD pipeline to ensure continuous development, even with remote work
- Replacing the existing reporting system with new reporting technology
- Analysis of data sources and systems after the core banking system migration
Features/Project outcome
- Consulting for project management and the introduction of modern project methodologies
- Architecture and implementation of the new DWH
- Setting up and introducing the pipeline and process for Continuous Integration & Delivery for development
- Consistent reporting design and user guidance
- Security and access concept down to attribute level
- Standard and ad-hoc reporting thanks to the new frontend and data marts
Customer benefits
- Efficient and transparent management of the bank through forward-looking reporting
- Rapid analysis and decision-making capability thanks to the new database and frontend
- Security through knowledge transfer from the business department during the project work
- Continuous development through the CI/CD pipeline without high organisational and technical effort