Maureenbuchi/Gadget-accessories-sales-dashboard

An excel-based data analysis and dashboard project providing sales insight for gadget and accessories stores across different regions in Nigeria # Gadget and Accessories Sales Dashboard ## Table Of Contents - Dataset Overview - Dashboard Insights - Visual Insights - Tools Used - Key Learning Points This project analyzes sales data for gadget and accessories stores across multiple regions in Nigeria. It explores total revenue, unit sold, product performance, and sales patterns by day category. ### Dataset Overview The dataset contains the following columns: - Region – Store region (e.g., North Central, South West) - Market – State location - Store – Specific store branch - Trade Date – Date of transaction - Fiscal Period – Quarter of the year - Product – Product type (e.g., Blender, Headphones) - Line of Business – Category (Accessories / Electrical Gadgets) - Day Category – Day type (Workday, Public Holiday, etc.) - Revenue – Total revenue generated - Unit Sold – Quantity sold - ### 📈 Dashboard Insights From the dashboard: - Total Revenue: $1,053,692,115.20 - Total Units Sold: 255,161 - Top Product by Revenue: Headphones ($268,273,789.79) - Top Store by Units Sold: Keffi (32,860 units) ### Visual Insights: - Revenue by Product – Headphones lead as the most profitable product. - Revenue by Market – Strong performance across FCT, Lagos, Nasarawa, and Ogun. -Revenue by Day Category – Higher revenue recorded on Public Holidays and Workdays. ### Tools Used - Microsoft Excel - Data Cleaning - KPI Calculation - Pivot Tables -Dashboard Design ### Key Learning Points - Data structuring and formatting in Excel - Dashboard creation using Pivot Charts - KPI interpretation and storytelling with data