🛒 TATA Online Retail: Strategic Growth Analysis

Analyzing global sales distributions and customer behavior to drive executive decision-making.

📸 Dashboard Preview

🎯 The Business Objective

This project was designed to simulate a brief for the CEO and CMO of TATA Online Retail. The goal was to identify which countries provide the highest revenue potential and which customer segments are driving the most value.

🧠 Strategic Executive Insights

• Geographic Expansion: Identified that while the UK is the primary market, there is significant untapped growth in [Insert Country, e.g., Netherlands/Australia], where the average order value (AOV) is 15% higher.
• Customer Loyalty: Discovered that the Top 10% of customers contribute to nearly 40% of total revenue, highlighting a need for a dedicated VIP retention program.
• Seasonal Demand: Visualized monthly revenue cycles, identifying a recurring peak in Q4 that requires advanced inventory stocking.

🛠️ Technical Implementation

• Data Transformation: Cleaned a massive retail dataset using Power Query to remove negative quantities (returns) and invalid stock codes.
• Metric Design: Developed KPIs for Revenue by Country, Quantity per Transaction, and Monthly Revenue Trends.
• Visual Hierarchy: Designed the dashboard for "Glanceability"—ensuring the most important numbers (Total Revenue and Units Sold) are at the very top.

🚀 How to Use This Project

1. CEO View: Focus on the "Revenue by Country" map to see global performance.
2. Operations View: Use the "Monthly Trend" chart to plan for seasonal warehouse staffing.
3. Data Structure: Refer to data_dictionary.md for details on the transaction records.