Customer Story

Asset Management Company Reduces Quarterly Reporting Process from 3 Days to 10 Minutes

What we did

  • Moved the company away from Excel and developed an interactive solution in QlikView
  • Time to determine key metrics and compile into a report decreased by over 99% – from three days to 10 minutes
  • An NPrinting report exports the metrics and automates distribution across the company

Industry

  • Financial Services

Technologies

  • Qlik

Business Problem

An asset management company lacked a solution to view important financial metrics, such as raw EBITDA, revenue by issuers and industry, and year-over-year growth. In order to determine these metrics, IT, Operations, Marketing, and Product departments had to collaborate and perform manual computations in an enormous antiquated Excel file. While this process was highly manual during the most stressful time in the quarter, it was also prone to error. Furthermore, if data quality issues were found upon inspecting the final report, Operations had to fix the source data and then start all over.

Solution

Analytics8 moved the company away from Excel and developed an interactive solution in QlikView that allows them to:

  • View Key Metrics: View the raw EBITDA and Revenue by various dimensions and relative year-over-year growth percentages.
  • Ensure Data Quality: The solution includes a data quality tab that checks for frequently known issues, such as missing Industry or Financial Date.  A data quality report is also emailed 2 weeks prior to the deadline so that operations may address any issues on a timely basis.
  • Automate Reports: An NPrinting report exports the metrics and displays them in a report that is distributed among the company.

Results

As a result of this automated solution, the time to determine key metrics and compile into a report decreased by over 99% – from three days to 10 minutes!  By removing manual calculations, the CEO can get the numbers he needs faster, and everyone else can focus on other quarter-end processes.  Because the Qlik solution clearly highlights data quality issues, rectifying reports has become much more efficient.

Talk With a Data Analytics Expert

Talk with a data expert

Schedule a meeting with one of our data analytics experts who will review your data struggles and map out steps to achieve data-driven decision making.

Request a session