QlikView implements Performance Management for large retail chain
Posted on Thu, Aug 19, 2010
QlikTech today announced successful enterprise deployments of QlikView business intelligence software by VIP Parts, Tires & Service, the largest privately owned automotive aftermarket retail chain in New England. VIP’s business footprint spans wholesale, fleet and commercial divisions, as well as 56 retail stores. Using QlikView to integrate, analyze and search millions of transactions from operational and POS (Point of Sale) systems across locations, VIP moved from green-bar and spreadsheet reporting to real-time operational scorecards and holistic, multi-level views of business performance, improving management controls and response to business issues.
VIP recognized a need to embrace an enterprise-wide business intelligence system that could reach the furthest parts of its organization and bring data from multiple departments and sources together into a single solution. After an exhaustive search, VIP selected QlikView based on its ease of use, pre-integrated tools such as ETL (Extract, Transform and Load), and the ability to provide web-based access to data search, analysis and reporting throughout the company.
“Our CEO became one of the biggest fans of QlikView because it allowed him to drill down through corporate data right to the SKU level. District managers are thrilled to now have access to the same performance-based reports that they can share with store-level executives,” said Dan Grosz, the company’s VP of Information Systems.
VIP rolled out its first QlikView dashboards focusing on store operations in only a few weeks and achieved all its initial goals in just nine months, covering functional areas such as:
- Executive Analysis, increasing C-level visibility of operational KPIs by consolidating data from all parts of the company into a single QlikView
- Sales Analysis, leveraging POS data in new ways such as ranking sales by vehicle type down to SKU level
- Marketing Analysis, aligning merchandising and dealer services with customer purchasing patterns
- Operational Analysis, tracking store performance down to technician level
- Supply Chain Analysis, tracking inventory turns and Gross Margin Return on Investment (GMROI) down to SKU level (Prior to QlikView, calculating inventory turns was a slow, laborious process that limited calculations to only “buckets” of parts and tires. GMRO couldn’t even be calculated.)
- Payroll Analysis, consolidating payroll reporting and managing payroll performance from an enterprise view.
With QlikView, VIP drill down into detailed customer buying patterns and company performance across their wholesale and dealer businesses any way they want. Operational scorecards with data views matched to the specific needs of each end user provide the ability to set goals, quickly identify problems and track progress against them.
About VIP Parts, Tires & Service
VIP Parts, Tires & Service is New England’s largest privately held automotive parts and accessories chain. Based in Lewiston, Maine, VIP has 56 stores in Maine, New Hampshire and Massachusetts and a business footprint spanning retail, wholesale, fleet and commercial divisions. Since 1958, VIP has been the place where New Englanders turn for everything they need to keep their vehicles running at peak performance. VIP is staffed with ASE Certified technicians and counter personnel seven days a week and is the only New England resource for high quality, name-brand original equipment parts, tires and repair services. The company backs its prices with a 200% price guarantee and offers lifetime warranties on parts and labor
QlikPower is an implementation partner for QlikView. If you would like to find out how QlikPower can help you fill out the form here.