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