Retail Data Analysis

Retail Data Analysis

Sales and profitability analysis

Product sales analysis enables retailers to continuously monitor point-of-sale data to uncover sales trends, track product demand, and optimize merchandising strategies.

• Accounts Payable

• Accounts Receivable

• Advertising Expenses

• Customer Counts

• Discount Percent

• Gross Profit

• Inventory

• Product Cost

• Product Purchase Price

• Return on Assets (ROA)

• Sales Revenue

• Unit Movement

Store operations analysis

Information on store operations allows retailers to maximize the profitability of their sales

channels and empower executives with fact-based decision-making. Store managers can

effortlessly receive personalized sales, marketing, and inventory reports, store-vs.-store scorecards, and exception notifications, ensuring that time-sensitive issues are addressed and resolved.

• Asset Turnover

• Comparable Store Sales

• Competitor Stores

• Direct Stores Delivery

• Front Store Sales

• Inventory Turnover

• Labour Cost Analysis

• Percent Sold at Markdown

• Reallocation

• Register Usage Analysis

• Return on Assets (ROA)

• Margin

• Sales per Linear Foot

• Sales per Square Foot

Customer analysis

Understanding customer behaviour is essential to surviving in today’s retail environment.

• Attrition Risks

• Customer Profiling

• List Generation

• New Customers

• Post-Campaign Analysis

• Profitable Customers

• Segmentation

• Share of Wallet

• Target Marketing

Merchandise management

By effectively managing merchandise, retailers can maximize the profitability of the

Merchandising process.

• Active SKUs

• Department Contribution

• Hot Item Report

• In-Stock Percent

• Inventory Turns

• Lineal Feet

• Markdown Percent

• Pull-Through

• Reallocations

• Seasonal Buying

• Sell-Through

• Weeks of Supply

Inventory management

• Percent Defects

• Percent Delivered on Time

• Percent Shipped on Time

• Percent Space Utilized

• Percent Variability of Lead Time

• Average Inventory

• Back-Order Cost

• EOQ

• Excess Stock Cost

• Industry Ratio

• In-Stock Percent

• Inventory Carrying Cost

• Inventory Turns

• Item Fill Rate

• Markdown

• Obsolete Stock Cost

• Purchase Order Fill Rate Percent

• Rework or Scrap Rate

• Safety Stock

• Stock to Sales Ratio

• Stock-Out Percent

• Storage and Handling Costs

Supplier performance management

With extensive networks of suppliers, retailers need the tools to maximize supplier performance both individually and across their networks.

• Aging Accounts Receivable

• Aging Accounts Payable

• Average Price

• Burdened Direct Labor

• Customer Service Rate

• Days in Inventory

• Days Sales Outstanding

• Direct Material Cost

• Fill Rate

• Fixed Asset Utilization

• Fulfillment Accuracy

• Inventory Turns

• Inventory Write-Offs

• Lead Time

• Manufacturing Equipment Utilization

• On-Time Rate

• Order-Fill Rate

• Plant Utilization

• Quantity

• Stock-Outs

Marketing and e-commerce analysis

Faced with diversifying sales channels, retailers must understand customer behaviour across

channels to best target their marketing efforts. By analyzing customers’ transaction histories, stated preferences, and current interactions, Tableau enables retailers to identify

opportunities for improved promotions, special offers, recommendations, and targeted

advertising.

• Ad Blocks

• Advanced Ship Notices

• Brick-and-Mortar Store vs. Online Sales

• Channel Share

• Click-Through Rate

• Coupon Distribution

• Customer Subscription

• Endcap Efficiency

• Feature vs. Display

• Grand Openings

• Lead-to-Sale Conversion

• Market Share

• Marketing Spend

• Pricing

• Promotional Lift

• Sell-Through

Marketing analysts use Web-based dashboards daily to ensure maximum return on investment and manage promotions more effectively.

Market basket analysis

Market basket analysis allows retailers to determine which products customers buy in combination, as well as which customers have bought only part of the combination of products.

• Attachment Rates

• Basket-Register Correlation

• Brand Switching

• Core Item Frequency

• Core Items

• Customer Loyalty

• Demographic Baskets

• In-Basket Price

• Items Per Basket

• Revenue Contribution

• Shopper Penetration

Category management

With increasing pressure to focus on the customer, retailers must understand sales and consumer trends by gaining insight into merchandise performance by product, category, geography, and vendor.

• Assortment Optimization

• Average Quantity

• Category Contribution

• Market Benchmarks

• Pricing

• Role Analysis

• Season Changeover

• Section Percent of Store

• Share of Shelf

• SKU Rationalization

• SKUs in Category

• Vendor Performance

Loss prevention

Retailers have a huge opportunity to reduce costs by minimizing loss across inventory and

distribution channels.

• Back Orders

• Cancels

• Distribution Shrink

• Hot Customer

• Hot Staff

• Hot Stores

• Markdowns

• Natural Losses

• Return Rates

• Shrink

• Vendor Rationalization

Credit services analysis

With the increasing importance of private-label credit business, new opportunities for financing programs, and more credit-based sales, retailers want to track their customers’ credit habits to identify the most profitable customers and to protect themselves from loss through customer default on credit.

• Accounts Payable

• Accounts Receivable

• Cash-to-Cash Cycles

• Chargeback Analysis

• Fraud Outcomes

• Out-of-Pattern

• Payments Outstanding

• Rate Forecasting

• Risk Scoring

• Total Daily Risk

Labour scheduling

To optimize the efficiency of their operations, retailers must monitor staffing needs and employee performance.

• Best / Worst Stores

• Best Employees

• Budget vs. Actual

• Event Shortages

• Forecast Staff

• Missed Work

• Overtime

• Sales per Labour Hour

• Task Breakdown