- Data from processing transactions for hundreds of financial institutions across the Midwest
- Public data generated by clients, including line of business and operations data
The vast amounts of data they have collected and stored over time, coupled with the copious amounts of data produced in the financial industry, meant that Bankers’ Bank faced a tremendous opportunity to reimagine the potential data solutions around combining historically siloed datasets.
Solution: Aligning people, process, and technology
People: The catalyst for change at Bankers’ Bank was finding the most strategic and direct path forward for the data initiative, given that the data team was a diverse mix of technical experts, an administrator, and citizen data scientists, all of whom collaborated with the business units to determine an area of focus through a Minimal Viable Product (MVP). To effectively bridge the gap between where these collective stakeholders were, and the journey to becoming data-driven , the solution not only had to work well given the diversity of each user profile, but it had to empower them via enterprise-grade tooling and sustainable, collaborative processes.
Process: Ultimately born out of that MVP, Bankers’ Bank aimed to determine which data projects to prioritize, with a laser focus on gaining executive buy-in for the ones that would spark initial value and could later be replicated and expanded across the business. A critical part of that process is tooling, and Bankers’ Bank worked closely with Amplifi to find Dataiku. Amplifi is a trusted data and AI consultancy that leverages partners such as Dataiku for its end-to-end analytical capabilities and collaboration-driven features.
Barbara Gross, SVP and CIO at Bankers’ Bank, said that Amplifi was pivotal in their process, acting as their guide, listening to them, learning about their business, and challenging them, helping them use information better and improve on how they understand people’s consumption of data.
For Bankers’ Bank, Amplifi suggested an industry-standard agile methodology approach called CRISP-DM which includes business understanding, data sources and pipeline, prep and modeling, and findings.
Technology: While not a magic bullet, technology in this instance was the glue that brought people and processes together. Most critically, Bankers’ Bank uses Dataiku for reporting and dashboards that had previously been compiled in Excel. Given that Bankers’ Bank’s Board of Directors uses this data for critical business decisions and financial reporting, Dataiku gives them the visibility and governance needed to ensure that the data is correct, reliable, and repeatable.
Upon using Dataiku, Bankers’ Bank has been able to:
- Help team members clearly see the data journey from raw data to business insights through visualizations in Dataiku (giving people a better sense of where data is cleaned up, combined, and used)
- Avoid reliance on Excel experts, making data analysis more attainable for people that might not have Excel-specific technical skills or SQL experience
- Utilize a centralized data source so everyone has visibility into how specific reports are made and work can easily be duplicated, which eliminates not only double work but the need to rely on one single person for valuable reporting
Results: Insights in 30 minutes instead of 2 business days
One example of their success is around an analysis that tracks how effective each cross-sell was (i.e., is the sales team selling the right products?). Originally, the report was created quarterly and took 16 hours every quarter to prepare, for an annual total of 64 hours spent.
With Dataiku, the time spent on validation went down significantly and the report is delivered in a predictable, consistent, and accurate manner and will soon be delivered on a monthly cadence - something that could not have been imagined given the previous work effort.
The savings translate to an actual time reduction of 87% (it now only takes 30 minutes to prepare!) Analysts can now use that extra time to work on other, more high-value projects.
Additionally, having the report on a monthly basis instead of quarterly will provide a tool for the sales team to be more accountable, as their success will be more transparent and they can more easily fine tune their sales sequence. The sales team also does transactional reporting on the different volumes of transactions they process, which was previously very manual.
Data was pulled in from various sources (including a CRM), and validation included extensive backtracking to pinpoint where any errors occurred without visibility to the entire data flow, which was, at times, like finding a needle in a haystack.
Improvements across job roles and departments
Now, the Bankers’ Bank team has been able to reduce time associated with pulling that data while simultaneously improving the data quality and reliability. They no longer must do everything manually, which increases trust in the reports and their insights. Without having to re-prep certain elements of the data each month, the team has been able to save time on low value, repeat tasks while infusing reliability, traceability, and versioning across their reporting processes.
“It’s been a pleasure to watch Bankers’ Bank move along on their journey from MVP to making great strides toward becoming a data-driven organization in less than one year. The change management around establishing a data culture is critical.” - Virginia Maus, Data Consultant at Amplifi.
The next steps for Bankers’ Bank
In 2020, Bankers’ Bank was focused on making a valid business case that broader data and analytics are valuable to the enterprise. Now, they are focused on making more processes repeatable, continuing to have one source of truth for data projects, improving the data available to their sales team, and cutting down on spreadsheet-onerous projects.
They are in the midst of exploring Dataiku as a recommendation engine and look forward to using Dataiku for modeling. They are excited to leverage their unique value to integrate isolated data sources with data science into a robust solution to create new business opportunities and further differentiation in their market and in service to their customers.
"This year, we are expanding beyond our 2020 focus of exploring the better management and use of data to support internal initiatives for the success of the divisions to how to use data at scale to make the bank solutions set offerings more successful and valuable for our customers. Formal processes and linking the data sources in Dataiku will help us do that.” - Barbara Gross, SVP/CIO, Bankers’ Bank
