AGRICULTURAL DATA INSIGHTS WITH SQL
Updated: Nov 26, 2024
Link to project:https://github.com/Chauloroches/Agricultural_Data_Insights_SQL/blob/main/Agricultural_data_insights.sql
In this project, I have 3 files for the task: production_data,market_prices,weather_condition, and regions samples of the files shown below.
production_data:

market_prices:

weather_condition:

regions:

I normalized Data by Ensuring foreign keys are consistent across tables. For example, the Region in Production_Data should match the Region field in Regions.

After making sure the data is clean and accurate then make my findings as follows:
Top 5 Production by Region:

Revenue by Region and Crop Type:

Market Price Fluctuation:

Impact of Rainfall on Production:
I'm going to calculate the high rainfall threshold based on average and standard deviation.
Select months with average rainfall above the threshold.
Join high rainfall months with production data to analyze impact on crop production.

Having done this analysis I uncover trends that led to actionable recommendations for agricultural planning and strategy.
Commentaires