365 Cosmetics Inc - Sales & Profitability Dashboard

This project involves an executive-level Power BI analytics solution designed for 365 Cosmetics Inc. to address a critical 'profitless growth' scenario. While the company achieved a 23.82% surge in sales, total profit declined by 12.16%. The dashboard translates 25,000+ transactional records into actionable strategies to plug profit leaks and optimize pricing.

Key Achievements

• Analyzed 25K+ transactions to diagnose the root cause of a 12.16% profit decline
• Identified a critical discount threshold, revealing that products discounted above 31% consistently generated losses
• Uncovered that while the US holds 36% market share, emerging markets like China and India deliver significantly higher margins (~30%)
• Segmented customers to find that the 'Self-Employed' demographic generates the highest margins despite lower volume
• Integrated SVG sparklines and dynamic measures using DAX for advanced trend analysis

Technologies Used

• Power BI for advanced visualization and reporting
• DAX for Time Intelligence and dynamic measures
• Power Query for data transformation and cleaning
• Star Schema Architecture for data modeling

Challenges Solved

• Solved the 'Profitless Growth' paradox where acquisition costs outpaced revenue
• Detected invisible profit leakage caused by aggressive, unmonitored discounting
• Resolved regional opacity by distinguishing between high-volume/low-margin and low-volume/high-margin markets

Results

• Recommended capping discounts at 30% and introducing approval workflows to recover ~$150K in annual profit
• Proposed a market expansion strategy shifting focus to high-margin regions (China & India)
• Developed a category rationalization plan to eliminate loss-making inventory in 'Home & Accessories'
• Provided a roadmap to restore profitability by shifting from a volume-first to a margin-first strategy