To analyze retail sales data using Excel and Power BI to identify sales trends, top-performing products, and customer behavior. Tools Used: Microsoft Excel: Data Cleaning, Transformation, and Validation, Power BI: Data Modeling, DAX Calculations, and Dashboard Creation
Data Cleaning & Transformation (Excel), Data Modeling (Power BI)
Dashboard Design Visuals Used: KPI Cards: Total Sales, Quantity, Customers, stores, sales Profit , Line Chart: Sales Trend over Time , Bar Chart: Sales by Category & Sub Category Donut Chart: Sales by Gender, Map: Sales by State , Line Chart: Stores sale by Month, Scatter Chart – Unit Price vs Quantity.