The Weather Analytics Dashboard is a fully responsive Power BI project that provides real-time weather insights for any city using live weather APIs. The dashboard dynamically updates current conditions, historical trends, and forecast information whenever the user selects a different city.
Unlike dashboards built on static datasets, this project fetches live weather information from an online API, transforms the data using Power Query, and presents it through an interactive and responsive Power BI dashboard.
Weather data is critical for industries such as:
- Aviation
- Logistics
- Tourism
- Agriculture
- Event Management
- Smart Cities
Most weather applications provide raw information but lack analytical dashboards that enable quick decision-making.
This project aims to solve that problem by creating a centralized analytics dashboard that displays:
- Current Weather Conditions
- Weekly Forecast
- Air Quality Metrics
- Sunrise & Sunset Timings
- Rain Probability
- Weather Trends
Users can instantly switch between cities and receive updated visualizations without modifying the report.
Data Source
- Live Weather API
- Air Quality API
The dashboard fetches:
- Current Weather
- Forecast Weather
- Air Quality Data
- Sunrise & Sunset Information
- Atmospheric Conditions
Since the project uses APIs, no static dataset is stored inside the repository.
| Tool | Purpose |
|---|---|
| Power BI Desktop | Dashboard Development |
| Power Query | API Connection & Data Transformation |
| DAX | Measures & Calculations |
| REST API | Live Weather Data |
| JSON | API Response Format |
The API responses are received in JSON format and transformed using Power Query.
The following transformations were performed:
- Flattened nested JSON objects
- Removed unnecessary fields
- Converted timestamps into readable date/time formats
- Standardized temperature units (°C)
- Renamed columns
- Changed data types
- Created calculated columns
- Handled missing values
- Prepared separate tables for:
- Current Weather
- Forecast
- Air Quality
- Additional Weather Metrics
The dashboard is built using multiple transformed tables obtained from the API.
Weather API
│
▼
Power Query
│
┌───────────────┐
│ Current Data │
│ Forecast Data │
│ AQI Data │
│ City Details │
└───────────────┘
│
▼
Power BI Data Model
│
▼
Interactive Dashboard
- 🌍 Dynamic City Selection
- 📅 7-Day Forecast
- 📈 Temperature Trend Analysis
- 🌅 Sunrise & Sunset
- 🌧️ Rain Probability
- 🌫️ Air Quality Metrics
- 🌡️ Weather Indicators
- 📱 Fully Responsive Layout
- ⚡ Live API Integration
The dashboard displays the following Key Performance Indicators:
- Current Temperature
- Weather Condition
- Humidity
- Wind Speed
- Visibility
- Atmospheric Pressure
- UV Index
- Precipitation
- Weekly Temperature Forecast
- Daily Weather Icons
- Temperature Trend Line
- PM2.5
- PM10
- CO
- NO₂
- SO₂
- O₃
- Sunrise Time
- Sunset Time
- Daily Chance of Rain (%)
- Weather updates dynamically based on selected city.
- Live API ensures real-time weather information.
- Forecast visualization enables quick comparison of temperature trends.
- Air Quality metrics help evaluate environmental conditions.
- Rain probability assists users in travel planning.
- Sunrise and Sunset timings provide additional daily insights.
- Responsive design offers a consistent experience across different screen sizes.
Possible future enhancements include:
- 🌍 Global map visualization
- Weather alerts and notifications
- Severe weather warnings
- Historical weather comparison
- Temperature anomaly analysis
- Monthly climate trends
- Weather-based travel recommendations
- Multi-language support
- Dark & Light theme toggle
- Mobile-optimized dashboard version
Weather-Analytics-Dashboard/
│
├── Dashboard/
│ └── Weather Dashboard.pbix
│
├── Images/
│ ├── dashboard-preview.png
│ ├── city-selection.png
│ ├── forecast.png
│ └── air-quality.png
│
├── Documentation/
│ └── Project Report.pdf
│
├── README.md
│
└── LICENSE
- Download the repository.
- Open Weather Dashboard.pbix using Power BI Desktop.
- Refresh the report.
- Ensure an internet connection is available so the APIs can retrieve the latest weather data.
- Select any city to explore updated weather insights.
✔ Live API Integration
✔ Dynamic City Selection
✔ Fully Responsive Dashboard
✔ Interactive Visualizations
✔ Air Quality Monitoring
✔ Forecast Analytics
✔ Power Query Data Transformation
✔ Modern Dashboard UI
Harsh Sharma
- 💼 Aspiring Data Analyst
- 📊 Power BI | SQL | Python | Excel | Data Visualization
If you found this project helpful, consider giving it a ⭐ on GitHub!