An interactive Weather Dashboard built in Power BI using WeatherAPI, featuring AQI insights, temperature trends, and dynamic visualizations.
This project demonstrates how to build a Weather Dashboard in Power BI using data from a weather API.
The dashboard integrates live or historical weather data and transforms it into meaningful insights for end users.
It provides a comprehensive view of environmental conditions, enabling better understanding of patterns and trends.
- 🌍 API Integration → Weather data sourced from an external API and loaded into Power BI.
- 🛠 Data Modeling → Power Query used to clean and transform JSON/CSV responses into structured tables.
- 📊 Dynamic Visuals → Charts, cards, and conditional formatting for temperature, humidity, wind speed, and AQI.
- 🗺 Location Filtering → Slicers to explore weather metrics by city, state, or region.
- 🎨 User-Friendly Design → Clear visuals with interactive elements for quick insights.
- 🌡 Temperature Trends (daily/hourly analysis).
- 💧 Humidity & Wind Speed Indicators.
- 🟢🔴 Air Quality Index (AQI) with color-coded health guidance.
- 📈 Comparisons Across Locations using bar/line visuals.
- Clone or download this repository.
- Open the
Weather DASHBOARD PROJECT.pbixfile in Power BI Desktop. - Replace the sample API key or dataset with your own WeatherAPI key.
- Refresh the data and start exploring the dashboard.
- How to connect Power BI to an API.
- Transforming JSON/CSV weather data into a clean model.
- Designing interactive dashboards with KPIs and slicers.
- Applying conditional formatting for better storytelling.
- Power BI Desktop (Data Modeling + Visualization)
- DAX Measures (for AQI color coding & health suggestions)
- WeatherAPI (for weather data source)
✨ Built by Atharva Joshi