Foodgrain Forecast

15 years of national grain data, forecast and audited.

• → 4-step SQL pipeline: import, deduplication, indexing, multi-level aggregation rollups
• → Prophet models for 30/90-day forward forecasting with ±8–12% uncertainty bands
• → Z-score and rolling-window anomaly detection — Punjab, Jharkhand, Chhattisgarh flagged most
• → 5-page Power BI dashboard, 30+ DAX measures, state-level choropleth