WE CREATE ARTWORKS, CONCEPTS, INTERIORS & BRAND DESIGN
ANALYSE EVERY RECEIPT IN DETAIL EVERY DAY
FORMULAS AND MACROS IN EXCEL
In the past, all these analyses were carried out via Excel queries on the data extracted from the ERP solution by employees. As a result, the quality of the data sometimes left a lot to be desired, while the analyses often just provided a general overview. After all, not every employee has the knowledge to project figures in complex formulas and macros in Excel. For example, it was difficult to draw the right conclusions from the analyses and to draw concrete actions from them.
FASTER, MORE DETAILED ANALYSIS
In the search for a suitable Business Intelligence tool, AVA eventually found QlikView. The interfaces with other systems, such as AS400 and the checkout and accounting packages, the tool enables faster, more detailed analyses. Both for sales and for the logistics and finance department.