Use Case: I need to design two dashboards for the upcoming Amazon Prime day where we are going to be selling our products on Amazon, one for the Senior Leadership and second for the retail analyst. List the KPIs that I should consider for the two sets of dashboard so that it is useful to the end users.

Dashboard for Senior Leadership

Objective: Provide a high-level overview of performance, focusing on strategic insights and overall business health.

KPIs:

1. Total Sales Revenue: Total revenue generated during Prime Day.
2. Year-over-Year Growth: Comparison of current sales against previous Prime Day sales.
3. Top-Selling Products: Highlight the best-selling products and their contribution to overall sales.
4. Market Share: Comparison of sales against key competitors.
5. Customer Acquisition: Number of new customers acquired during the event.
6. Average Order Value (AOV): Average amount spent per order.
7. Conversion Rate: Percentage of visitors who made a purchase.
8. Customer Satisfaction: Metrics such as Net Promoter Score (NPS) or customer reviews.
9. Inventory Levels: Stock levels of top-selling and critical products.
10. Return on Advertising Spend (ROAS): Efficiency of advertising efforts.

Dashboard for Retail Analysts

Objective: Provide detailed and actionable insights to optimize performance and identify areas for improvement.

KPIs:

1. Detailed Sales Data: Breakdown of sales by product category, SKU, time of day, etc.
2. Traffic Sources: Analysis of where traffic is coming from (organic, paid, referral, etc.).
3. Cart Abandonment Rate: Percentage of customers who added items to their cart but did not complete the purchase.
4. Customer Demographics: Information on customer segments, including age, gender, location, etc.
5. Discount Effectiveness: Impact of various discounts and promotions on sales.
6. Inventory Turnover: Rate at which inventory is sold and replaced.
7. Refund and Return Rates: Percentage and reasons for product returns.
8. Detailed Conversion Funnel: Steps in the purchase process where customers drop off.
9. Customer Lifetime Value (CLV): Predicted revenue from a customer over their entire relationship with the company.
10. Advertising Performance: Metrics like click-through rate (CTR), cost per click (CPC), and conversion rate for different ad campaigns.

Additional Considerations

• Real-Time Monitoring: Both dashboards should have the capability to provide real-time data updates to track live performance.
• Custom Alerts: Set up alerts for critical KPIs that require immediate attention, such as inventory running low on top-selling items or sudden spikes in cart abandonment rates.
• Visual Representation: Use a mix of charts, graphs, and tables to make the data easily understandable and actionable.

By focusing on these tailored KPIs, you can ensure that both senior leadership and retail analysts have the insights they need to make informed decisions and optimize performance during Amazon Prime Day.