Leading credit union deploys an enterprise grade analytics tool for more flexible, reliable reporting and advanced analytics.
This credit union has grown into one of the largest full service financial institutions in the Northwest with more than 100,000 members and close to $2 billion in assets under management. In an effort to build close relationships with each member, the organization has committed to delivering new financial services and products, from online and mobile banking to one-on-one, customized financial planning conversations.
An early adopter of BI, this financial organization has always been committed to leveraging member information as a strategic asset to both improve member relationships and enhance the member experience.
This organization previously partnered with Datasource Consulting to develop a robust enterprise data warehouse solution. They turned to Datasource again to upgrade an existing legacy BI reporting tool. The original data management tool lacked adequate flexibility and enterprise grade functionality.
Executive leaders partnered with Datasource to fully leverage their new data warehouse. They also wanted support implementing a more robust enterprise reporting solution that offers greater consistency in reporting and more comprehensive dashboard capabilities across the organization. Leaders outlined key objectives for the engagement:
- Configure, develop, and implement – develop a project plan to install and configure the new BI technology, develop the metalayer and all needed documentation to support the implementation, and transition to the BI reporting solution
- Access to reporting, dashboards and KPIs – give core business users (20 to 25 individuals) access to a robust self-service reporting solution, including standard reports, dashboards with corporate KPIs, and ad hoc report development capabilities
- Provide support – build the solution for power users to develop and modify reports to accommodate enterprise stakeholders’ future analytics needs
Datasource teamed up with the organization’s development team and business contacts to outline key deliverables for the project, including:
- Analyze existing reports – prioritize credit union reports to be built, consolidated, or retired
- Map report contents of critical reports – leverage reports written in the previous reporting system against legacy databases and map them to the new data warehouse to be developed using the new BI tool
- Metadata management – manage the metadata and allow for expansion as the BI program evolves
- Test cases – create test plan to include specific test cases and scenarios as well as anticipated results for future development
- ‘Gold standard’ report approval process document – develop documentation and test reporting guidelines to support a report approval process to validate current and future reports before the data is shared
The BI tool implementation was delivered successfully, both on time and under budget. Executive leaders and business partners were extremely satisfied with the development and implementation. Users were trained on the reporting solution, and the team is on track to fully decommission their legacy reports and data warehouse by year end.
Today, key business users have self-service access to critical member data, reports, and dashboards as well as other needed credit union data. They can now fully utilize the data warehouse and use the new BI solution for greater insights. Power users can also create customized reports, as needed. Through a simplified interface, the solution delivers sophisticated reporting, dashboards, and ad hoc query capabilities, utilizing now readily available data.
Users can view the performance of various business areas, which is essential for providing an exceptional experience for members:
- Built report matrix with metadata on approximately 250 critical and high priority reports − utilizing membership, credit and debit cards, loan servicing, re-financing, compliance, risk, etc.
- Report request process – with the metalayer built out, users can develop new reports following the gold standard report template that incorporates workflows for requirements, testing, and approval
- Drag and drop report building – users don’t have to be technical to create additional custom reports (by following the template, reports are also validated and consistent)
Looking ahead the credit union will continue to expand its use of their new BI capabilities with the goal of strengthening member relationships and improving competitiveness in the marketplace.