To develop an interactive Power BI dashboard that visualizes weather trends across Sri Lanka's 25 districts over the past five years, providing key insights for better decision-making.
Budget: $30 – $250 USD
Objective:
To develop an interactive Power BI dashboard that visualizes weather trends across Sri Lanka's 25 districts over the past five years, providing key insights for better decision-making.
Data Overview:
The dataset includes monthly data for each district
from the last five years, covering:
Low Temperature
High Temperature
Average Temperature
Sunshine Hours
Rainfall
Rainy Days
Humidity
Key Dashboard Components & Insights:
1. Overview Dashboard
Map Visualization: Heatmap of Sri Lanka’s 25 districts showing temperature variations.
KPI Cards: Summary of key metrics like highest and lowest temperature, total rainfall, and sunshine hours.
Trends Over Time: Line charts showing trends in temperature, rainfall, and humidity over five years.
2. Temperature Analysis
Monthly & Seasonal Patterns: Compare high, low, and average temperatures across months and years.
District-Wise Variations: Identify which districts experience extreme heat or cold.
Heatmap by Month & District: A matrix to highlight temperature fluctuations.
3. Rainfall & Humidity Insights
Rainfall Trends: Track total monthly and yearly rainfall to identify wet and dry periods.
Rainy Days vs. Rainfall Amount: Understand distribution of rainfall across the month.
Humidity Trends: Analyze how humidity fluctuates and its correlation with rainfall and temperature.
4. Sunshine Hours & Climate Patterns
Sunshine vs. Rainfall: Compare sunshine hours with rainy days to see seasonal shifts.
Impact of Sunshine on Temperature: Determine if increased sunshine results in higher temperatures.
5. Interactive Filters for Analysis
Filters: Users can select year, district, and weather parameters for deeper analysis.
Comparisons: Enable comparisons between different years or districts to see long-term changes.
To develop an interactive Power BI dashboard that visualizes weather trends across Sri Lanka's 25 districts over the past five years, providing key insights for better decision-making.
Data Overview:
The dataset includes monthly data for each district
from the last five years, covering:
Low Temperature
High Temperature
Average Temperature
Sunshine Hours
Rainfall
Rainy Days
Humidity
Key Dashboard Components & Insights:
1. Overview Dashboard
Map Visualization: Heatmap of Sri Lanka’s 25 districts showing temperature variations.
KPI Cards: Summary of key metrics like highest and lowest temperature, total rainfall, and sunshine hours.
Trends Over Time: Line charts showing trends in temperature, rainfall, and humidity over five years.
2. Temperature Analysis
Monthly & Seasonal Patterns: Compare high, low, and average temperatures across months and years.
District-Wise Variations: Identify which districts experience extreme heat or cold.
Heatmap by Month & District: A matrix to highlight temperature fluctuations.
3. Rainfall & Humidity Insights
Rainfall Trends: Track total monthly and yearly rainfall to identify wet and dry periods.
Rainy Days vs. Rainfall Amount: Understand distribution of rainfall across the month.
Humidity Trends: Analyze how humidity fluctuates and its correlation with rainfall and temperature.
4. Sunshine Hours & Climate Patterns
Sunshine vs. Rainfall: Compare sunshine hours with rainy days to see seasonal shifts.
Impact of Sunshine on Temperature: Determine if increased sunshine results in higher temperatures.
5. Interactive Filters for Analysis
Filters: Users can select year, district, and weather parameters for deeper analysis.
Comparisons: Enable comparisons between different years or districts to see long-term changes.