A Data-Driven Analysis of Agricultural Subsidy Distribution in Kansas, Nebraska, and Oklahoma
Overview
This project explores the distribution of government agricultural subsidies in Kansas, Nebraska, and Oklahoma, focusing on how financial aid supports livestock farming. By leveraging Tableau visualizations, I analyzed key patterns in subsidy allocation, emergency relief efficiency, and disparities between small and large farms. The insights help farmers understand how to strategically position themselves to maximize government support while uncovering inefficiencies in the subsidy system.
View the Interactive Dashboard on Tableau Public:
🔗
https://public.tableau.com/views/AnalyzingAgriculturalSubsidyDistributionEfficiencyintheMidwest/LivestockSubsidies?:language=en-US&:sid=&:redirect=auth&:display_count=n&:origin=viz_share_link
Key Insights & Impact
- Disparity in Subsidy Distribution: Large corporate farms receive the bulk of subsidies, while smaller, family-owned farms struggle to secure sufficient financial support.
- Emergency Relief Efficiency: There is a noticeable gap between the amount requested and the amount disbursed, especially in times of crisis, highlighting inefficiencies in emergency funding.
- County-Level Strategy: Some counties consistently receive higher disbursements. Smaller farms can improve their funding opportunities by strategically selecting locations with strong historical payouts.
- Program-Specific Benefits: The Livestock Forage Program and Emergency Relief Programs provide significant aid, making them critical for livestock farmers navigating financial uncertainties.
Technical Execution
This project was built using Tableau Public, utilizing:
- Interactive Maps & Drill-Down Charts: To explore subsidies by state, county, and individual farm recipients.
- Calculated Fields & Parameters: To filter subsidy programs dynamically and compare trends.
- Scatter Plot Analysis (Disbursement Efficiency): To assess how closely subsidy disbursements matched the requested amounts.
- Time Series Trends & Year-over-Year Growth: To visualize historical patterns and shifts in government funding.
The Narrative: A Data-Driven Story
The analysis follows a compelling storytelling framework, guiding the audience through subsidy trends, disparities, and opportunities for smaller farms:
- Who Benefits the Most?
- Large corporate farms dominate funding, but emergency programs provide hidden opportunities for smaller farms.