Hola-yinka/DSA-PROJECT--KULTRA-MEGA-STORES-INVENTORY

This is a project given by DSA to analyze a transactional dataset from Kultra Mega Stores, a company that sells office supplies and furniture across Lagos, Nigeria. The focus is on their Abuja division, with data covering orders from 2009 to 2012. # DSA-PROJECT--KULTRA-MEGA-STORES-INVENTORY This is a project given by DSA to analyze a transactional dataset from Kultra Mega Stores, a company that sells office supplies and furniture across Lagos, Nigeria. The focus is on their Abuja division, with data covering orders from 2009 to 2012. ## Company Overview Kultra Mega Stores (KMS), headquartered in Lagos, Nigeria, specializes in the sale of office supplies and furniture. Its diverse customer base includes individual consumers, small retail businesses, and large corporate clients. You have been engaged as a **Business Intelligence Analyst** to support the operations of the **Abuja division**. The Business Manager provided an Excel file containing historical order data spanning from **2009 to 2012**, and requested that you analyze the dataset and present key insights and actionable recommendations to support strategic decision-making. ## Data Source The data was downloaded from **Canvas**, as provided by **DSA** (DigitalSkillUpAfrica) for the Business Intelligence project. ## Dataset Description The dataset contains historical order records from **Kultra Mega Stores – Abuja division** between **2009 and 2012**. Each row represents a single order transaction with various attributes describing the customer, product, sales details, and shipping. Below are the key columns included in the dataset: - **Row_ID** – Unique identifier for each transaction row - **Order_ID** – Unique identifier for each order - **Order_Date** – The date the order was placed - **Ship_Date** – The date the order was shipped - **Customer_Name** – Name of the customer who placed the order - **Segment** – Customer segment (Consumer, Small Business, Corporate) - **Province** – Specific state within the region (e.g., Abuja, Kano) - **Region** – Broader region classification (e.g., North, South) - **Product_Category** – High-level category of the product (e.g., Furniture, Office Supplies) - **Product_Sub_Category** – Subdivision of the pr …