This project involved analyzing retail sales data to understand business performance, profitability, and the effect of discounting across categories and regions. The goal was to transform raw transactional data into meaningful insights through interactive dashboards and data storytelling

Business Problem

The business needed to understand:

• How sales and profits evolved over time.
• Which categories and regions drove performance.
• Whether discounting impacted profitability.
• Which customers contributed most to revenue

Dataset

Source: Tableau Sample Superstore Dataset

Tools Used:

• Microsoft Excel
• Power BI
• DAX

Data Preparation

Data Cleaning

• Combined related tables into a single order table.
• Removed unnecessary columns.
• Handled missing values and data types.
• Created additional calculated columns.