GabbyTech17/KMS-Sales-Analysis

Kultra Mega Stores (KMS), headquartered in Lagos, specializes in office supplies and furniture. Its customer base includes individual consumers, small businesses (retail), and large corporate clients (wholesale) across Lagos, Nigeria. I'm requested to analyze the data and present my key insights and findings. # KMS-Sales-Analysis ## Project Overview Kultra Mega Stores (KMS), headquartered in Lagos, specializes in office supplies and furniture. Its customer base includes individual consumers, small businesses (retail), and large corporate clients (wholesale) across Lagos, Nigeria. I'm requested to analyze the data and present my key insights and findings. ## Data Source CSV file shared by Digital Skillup Africa (DSA) ## Tools Used Microsoft Excel - To Check Data accuracy and cleaning SQL - For Analysis and result finding ## Exploratory Data Analysis EDA involved the exploring of the Data to answer some questions about the data such as; ### Case Scenario I 1. Which product category had the highest sales? 2. What are the top 3 and bottom 3 regions in terms of sales? 3. What are the total sales of appliances in Ontario? 4. Advice the management of KMS on what to do to increase the revenue from the bottom 10 customers 5. KMS incurred the ost shipping cost using which shipping mode? ### Case Scenario II 6. Who are the most valuable customers, and what product or services do they typically purchase? 7. Which small business customer has the highest sales? 8. Which Corporate customer placed the most number of orders in 2009 - 2012? 9. Which consumer customer was the most profitable one? 10. Which customer returned items, and what segment do they belong to? 11. If the delivery truck is the most economical but the slowest shipping method and Express Air is the fastest but the most expensive one, do you think the company appropriately spent shipping cost based on the order priority? Explain your answer Data Analysis This is where we include some basic lines of code or queries or even some of the DAX expressions used during your analysis '''SQL create database KMS_db SELECT * FROM KMS_db.DBO.[KMS Sql Case Study] ----WHICH PRODUCT CATEGORY HAD THE HIGHEST SALES?--- SELECT TOP 1 PRODUCT_CATEGORY, SUM(SALES) AS TOTAL_SALES FROM KMS_db.DBO.[KMS Sql Case Study] GROUP BY Pr …