Amsoliu/Nigeria-Agricultural-Export

Nigeria Agriculture Export Analysis # Nigeria Agricultural Export ### Overview This project provides an in-depth analysis of Nigeria's agricultural export performance using Power BI. It covers the revenue, units sold, costs, and trends across different ports, products, and export countries. The dashboard offers insights into the seasonal and quarterly revenue patterns, top-selling products, cost of goods sold (COGS), and export performance by ports. ### Key Features: - Revenue Analysis: Breakdown of revenue by year, quarter, month, and season to identify trends over time. - Product Sales Analysis: Insights into the top-selling products like sesame, cocoa, and cashew, along with sales volume by export country. - Port Performance: Analysis of export volume and revenue from major ports such as Lagos, Warri, Port Harcourt, and Calabar. - Seasonal Trends: Identification of high and low revenue seasons, with a focus on understanding fluctuations across different time periods. - Cost of Goods Sold (COGS): Evaluation of COGS for different agricultural products to assess profitability. - Export Country Analysis: Performance metrics for countries importing Nigerian agricultural products, including average revenue per unit. ### Tools Used: - Power BI: For data visualization, interactive dashboards, and comprehensive analysis. - Excel: For data cleaning and preparation ### Insights: - The highest annual revenue was achieved in 2021, with November being the peak revenue month across the years. - Lagos Port emerged as the top performer in terms of export volume and revenue. - Cocoa led the list for the highest COGS, indicating a significant cost component in its production. - Seasonal and quarterly analyses showed summer and the fourth quarter as peak revenue periods.