In this project, I built a Crop Analysis Dashboard using Power BI to visualize and analyze agricultural performance data across counties, crop types, and farmers.
🔍 Objectives
The goal was to uncover insights into:
Profitability by farmer
Revenue trends by month
Crop yield distribution
The effect of fertilizer usage and planted area on output
🚀 Key Metrics Tracked:
Total Profit: KES 1.10 Billion
Total Revenue: KES 1.19 Billion
Planted Area: 4,928 farms (≈4.93K acres)
Total Yield: 1.23 Million Kg
📈 Interactive Features
Users can filter by:
County
Month
Fertilizer Used
Crop Type
This allows stakeholders (e.g. agronomists, policymakers, farmer organizations) to dive deep into seasonal trends, crop performance, and farmer productivity.
📊 Visual Insights
Bar Chart: Top farmers by profit
Line Chart: Monthly trends for profit vs revenue
Pie Chart: Crop yield distribution (Rice, Cassava, Coffee, etc.)
🛠 Tools Used:
Power BI
Top comments (0)