Auto Service Profit & Customer Satisfaction Dashboard | Power BI - $312.91K Analysis

This is a comprehensive Power BI dashboard analyzing an auto repair business with $312.91K Total Revenue, 200 services, and $108.85K Total Profit.The business goal was to understand: Which service type is most profitable? Which city and car model generates highest profit? What is the customer satisfaction rate?The dashboard provides a 360-degree view of revenue, profit margin, service distribution, and sentiment.Tools & Software Used:Advanced Excel, Power Query, PivotTables, VBA for data transformationData Modeling, ETL Processes, Data Cleaning to build relational modelPower BI, DAX, IBM Cognos Analytics, Tableau for visualizationSQL, Python for Data Analysis for data validationKPI Tracking, Data Visualization, AI Data Annotation, AI Training DataExecution Method & Steps:ETL & Cleaning: Imported 200 service records, used Power Query to clean Service_Type names, standardize 6 cities (Casablanca, Agadir, Marrakech, Rabat, Fes, Tangier), and handle null profit values.Data Modeling: Built a data model connecting Services, Cities, Car Models, and Customer Sentiment tables. Created relationships and calculated profit per service.DAX Measures: Created KPIs: Total Revenue = SUM(Revenue), Total Profit = SUM(Profit) = $108.85K, Profit Margin = 34.79%, Total Services = COUNT(Services) = 200.Dashboard Design:Donut Chart: Total Profit by Service_Type - AC Repair $22.88K (20.83%) is top profitBar Chart: Total Revenue by City - Casablanca $72K is highest, Tangier $29K lowestBar Chart: Total Profit by Car_Model - Sedan X $25K most profitable, Hatchback Lite $19K lowestPie Chart: Total Services by Customer_Sentiment - 61% Satisfied (122), 24.5% Neutral (49), 14.5% Unsatisfied (29)Added slicers: City and Service_Type for interactivityValidation: Cross-checked $108.85K profit and 34.79% margin against raw Excel file. No external links, screenshot is 100% my own work.Results & Key Insights:Most Profitable Service: AC Repair $22.88K (20.83% of profit) vs Brake Repair only $11.32K (10.4%) - Recommend to promote AC Repair and train more staff on itBest City: Casablanca generates $72K revenue vs Tangier $29K - Recommend to open second branch in CasablancaBest Car Model: Sedan X generates $25K profit - Focus on spare parts for this modelCustomer Satisfaction Issue: 14.5% Unsatisfied (29 customers) - Need to investigate Brake Repair services which have low profit and likely low satisfactionOverall Margin 34.79% is healthy but can be increased to 40% by cutting low-margin Brake Repair