Odicoson/Tunia-Technologies-Sales-Performance-Dashboard

Excel Sales & Performance Dashboard for Tunia Technologies – Pan-African E-Commerce # Tunia Technologies – Sales & Performance Dashboard ## Overview Tunia Technologies is a Pan-African, tech-driven company founded in 2019, operating across three core verticals: **Marketplace**, **Logistics**, and **Payment Services**. This project involved designing and building a fully interactive sales performance dashboard using historical transactional data, enabling stakeholders to make faster, data-informed decisions across regions, product categories, and customer segments. --- ## Tools & Technologies - **Microsoft Excel** – Power Query, Pivot Tables, Pivot Charts, Slicers, Conditional Formatting --- ## Dataset Fields | Field | Description | |---|---| | Order Date | Date the customer placed the order | | Ship Date | Date the product was shipped | | Ship Mode | Shipping method selected by the customer | | Customer Name | Name of the customer | | Segment | Customer-type classification (Consumer, Corporate, Home Office) | | Region | Geographical region (East, West, North, South) | | Category | Broad product classification | | Sub-Category | Specific product sub-classification | | Product Name | Name of the purchased product | | Sales | Revenue from the transaction | | Profit | Net gain from the transaction | | Quantity | Number of units sold | | Discount | Discount applied to the purchase | --- ## Dashboard Features ### KPI Summary Cards Real-time aggregate metrics displayed at the top of the dashboard: - **9,994** – Total Sales Records - **$2.3M** – Total Revenue - **$286,397** – Total Profit - **$1,561** – Total Discounts Applied - **37,873** – Total Units Sold ### Sales by Category (Donut Chart) - Office Supplies: **37%** - Technology: **32%** - Furniture: **31%** ### Profit by Segment (Donut Chart) - Consumer: **47%** - Corporate: **32%** - Home Office: **21%** ### Monthly Sales Trend (Line Chart) Tracks revenue month-over-month across the full year. A clear Q4 spike is visible, with November peaking at **352K** — a strong indicator for sea …