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

  • 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

Business Need

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.


Ready to start automating your processes?

Sign up for a data strategy session, and one of our analytics experts will consult with your company about your data and analytics strategy.

Contact Us

National Office Telephone | Mon-Fri 8:30am-5:30pm CT

Data Strategy Session

To thrive with your data, your people, processes, and technology must all be data-focused. This may sound daunting, but we can help you get there. Sign up to meet with one of our analytics experts who will review your data struggles and help map out steps to achieve data-driven decision making.

Learn More →

Fill out this form to get a 30-minute Data Strategy Session with one of our analytics experts.