TolulopeFasola/SQL-Nigeria-Agricultural-Export-Products

# Nigeria-Agricultural-Exports ## Project Overview Nigeria Agricultural Exports (2021-2023) play a significant role in the country's economy contributing to foreign exchange earnings and providing livelihood for people. This analysis aims to point out significant contributions from agricultural products to the economy. For this project, I harnessed the power of data modelling and visualization to create interactive tableau dashboard. Click here to view dashboard. This nalysis willtransform data into actionable insights. ## Data Source The dataset used for this project was shared by an analyst on X. The dataset provides a comprehensive view of sales performance, cost analysis and geographical distribution of Nigeria's agricultural exports. ## Data Source The dataset used for this analysis "nigeria_agricultural_exports.csv"is csv file. The file contains information about export products, countries, company and other information on Nigeria agricultural export. ## Tools & Skills - Excel : Data Cleaning - SQL : Analysis - Tableau : Data Visualization ## Visualization and Reports - Key metrics card : I employed these cards to highlight important metrics such as revenue, profit, total units, total products and total cost. - Map : Implemented the map to give information on average revenue by each country. - Horizontal bar chart : created the chart to give narratives on top 5 products generating the highest revenue. - Table : Employed this table to highlight export countries by product sales. - Bubble chart : This chart visualizes information on destination by there export values. - Line chart : Crated this chart to show trend in revenue and profit margine by year and month. - Note : A note is also added to this dashboard to give insights on what the analysis entails. ## Insights - ### Sales Performance Analysis #### 1. Top selling products The dataset reveals that cocoa, sesame, rubber, cashew are among the top selling products. However, cocoa has the highest …