Abdussalam-Oluwaseun/Nigeria-Agricultural-Export

This project examines the sales performance, cost analysis, geographic distribution, and performance comparison of Nigeria's agricultural exports # Nigeria-Agricultural-Export-Analysis ## Table of Content * Problem statement * Data Source * Tools * Data Cleaning and Preparation * Exploratory Data Analysis * Modelling * Data Analysis * Visualization * Analysis Report and insight ## Problem Statement This project examines the sales performance, cost analysis, geographic distribution, and performance comparison of Nigeria's agricultural exports ## Data Source the dataset was shared to me by Favour Ewoh as a test data dataset ## Tools * Execel * PowerBi ## Data Cleaning and Preparation Completed the Data cleaning and transformation in excel by removing duplicates and inconsistent ## Exploratory Data Analysis * What are the top-selling products? * Which company has the highest sales revenue? * How do sales vary across different export countries? You should look at * Which destination ports receive the highest volume of exports? * What are the transportation modes commonly used for export? ## Modelling After the dataset was cleaned and transformed, it was loaded into Microsoft Power BI Desktop for modeling. ## Data Analysis Measures created for analysis ``` DAX 2023 COGS = CALCULATE( '_measures'[Sum of COGS], 'Import Country'[start of year] = 2023) 2023 profit = CALCULATE( '_measures'[sum of profit],'Import Country'[start of year] = 2023) Revenue by year 2023 = CALCULATE([Total revenue], 'Import Country'[start of year] = 2023) Sum of COGS = SUM('Product'[COGS]) sum of profit = SUM('Product'[Profit per unit] ) Sum of unit = SUM('Product'[Units Sold] ) Total revenue = SUM('Product'[Export Value]) unit sold 2023 = CALCULATE( '_measures'[Sum of unit], 'Import Country'[start of year] = 2023) ``` ## Visualization visualization of data potraying cost analysis, different export company and state performance and timeline analysis Dashboard Report ## Analysis Report and insight Port Analysis * Top Port: Lagos leads in sales volume (of 28,474 units), revenue (with 54.29 % of total revenue), and …