An important bank required the implementation of the necessary architecture for the development of its business intelligence area.
It needed to develop efficient and reliable data models for data consumption, in order to reduce reporting and decision making times.
Three main fronts were determined to be worked on during the development of the project after completion of the diagnostic study
Strategic role of the area
Interviews were conducted along with case studies to understand the strategic role.
Implementation of new software
Opportunities and threats presented by the implementation of new management and analytical software were analyzed.
Information flows and requirements
Survey of all reports to be delivered by the area, their data sources, periodicity and contents.
Available data sources
Survey of all available data sources and tools.
Implementation of new software, creating database schemas and protocols to ensure stability, scalability and accessibility.
Migration of manual data treatment processes to ETL tools and enrichment of the information delivered with a greater number of data sources.
Implementation of BI tools that avoid the use of Excel, creating platforms for direct company-wide access to real-time data.
SAP BODS and SAP HANA were used to create the data model.
Developing efficient and reliable data models for data consumption
SAP Lumira was implemented for the creation of reports.
Decrease reporting times, increase levels of detail and segmentation of reports
SAP Fiori was used to share information across the organization.
Any process of digitization and modernisation of a company must be based on an efficient use of its data, with optimised flows for expeditious consumption