365 Retail Inc - Executive Sales & Customer Analytics

This project involves an executive-level analytics dashboard designed for 365 Retail Inc. to translate 7,394 raw transactional records into strategic growth levers. The analysis focused on addressing revenue concentration, stabilizing operational volatility, and unlocking untapped international potential for a business seeing 532% YoY growth.

Key Achievements

• Analyzed a dataset of over 7,000 transactions to visualize $856K in total revenue
• Identified a profit margin increase from 36% to 42% through monthly trend analysis
• Uncovered that International orders generate 45.17% of revenue despite only being 30.5% of volume
• Discovered a massive untapped market opportunity in the female demographic (currently only 30% of customers)
• Highlighted that the top 5 products generate $500K combined, validating the Pareto Principle

Technologies Used

• Power BI for visualization and executive reporting
• DAX for complex measures (YoY growth, margin calculations)
• Star Schema Data Modeling for efficient query performance
• Statistical Analysis for correlation and variance tracking

Challenges Solved

• Addressed heavy revenue concentration risk where Clothing accounted for 74.4% of sales
• Analyzed operational volatility, specifically shipping costs that fluctuated by 33% monthly
• Solved for lack of visibility into high-value international markets and gender-based acquisition gaps

Results

• Recommended specific strategies to capture a 40% growth opportunity in the female market
• Proposed volume-based carrier contracts to stabilize shipping costs to under $12 per order
• Provided a roadmap to scale international revenue contribution to 60%
• Delivered a strategic verdict to move the company from "growth at all costs" to "efficient scaling"