QlikView Customer Snapshot – VIP Auto

To address these challenges, VIP Parts, Tires & Service deployed QlikView to 140 senior, departmental, and district manager users across six functions in the US. The solution was used for executive analysis to increase the visibility of operational KPIs and consolidate data from all parts of the organization into a single QlikView. For sales analysis, QlikView was leveraged to use POS data in new ways such as ranking sales by vehicle type down to SKU level and tracking/analyzing sales rep performance. The solution was also used for marketing analysis to analyze merchandising and dealer services for customer purchasing patterns. Operational analysis was done to track store performance down to the technician level. Supply chain analysis was performed to track inventory turns and Gross Margin Return on Investment (GMROI) by SKU (or any aggregate based on item hierarchy). Lastly, payroll analysis was done to consolidate payroll reporting and manage payroll performance from a holistic view of the enterprise.