Sales Data Analysis

**Sales Data Analysis & Business Intelligence Project (Excel / Power Query / Power Pivot / DAX)**

Built a complete data analysis solution for a real-world sales dataset containing 65,000+ transactions. The project focused on transforming raw data into a structured analytical model and extracting actionable business insights.

Key contributions:

* Designed a Star Schema data model (Fact & Dimension tables)

* Performed extensive data cleaning and preprocessing using Power Query

* Built DAX measures including AOV, revenue per customer, and product rankings

* Developed an interactive dashboard using Power BI for business reporting

* Analyzed sales trends, peak hours, geographical performance, and product profitability

Key insights:

* Identified top-performing products by revenue and quantity

* Discovered regional differences in customer value

* Analyzed peak sales hours for optimization opportunities

* Provided strategic recommendations for inventory and marketing

Tools used: Excel, Power Query, Power Pivot, DAX