Built with datascienceportfol.io

NIGERIAN AGRIC EXPORT ANALYSIS

Project photo

Project links

Skills

About this project

https://drive.google.com/folderview?id=1lq_I111CMY9TO3HksPget11cEDNUJ1vBIntroduction: This is a detailed analysis on the Nigerian Agric Export report  ranging over 4 years from 2014 - 2018. After getting the dataset and cleaning and formatting it using MS Excel, I proceeded to import it into the database.

I then queried the tables using functions and aggregators in order to produce insights to use for the Visualization process. The results of the query was then saved and imported into PowerBi and visualized.

Key Metrics:

Export Trend: This was represented by a line Chart, the case function in SQL was used in order to group the dates into their individual years. The insight works to show the sales pattern for the 4 years that the dataset spans. The data shows that the highest sale was on 2020 and the lowest sales occured during 2022. This could be due to the fact that 2022, the world was just recovering from the covid pandemic and the economies of the world was still recovering.

Most sold products: This was represented by a column chart. It was queried out on SQL using the group by function. The insights shows the agric product with the most sold quantity. That showed that sesame was the product that had the most sales.

Top country by Revenue: this was represented using a filled map. The information was filtered out using the where syntax on SQL and It showed that the country that Nigeria most exported to was Italy.

Top 8 company by Revenue: This insight sought to show the top 8 companies that made the most money. The sum aggregator and group by function was used on SQL to filter out for the data. The data showed that Agro Export Nigeria had the highest sales with a Revenue of 1.87Bn.

Product with best profit margin This sought to show the product that had the best product margin. And the result showed that the product with best sales was not necessarily the product that made the best profit. The data showed that the Agric product with the best product margin was Cassava, and I filtered out for it using the average and group by functions in PostgreSQL.

Top 8 products with best sales per Revenue: This was represented by a column chart. It represents the agric product that made the most money in terms of sales. The sum aggregator on SQL was used to filter out for it, and the data showed that the product that had the highest revenue was Cocoa

Link to the SQL Project: https://drive.google.com/folderview?id=1lq_I111CMY9TO3HksPget11cEDNUJ1vB