top of page

AGRICULTURAL DATA INSIGHTS WITH SQL

Roches Chaulo

Updated: Nov 26, 2024

I extracted and analyzed crop production and sales data using 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


DON'T MISS THE FUN.

FOLLOW ME ELSEWHERE

  • Facebook
  • Instagram

SHOP MY LOOK

POST ARCHIVE

bottom of page