ChenaiSQL/AnalystLab-Africa-Week2-Superstore-Sales-Analysis

Power BI analysis of Superstore sales and profitability, featuring KPI development, sales trends, customer segments, regional performance and product insights. AnalystLab Africa Week 2 – Superstore Analysis Overview Power BI analysis of 9,994 Superstore transaction-line records from 2014–2017, focusing on sales, profit, products, customers and regional performance. KPIs Total Sales: $2.30M Total Profit: $286.40K Total Orders: 5,009 Average Sales per Transaction Line: $229.86 Profit Margin: 12.47% Key Insights West was the strongest region, with a 14.94% profit margin. Technology achieved the highest category margin at 17.40%. Furniture achieved only a 2.49% margin despite strong sales. Tables generated a loss of approximately $17.73K. Consumer contributed approximately 50.6% of sales. Tools Power BI, Power Query, DAX, Excel and GitHub.