The introduction of the new Dealer Management System (DMS) platform, an innovative management system designed for the network of the main Volkswagen Group dealers, made the existing operational reporting environments and decision-making systems unusable, making the dealership "blind".
In order to resolve this critical issue, it was necessary to implement a new BI system with a flexible, fast and extensive technology.
The move to QlikView proved successful because, within a short timeframe, it both enabled all areas of the business to regain access to data that was essential to their daily activities and accompanied the rapid development of the DMS by enabling dealers to adapt without any service downtime.
This single technological environment for both ETL and data presentation makes it possible to analyze aggregate data with the use of stunning dashboards or to view operational reports and access the various accounting documents.
The BI system implemented enabled the organization to harmonize and analyze data coming in from all of Giacomel’s management applications:The DMS platform –CROSS2, the dealership management system, and Navision for accounting; VGI System for Volkswagen data; external sources for data not stored on centralized systems (local Access databases and Excel files).
The areas involved in the analysis include:
- Administration, Acconting and Management Control
Analysis of withholdings settled and to be settled, aging of invoices, analysis of adjustments (credit and debit notes) to supplier invoices, the proper application of discounts established by Volkswagen, sales margins, analysis of cost for internal vehicle work, sales forecasts, physical and accounting-base vehicle inventory, dashboard for the analysis of current vs. prior year revenues, monthly and quarterly sales trends.
- Sales (New and Used)
Analysis of sales by agent, by customer, by type of customer; analysis of orders and of available vehicles; analysis of sales to leasing companies.
- Monitoring of company processes
By intersecting data from the three systems, it is possible to keep track of business processes and, consequently, to control the buying and selling processes of new and used vehicles, includingissuing orders, recording supplier invoices, properly entering vehicle data, issuing sales documents, controlling registrations, and balancing accounts.
