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.
Analytics8 moved the company away from Excel and developed an interactive solution in QlikView that allows them to:
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.
Sign up for a data strategy session, and one of our analytics experts will consult with your company about your data and analytics strategy.