This project analyzes sales, profit, and discount data from a US-based retail company (SuperStore) to uncover drivers of profitability and loss across regions, product categories, and customer segments. The goal is to deliver actionable insights and interactive dashboards that support data-driven decision-making.
Retail businesses often struggle to identify which products, regions, or customer segments drive profit and which contribute to losses. By leveraging data analytics and visualization, this project aims to help SuperStore optimize pricing, discounting, and product strategies to maximize profitability and operational efficiency.
- Interactive Power BI dashboards for executive and deep-dive analysis
- Automated data cleaning and transformation scripts
- DAX measures and calculated columns for key KPIs
- Visualizations: profit by region/category, discount impact, top/bottom products, loss-making orders, and more
- Comprehensive documentation and business case
- Fields: Order ID, Order Date, Ship Date, Ship Mode, Customer ID, Customer Name, Segment, Country, City, State, Postal Code, Region, Product ID, Category, Sub-Category, Product Name, Sales, Quantity, Discount, Profit
- Period: Multi-year historical data
- Size: 9,994 rows, 21 columns
- Clone this repository or download the project files.
- Ensure you have Power BI Desktop installed
View comprehensive Report here
If you found this project helpful or want to collaborate, feel free to connect: Connect with me