The real estate division of Crédito Agrícola oversees the bank’s recovered assets—properties acquired through credit transactions and subsequently put up for sale as part of a divestment strategy. One of the key outputs of this department was a comprehensive monthly report detailing the bank’s evolving position, following rigorous internal evaluation controls. Due to being a substantial document of around 200 pages, the preparation of this report consumed 2 to 3 weeks every month, leaving the division’s personnel limited time for other tasks.
“It took us 2-3 weeks each month, so we couldn’t do almost anything else other than be here preparing this 200-page report.”
– Tiago Fernandes, Property Strategy and Management Office, Crédito Agrícola
Recognizing the time-intensive nature of the process, the reporting frequency was eventually adjusted to a quarterly basis. However, even in this revised format, the report continued to demand a significant portion of the department’s time, limiting its capacity to perform other tasks. The data utilized for this report was sourced directly from Crédito Agrícola’s Datawarehouse and underwent processing in Excel before finally being incorporated into a PowerPoint presentation.
After attending a Dashboard in a Day workshop conducted by our team at DevScope, Crédito Agrícola became acquainted with the capabilities of Power BI and decided to explore its potential. The bank enlisted the services of a consultant to develop a data model, create visualizations, and initiate work on automating data processes to streamline reporting. Unfortunately, the outcomes fell short of the team’s expectations, particularly in terms of visual presentation and data loading speed. To make matters worse, there was no notable reduction in the workload associated with the production of the report.
Despite these challenges, Crédito Agrícola saw potential in Power BI and reached out to DevScope to resume and enhance its implementation where they had left off.
