Adeola-insights/-Electronics-Product-Sales-Dashboard

A comprehensive Power BI sales analytics dashboard tracking revenue, profit, and performance across products, cities, regions, sales reps, and channels for an electronics retail business in Nigeria. # Electronics-Product-Sales-Dashboard A comprehensive Power BI sales analytics dashboard tracking revenue, profit, and performance across products, cities, regions, sales reps, and channels for an electronics retail business in Nigeria. # Project Overview This project is a Power BI business intelligence dashboard built to analyze the sales performance of an electronics retail company operating across multiple Nigerian cities. It provides real-time visibility into key business metrics, enabling data-driven decision-making at both the strategic and operational level. The dashboard was analyzed using a structured filter-based approach — drilling into each sales representative, region, product category, city, channel, and time period to extract actionable insights. ### Tools & Technologies |Tools | Pourpose| |------|---------| | Microsoft Power BI | Dashboard creation and data visualization | | DAX | Calculated measures and KPIs | | Power Query | Data transformation and modelling | ### Key Metrics Tracked | Metric | Overall Value| |--------|--------------| |: Total Revenue | ₦2 Billion | | : Total Sales | 2,100 units| | : Total Profit | ₦467 Million | | : Profit Margin | ~23% | ### Dashboard Sections 1. KPI Cards Profit — Total profit generated across all reps, products, and cities Revenue — Gross revenue before deductions Total Sales — Count of all transactions 2. Profit By Category Horizontal bar chart showing profit contribution from: Electronics (highest — ₦0.27bn) Home Appliances (₦0.11bn) Furniture (₦0.09bn) 3. Revenue By City Column chart comparing revenue across: Abuja, Port Harcourt, Lagos, Kano 4. Revenue By Channel Donut chart showing split between: Store (offline) — ~53% Online — ~47% 5. Revenue By Month Line chart tracking January through May revenue trend — reveals a significant May revenue drop requiring investigation. 6. Sales By Region Bar chart showing sales volume across East, West, and North regions. # Key Insights ### Overall Per …