Financial Services

Modern BI

Financial Services Firm Improves Data Governance with Power BI

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.

Financial Services Firm Improves Data Governance with Power BI.png

The services division needed an automated system to easily access report metrics, assist in executive decision making, establish benchmarks, and to calculate other various costs. 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.

Want to learn more about how BlueGranite can help with your enterprise BI needs? Contact us today!

How We Did It

  • We designed and implemented a data mart in Azure SQL Database to organize the client’s metric gathering process in a meaningful way, allowing the data to be effectively analyzed.
  • BlueGranite experts then defined a series of Power BI reports to consume the client’s metric data for their executive leadership team to use for informed decision making.
  • We also illustrated a business process designed to facilitate and ensure that the client’s data stayed up to date regularly.