The Tableau Accelerator for Sales and Margin + Target jumpstarts your data-driven insights by embedding Sales analytics and providing expert-level analytics for:
- RFM Analysis (customer segmentation): RFM stands for recency, frequency, and monetary value, each corresponding to some key customer trait.
- Client Lifetime Value (prediction of the total sales (or margin) attributed to the entire future relationship with a client) and client churn rate (percentage of clients that stopped buying product/services, compared to previous client base)
- PVM/Price-Volume/Mix Analysis /Sales Bridge: decomposes how volume or pricing changes of our product assortment contributed to the difference in performance between the actual and reference values
Expert analytical users can use this Accelerator to easily drill from top-level sales results down to individual customer performance to gain a holistic view of sales.
Answer key business questions
- What are our sales results? What is our profitability?
- Which business lines generated the most sales?
- Who are our top customers? What is our level of profitability with them?
- How many active customers do we have? What about our ability to acquire new customers?
- How is our customer base segmented? What are the recommended marketing actions to address each customer segment?
- What is our Client Lifetime Value?
- What is our Client Churn Rate?
Monitor and improve KPIs
- Total Sales
- Total Sales Margin
- Total Sales Quantity
- Active Customers #
- New Customers #
- Sales Margin %
- Total Sales Costs
- Sales Costs %
- Average Selling Price
- Sales per Customer
- Date (date)
- Customer (string)
- Product (string)
- Business Line (string)
- Sales Amount (numeric)
- Sales Amount Target (numeric)
- Sales Margin (numeric)
- Sales Margin Target (numeric)
- Sales Quantity (numeric)