Blackboyy01/Tunia-Technologies

Tunia Technologies is a Pan-African tech-driven company founded in 2019, operating across three core verticals: Marketplace, Logistics, and Payment Services. The company has grown steadily across multiple regions in Africa and is now seeking deeper insight into its operational performance using historical sales data. # Tunia Technologies – Sales & Performance Dashboard > End-to-end data pipeline, multi-dimensional analysis, and interactive dashboard built entirely in Microsoft Excel. Tunia Technologies is a Pan-African tech-driven company founded in 2019, operating across three core verticals: Marketplace, Logistics, and Payment Services. The company has grown steadily across multiple regions in Africa and is now seeking deeper insight into its operational performance using historical sales data. **A comprehensive data analytics project transforming 2022 transactional data into actionable business intelligence.** --- ## Table of Contents - Executive Summary - Dashboard - Project Overview - Problem Statement - Project Objectives - Process Flow & Methodology - Key Insights - Business Impact - Recommendations --- ## Executive Summary Click here to view the Executive Summary PDF Tunia Technologies generated $2.30M in revenue and $286.4K in profit, resulting in a ~12.5% margin. While revenue performance is strong, profitability is constrained by product losses and inconsistent discounting. Sales improved significantly during the year, rising from $59.8K in February to $352.5K in November (~489% growth), with December maintaining strong performance at $323.5K. However, this growth is heavily concentrated in the final months. The Technology category contributes $836.2K (~36%) of total revenue, making it the primary growth driver. While this category is a strong growth driver with high margins, the level of dependence introduces risk if performance weakens. Profit is led by the Consumer segment at $134.1K, outperforming Corporate ($91.98K) and Home Office ($60.30K) by ~46% and ~122% respectively, indicating stronger pricing and demand in the consumer market. At the same time, a group of underperforming products, including printers and conference tables, generates over $17+K in losses, directly impacting overall profitability. At the same time, inconsistent discount …