To build a real-time dynamic weather dashboard in Power BI for five major Indian cities using live API integration, enabling visualization of key weather metrics and trends in an intuitive, interactive interface.
- Ahmedabad
- New Delhi
- Kolkata
- Bengaluru
- Bhopal
- Power BI
- Weather API (REST-based)
- DAX (Data Analysis Expressions)
- Power Query
- Custom visuals and KPI cards
- Fetched real-time weather data via a public weather API for each target city.
- Cleaned and transformed the raw JSON response using Power Query Editor.
- Converted formats: temperature (to Β°C), pressure (to hPa), and timestamps (to IST).
- Designed a clean, scalable data model with proper relationships.
- Added calculated columns/measures for metrics like:
- Air Quality Index (AQI)
- UV Index
- Sunrise/Sunset in local time
Created a dark-themed, interactive dashboard showing:
- Current weather conditions with city selection
- Forecast temperature trends (line chart)
- AQI and pollutant levels (Oβ, SOβ, CO, PM 2.5, PM 10)
- UV Index, humidity, wind speed
- Sunrise & sunset times
- Daily chance of rain (bar chart)
- Custom icons, tooltips, and dynamic cards
- City selection via dropdown
- Hover tooltips for deeper insights
- Dynamic visuals and metrics update in real-time
- π‘οΈ Temperature (Β°C) with forecast trends
- π¬οΈ Air Quality Index (AQI) with pollutant breakdown
- π§ Humidity, Wind Speed, Pressure
- π Sunrise & Sunset times
- π§οΈ Chance of Rain (bar chart)
- π UV Index, Visibility, Precipitation
- Developed a real-time, visually compelling dashboard integrating live weather data.
- Showcased advanced skills in data extraction, cleaning, modeling, and storytelling with Power BI.
- Highly useful for logistics, outdoor planning, or any weather-sensitive operations.