A North American Banking Conglomerate Turns to TimeXtender’s Discovery Hub® for Help Automating Revenue Reporting Processes
The North American branch of this global banking conglomerate offers a variety of services to its customers. However, with the constant growth of its offerings, a data management platform was needed to better track revenue.
AUTOMATION AND CONSISTENT REPORTING
Our banking customer has grown into a conglomerate with a global network of financial and business centers servicing both individual and corporate customers.
The customer’s North American branch was hampered with inconsistencies in management reporting on product revenue, department finances, customer information, transaction cashflow, as well as challenges pertaining to data governance, data ownership, and a lack of automation in the company’s reporting process.
Several disparate sources hosted the company’s data. Specifically, our customer retrieved client data from Salesforce. Data was stored in 17 diverse and unstructured Microsoft Excel files that contained multiple pie charts and graphs from different owners in different departments. The numbers in the Excel files would frequently fluctuate, and it was hard to track how occasional data misalignment issues occurred. Each of the files contained different formatting, and no single person owned the process, which resulted in frequent inconsistencies. When a new product was created, our customer would simply create a new spreadsheet for it. The challenge was to take this structured and unstructured data estate from different Microsoft Excel files and Salesforce and aggregate it into one meaningful view.
CONSOLIDATING DATA FOR ONE VERSION OF THE TRUTH
TimeXtender’s Discovery Hub® data management platform was carefully chosen as the solution to transform the bank’s analytical environment to help improve consistency in product revenue reporting. With Axis Group’s support, implementing Discovery Hub®
allows the bank to connect and consolidate its structured and unstructured data, catalog, model, move, and report on the full lifecycle of data – in a single application that supports core analytics, compliance and a modern data warehouse. Since access to this data is vital
for day-to-day banking operations, our customer hosts their solution on Microsoft SQL Server Enterprise Edition.
SIMPLIFYING DATA MANAGEMENT
With the implementation of Discovery Hub® for the bank’s data architecture needs, Axis Group was able to complete a data overhaul, quickly and securely. Formerly five people spent 40 hours per month on the management of the entire process, including collecting spreadsheets and processing them for report outputs – now, the entire process is automated. The bank can now reallocate those five people to other parts of the organization. Further, when a new manager joins the team, the bank can provide them with Discovery Hub® documentation that clearly shows where the source data is coming from. With the power of automation and AI technologies, our customer now has access to a more streamlined, simplified data management solution and is well positioned for future migration to the cloud.
- North American branch of a large bank that has a global network of financial and business centers
- Managing several disparate data sources for reporting on product revenue
- Reduce inconsistencies in reporting and reduce hours of manual reporting labor
- Needed a data management platform that could support future growth
SOLUTION & BENEFITS
- TimeXtender’s Discovery Hub® was chosen for its powerful data management capabilities and ease of use
- Ability to connect and consolidate structured and unstructured data
- Fully automated and stream lined process for management and reporting on product revenue
- Internal resources can be re-allocated to support other departments