Qlik Solutions per il Retail
Giorgio Dossena
10 June, 2015
2
CUSTOMER TRANSFORMATION TIMELINE
Transformation Phase
Introduction of Self Service Retail
Transformation Phase
Introduction of convenience
Transformation Phase
Consumerization of technology
Transformation Phase
Mobile Data-Driven retailing
Transformation Phase Introduction of
commuting to stores
DATA ANALYSIS TRANSFORMATION TIMELINE
Transformation Phase
Business Intelligence was about Gut Feel
Transformation Phase
Introduction of Management Information Systems
Transformation Phase
Introduction of Data Warehousing
Transformation Phase
Introduction of Business Intelligence
Transformation Phase
Introduction of Data Discovery
Produce reports based on transactional systems Nothing but good old fashion gut
feel based upon local knowledge
Consolidate transactional data to one location for analysis
Generate static reports and dashboards
Dynamic exploration of data to uncover unexpected insights
4
INVOLVED DATA
IT/HR
Optimize IT Management & Delivery of Services
Workforce Management, Remuneration & Training
Labor Scheduling & Payroll
IT Service SLA’s & Resource Efficiency
Governance across Compliance, Security & Data
Inventory of Fixed IT Assets and Licences
Finance & Executive Management
• Dashboards & Balanced Scorecards
• Enterprise Planning, Budgeting & Performance
• Financial Consolidation
• Predictive / What-If Analysis
• Governance & Risk Management
• Compliance - Regulatory, Environmental, EH&S
• Cash & Working Capital
Sales
Revenue & Margin - Multi-Channel Cross-Sell and Up-Sell Effectiveness
Budgeting, Planning, Forecasting & Tracking
Customer Service & Call Centre Operations
Franchisee Contribution
Sales Productivity at all Levels
Marketing & Customer
• Customer Intelligence
• Campaign Performance Analytics
• Social Media Analytics
• Market Basket Analysis & Footfall
• Segmentation, Targeting & Life Time Value
Merchandise & Buying
Assortment Planning
Buying Effectiveness
Vendor Performance
Price & Revenue Management
Markdowns & Discounts
Category Contribution
Gross Margin
Warehousing & Distribution
• Sourcing, Procurement & Vendor Analysis
• Damages/Seasonal Write-Offs, Warranty & Returns
• Inventory & Warehouse Management & Control
• Forecasting, Planning, Allocation & Replenishment
• Product Availability / Out Of Stocks
Transportation & Logistics
• Inbound and Outbound Transport Analysis
• 3PL, Carrier and Delivery Performance Analysis
• Advanced Shipping Notifications (ASN) Alerts
• On Time Delivery / Receiving Analysis & Tracking
• Equipment, Fuel and Total Landed Cost Analysis
Store Operations
• Store Performance Dashboard
• Labor Management & Payroll
• Customer Service Analytics
• Loss Prevention & Fraud Analytics
• Store Development
Qlik Retail Solution Focus
6
STORY TELLING
Customer Snapshot
Challenges
• Reduce effort required to track key performance indicators (KPIs) for the business
• Create a faster, more flexible, and more interactive business intelligence platform
• Deliver customized, real time analysis in easy-to-absorb presentations and dashboards
•Analytics without impacting the existing ERP system
Solution
• Qlik Dashboards implemented for Sales & Forecasting, Retail, Finance, Logistics, IT, HR, & Research &
Development
• By the end of 2012 Luxottica had 1,500 users, and 1,200 of those users were international sales staff
• Rolled out Qlik solutions for Sales, Retail, Finance, Logistics, HR, & Research & Development in several months
Benefit
• Qlik enabled self-service reporting at all levels of the
organization. Qlik access is open to any employee or partner who needs country- or store-specific information
• Qlik works in concert with existing software, eliminating the need for a major change in Infrastructure
• Qlik allowed IT to focus on high priority projects rather than creating and maintaining complex and error prone
spreadsheets Qlik enables us to collect data from the sales force to
define and publish the commercial forecast and allows for faster recognition and prediction of market
developments
“ “
- Massimo Rigobon, Responsabile BI, Luxottica Group
About Luxottica
• Industry: Retail, Distribution, & Manufacturing,
• Leader in the design, manufacture, distribution and sales of premium, luxury and sports eyewear
• 7,000 Stores with Operations in Italy, China, Brazil &
United States
Customer Snapshot
Challenges
• Analyze market results –clothing wearability, popular styles and shop sales
• Manage and fulfill extemporary requests for information.
• Monitor the turnover of in-store stock at each retail location.
Solution
• Deploy Qlikto 15 employees in just weeks.
• Analyze POS data, merchandising and inventory turnover – all focused on improving corporate and product performance.
• Manage the volume of POS data while granting easy access across its offices via the Internet
Benefit
• Delivered a data warehouse to hold and store all data from the retail locations
• Enabled documents to be sharedbetween on-site and off- site users
• Gained the ability to track, analyze and “drill into” sales recordswithout dimensional or hierarchical restrictions After evaluating the different solutions available on the
market, the company chose Qlik. The tool provides flexibility in corporate dashboards for management and ease in creating specific forms for individual users.
Executive, Grotto
“
“
- Executive, Grotto
About Grotto
•Grotto S.p.A. manufactures and distributes Gas clothing worldw
•Manufactures and distributes Gas clothing worldwide
10
World’s largest mobile
telecommunications
company
Deploying Qlik on iPad for strategic reporting system designed specifically for the CTO
Specialty food and spices
Deploying Qlik on iPad to entire sales organization – with purchasing and manufacturing to follow
Premium luxury eyewear retailer
Deploying Qlik on iPad to agents for showing real-time data on brands, models, stocks, and results
Leading Dutch mortgage
broker
Deployed Qlik on iPad across 180 branches for sales and marketing applications
Global publishing brand
Over 200 Qlik apps available to 10 business units and reporting delivered via QlikView on the iPad
Major heating and
sanitary wholesaler
Deployed Qlik on iPad to salesforce for self-service access to improve quality of customer interactions