Accuracy is crucial when it comes to managing money – especially when tackling hundreds of millions of dollars in annual revenues. A U.S.-based financial services powerhouse monitors its money and operations with precision, but the complex process was recently on the verge of becoming a major headache. The company’s services division handles all efforts from the consumer banking department, including checking, loans, and wire transfers. To better understand the function and performance of each department under its umbrella, the services division was tracking over 600 metrics manually every month. As the company grew, so did the data – adding more complexity.
The services division needed an automated system to easily access report metrics, assist in executive decision making, establish benchmarks, and calculate bonuses. The company partnered with BlueGranite to design a custom solution to fill those needs.
Employees here were collecting files upon files of data from every department and manually entering it into their homegrown system. The team used this system to store the data, export it, and load it into another database for further review. The final database then fed the organization’s data back out into another file format, leaving the client services division with a confusion of reports that were challenging to understand and provided little insight. This long and tedious process yielded few helpful results.
Not only was the process cumbersome, but some reports were outdated and included metrics no longer relevant to the organization. And manually updating and tracking thousands of lines of data was unmanageable and unsustainable.
We worked with the services division to create a standard data collection process that reinforces data governance strategies. We began building and implementing the solution after that data collection process was complete.
BlueGranite developed a solution using Azure and Power BI that replaced nearly all the original infrastructure. The new, semi-automated, cloud-based database runs much faster and feeds the company’s metrics into custom Power BI dashboards. The regularly updated reports are easy for the executive team to access and include summary pages for high-level planning. An example of the modern environment is shown below:
The company can now see trends over past months, drill down into deeper detail, address failures, and get a better idea of how each a department is performing overall - all thanks to dashboards that provide daily and monthly metrics. Additionally, since the new reports take so much less effort to produce, some team members can now dedicate more time to continuing improvement, taking on projects the firm didn’t previously have time for.