lary85/Fish-sales-and-profit-analysis-dashboard

This interactive Power BI dashboard provides a comprehensive overview of fish sales and profitability across multiple states in Nigeria. It highlights key business metrics such as total revenue, production cost, profit after VAT, and quantity sold. # Fish-sales-and-profit-analysis-dashboard ### Project Overview This project presents an interactive Power BI dashboard analyzing fish sales performance across multiple states in Nigeria. The report focuses on revenue, production cost, profit after VAT, and quantity sold, providing stakeholders with a clear view of business performance and profitability trends. The dashboard enables users to explore how different fish species and regions contribute to overall profit, while also highlighting key performance indicators and trends over time. ### Objectives - Analyze total revenue, cost of production, and profit after VAT - Evaluate state-level performance and identify top-performing regions - Understand profitability trends over time - Compare performance across different fish species - Enable dynamic filtering for deeper business insights ### Dashboard Preview ### Key Metrics 1) Total Revenue: ₦10.9bn 2) Total Cost of Production: ₦8.3bn 3) Profit After VAT: ₦2.8bn 4) Total Quantity Sold: 10.08M ### Key Features - Profit Analysis by State: Lagos and Rivers emerge as the top-performing states. Lower-performing regions highlight opportunities for improvement - Category Breakdown (Fish Species): Treemap visualization showing contribution of species like: Tilapia, Catfish, Croaker, Mackerel. - Profit Trend Analysis Tracks profit fluctuations across multiple years. Identifies dips and recovery periods in business performance - Geographical Insights Map visualization showing profit distribution across states. Enables quick identification of high and low-performing regions - KPI Tracking - Real-time KPI comparison against set targets. Example: Profit exceeding goal by 20%+. - Interactive Filtering - Filter by: - Year (2019–2023) - Fish Species Enables dynamic exploration of the dataset ### Tools & Technologies - Microsoft Power BI – Data visualization and dashboard creation - DAX (Data Analysis Expressions) – KPI calculations and measures - Power Query – Data transfor …