Olumide2025/DSA-PROJECT-KMS

This is a SQL-Based analysis project for Kultra Mega Stores on product, sales, customer, order and delivery. It is designed by me during my learning journey at the Digital Skill Up Africa at the Incubator Hub. This project uses SQL languages to create database, import the CSV file for analysis to create insight on product and customer trend. # DSA-PROJECT-KMS # Project Topic: Kultra Mega Stores Inventory. ## Project Overview Kultra Mega Stores (KMS), headquartered in Lagos, specialises in office supplies and furniture. Its customer base includes individual consumers, small businesses (retail), and large corporate clients (wholesale) across Lagos, Nigeria. You have been engaged as a Business Intelligence Analyst to support the Abuja division of KMS. The Business Manager has shared an Excel file containing order data from 2009 to 2012 and has requested that you analyze the data and present your key insights and findings. This project was completed as part of the Digital SkillUp Africa Data Analytics training. The analysis focuses on sales data from Kultra Mega Stores (KMS) — a retail and corporate office supply chain — with operations across various regions from 2009 to 2012. KMS management tasked us with deriving actionable insights to improve business performance using structured data analysis and SQL queries. The goal was to understand: How different regions, customer segments, and products performed Where the company is losing money through shipping or underperforming customers What decisions can improve profitability and customer retention As the Data Analyst, I led the end-to-end process: Data ingestion using SQL Server Management Studio Data cleaning, transformation, and type optimization Formulation of real business questions Writing SQL queries to extract insights Summarizing recommendations to support strategic decision-making ### Case Scenario I - Which product category had the highest sales? - What are the Top 3 and Bottom 3 regions in terms of sales? - What were the total sales of appliances in Ontario? - Advise the management of KMS on what to do to increase the revenue from the bottom 10 customers - KMS incurred the most shipping cost using which shipping method? ### Case Scenario II - Who are the most valuable customers, and what products or services do they typically purchase? - …