E-Commerce Sales Performance Dashboard | Power BI - $98.33K Revenue Analysis

This project is an interactive Power BI dashboard built to analyze $98.33K in e-commerce sales performance over 3 months (June - August).The objective was to answer 3 critical business questions: Which product category generates the most revenue? Which city is the most profitable? Is our advertising spend profitable?The dashboard analyzes data from 6 product categories and 5 cities, tracking 4 main KPIs: Total Revenue, Total Profit, Profit Margin, and ROAS.Tools & Software Used:Advanced Excel, Power Query, PivotTables for data preparationData Modeling, ETL Processes, Data Cleaning for building a clean relational modelPower BI, DAX, IBM Cognos Analytics, Tableau for visualizationSQL, Python for Data Analysis for validationKPI Tracking, Data Visualization, AI Data AnnotationExecution Method & Steps:Data Cleaning (ETL): Imported raw sales CSV, used Power Query to remove duplicates, handle null values, and standardize city names and product categories.Data Modeling: Created a star schema model, establishing relationships between Sales, Products, and Cities tables. Created calculated columns for Profit.DAX Measures: Wrote custom DAX measures: Total Revenue = SUM(Sales[Revenue]), Total Profit = SUM(Sales[Profit]), Profit Margin % = DIVIDE([Total Profit],[Total Revenue]), ROAS = [Total Revenue]/[Ad Spend].Dashboard Design: Designed 4 visuals - KPI Cards for main metrics ($38.879K Profit, 39.54% Margin, $6.86 ROAS), Bar Chart for Profit by City (Casablanca $8.5K highest), Bar Chart for Revenue by Category (Electronics $54K = 55%), Line Chart for Revenue by Month showing growth from $31.4K to $34.4K.Quality Check: Validated totals against raw data to ensure 100% accuracy. No external links, all visuals are from my own work.Results & Insights:Revenue Growth: +9.5% growth from June ($31.4K) to August ($34.4K)Top Category: Electronics dominates with $54K (55% of revenue) - Recommendation: Increase inventory and ad budget by 30%Low Performer: Accessories only $3K - Recommendation: Stop advertisingTop City: Casablanca generated highest profit ($8.5K), followed by Marrakech ($8.3K)