mayooryea/Kultra-Mega-Stores-KMS-Inventory-Analysis---SQL-Case-Study

🏢 Business Context: Kultra Mega Stores (KMS), a top office supplies retailer in Nigeria, tasked me with analyzing historical order data from its Abuja division to identify insights for improving operations and boosting profitability. # Kultra-Mega-Stores-KMS-Inventory-Analysis---SQL-Case-Study Prepared By: Omoniyi Mayowa Maria (Business Intelligence & Data Analyst) 👋 Introduction Hello! I'm Omoniyi Mayowa, a Data Analyst specializing in transforming raw data into actionable business insights. This repository presents my comprehensive analysis of Kultra Mega Stores' inventory and sales data from 2009-2012, conducted as my **capstone project for the DSA Data Analysis** program. 🏢 Business Context: Kultra Mega Stores (KMS), a top office supplies retailer in Nigeria, tasked me with analyzing historical order data from its Abuja division to identify insights for improving operations and boosting profitability. 🎯 Project Objectives 1. Identify highest-performing products and categories 2. Analyze regional sales performance 3. Evaluate customer segmentation and profitability 4. Optimize shipping methods and costs 5. Provide actionable recommendations to boost revenue 🛠️ Technical Approach Data Preparation • Performed comprehensive data cleaning on the raw CSV file: o Removed duplicate entries o Handled null/missing values o Standardized data formats o Added primary keys for database relationships • Created a supplemental Order_Status table for return analysis Database Design • Designed and implemented a SQL Server database schema • Established proper table relationships • Imported cleaned data into SQL Server Management Studio (SSMS) SQL Analysis • Developed 11 complex SQL queries to: o Calculate aggregate sales metrics o Identify top/bottom performers o Analyze shipping efficiency o Evaluate customer segments o Assess order priority effectiveness ________________________________________ 🔍 **Case Questions & SQL-Based Insights** Q1. Which product category had the highest sales? Product Category Total Sales Technology ₦89,061.05 ________________________________________ Q2. What are the Top 3 and Bottom 3 Regions by Sales? 🔼 Top 3 Regions Region Total Sales West ₦2,308,128.20 Ontario ₦2,006 …