Categories: Power BI
Tags:

Crop Yield Data Analysis Dashboard from JSON API with Authentication

This Power BI dashboard titled “Crop Yield Data Analysis from JSON API with Authentication” showcases agricultural insights derived from a JSON API source. It’s structured to analyze and visualize crop production metrics such as yield, area, and farming practices.

This dashboard has been created by Mr. Ankit Srivastava (Senior Data Analyst)

Here’s a detailed explanation of each section of the dashboard as a Power BI use case:

🔷 Header Section

  • Title: Indicates that the data is being sourced from a JSON API, likely using Power BI’s Web data connector with authentication.
  • Branding/Logo: Includes institutional and agricultural visual elements.

Dataset used in the Production is Given here: https://colorstech.net/practice-datasets/farm-crop-production-data-json-api-for-data-analytics-projects/

🔷 KPI Cards (Top Summary Metrics)

These are created using Card visualizations in Power BI to display high-level insights:

  1. Total Area Cultivated: 2.73K acres
  2. Total Production: 7.76K tons
  3. Yield per Acre: 151.94 tons
  4. Fertilizer Used: 26.84K kg

These are likely calculated using DAX measures, for example:

TotalYield = SUM('Crops'[Yield])
TotalArea = SUM('Crops'[Area])
YieldPerAcre = [TotalYield] / [TotalArea]

🔷 Filters Panel (Slicers on Left)

Power BI Slicers allow interactivity:

  • Region: East, West, North, South
  • Crop Type: Corn, Rice, Soybean, Wheat
  • Season: Monsoon, Summer, Winter
  • Farming Method: Conventional, Organic

Users can select filters to dynamically update all visuals across the report.

🔷 Bar Chart: Yield per Acre by Crop Type

  • Shows comparison of total yield per acre among crops.
  • Corn has the highest yield, followed by Wheat and Soybean.
  • Built using Bar Chart visualization with axis as Crop Type and value as SUM(Yield per Acre).

🔷 Donut Chart: Yield per Acre by Farming Method

  • Displays yield split by:
    • Conventional (62.81%)
    • Organic (37.19%)
  • Built using a Donut Chart, with tooltips showing exact yield values (e.g., 95.43 tons for Conventional).

🔷 Pie Chart: Yield per Acre by Region

  • Breakdown of yield across regions:
    • West: 41.44 tons (27.27%)
    • East: 38.83 tons (25.56%)
    • North: 30.43 tons (20.03%)
    • South: 41.24 tons (27.14%)

Could be built using:

YieldByRegion = SUMMARIZE('Crops', 'Crops'[Region], "Yield", SUM('Crops'[Yield]))

🔷 Sankey Chart: Yield by Season and Crop Type

  • Visualizes interaction of seasonality with crop type yield.
  • Likely built using a custom Sankey Chart visual from Power BI marketplace.
  • Showcases crop yield distribution in:
    • Monsoon
    • Winter
    • Summer

Each crop (color-coded) flows across different seasons, indicating yield contributions.

🔷 Use of API & Authentication

The title indicates:

  • Power BI is connected to a secure JSON API (possibly RESTful) using web connectors with authentication tokens.
  • This setup is useful when working with live agricultural datasets from smart farming apps, government portals, or IoT devices.

📌 Power BI Concepts Used

  • Data Source: JSON API with authentication
  • Visuals: Card, Bar Chart, Donut, Pie, Sankey
  • DAX Measures: Yield calculations
  • Slicers: Filter context for interactive analytics
  • Theme: Agricultural green/brown color scheme and custom images/icons