BI for Fratelli Giacomel

The introduction of the innovative Dealer Management System (DMS), a platform designed for the network of leading dealers of the Volkswagen Group, made the previous operational reporting and decision-making systems unusable, thereby effectively blinding the dealers.
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.

Facebook

Google Plus

LinkedId

Qwerty Informatica S.r.l - Viale Bligny 15 - 20136 Milano - P.Iva 12932200152 - Capitale Sociale € 10440 i.v.

This website or third-party tools used in this make use of cookies required to operate and useful for the purposes described in the cookie policy. If you want to learn more or opt out of all or some cookies, see the cookie policy.

I accept cookies from this site.