busayo-omoniyi/retail-sales-performance-analysis

This repository is a data analytics case study, not a piece of software you install or run. It walks through analyzing a retail sales dataset called Global Superstore, which contains transaction records covering sales, profit, discounts, customers, products, regions, and order dates. The goal was to answer real business questions a company's management might ask: how sales are trending over time, which regions and customer groups bring in the most revenue, which product categories are most profitable, how discounts affect profit, who the most valuable customers are, and which products need attention. The work was done using SQL for the data analysis itself and Microsoft Power BI for building interactive dashboards, with Microsoft Excel also listed as a tool. The process followed a clear path: starting from the raw dataset, cleaning the data, running SQL queries to analyze it, building dashboards in Power BI, then turning the findings into written insights and recommendations. Four dashboard pages are described: an executive overview with key metrics and trends, a profitability dashboard that breaks down profit by category and region and flags products losing money, a customer dashboard highlighting top spenders and comparing customer segments, and a time analysis dashboard showing monthly and quarterly sales patterns. The README lists several findings, including that sales grew steadily from 2011 to 2014, the Central region generated the most revenue, the Consumer segment drove the most sales, Technology was the most profitable category, heavier discounts tended to reduce profitability, a small number of customers accounted for a large share of revenue, and some high-value products consistently lost money. Based on these findings, the author suggests preparing for peak sales periods in advance, adjusting discount policies to protect margins, reviewing underperforming markets and products, and focusing on retaining high-value customers. The repository itself contains a written business case study document and the SQL query files used in the analysis, useful as a portfolio example for anyone learning data analytics.