ABCDEFGHIJKLMNOPQRSTUVWXYZ
1
2
Warsaw Weather Analysis Dashboard - README
3
4
1. Overview:
5
The "warsaw_filled.xlsx" Excel workbook delivers a comprehensive visualization and analysis of Warsaw's daily weather data, spanning from 1993 to 2022.
6
This file is an essential tool for understanding weather patterns, trends, and significant events in Warsaw over the years.
7
8
2. Data Source:
9
The weather data integrated into this dashboard originates from a dataset publicly accessible on Kaggle (https://www.kaggle.com/datasets/mateuszk013/warsaw-daily-weather?resource=download). The dataset encompasses daily metrics such as average, maximum, and minimum temperatures, precipitation levels, and snow depths.
10
11
3. Workbook Sheet Structure:
12
For user convenience and easy navigation, the workbook is organized as follows:
13
Data: Contains the raw data and the columns created for the project.
14
Cards: Dedicated to generating the cards and the Timeline Slicer for the Detailed Time Analysis.
15
Seasonality: Crafts the monthly temperature graph to illustrate seasonality.
16
Probability: Analyzes precipitation and snow trends in the Seasonality Analysis.
17
Timeline: Dedicated to the yearly trend analysis graphs.
18
Colours: Displays the color palette employed in the dashboard.
19
20
4. How to Use:
21
Dashboard Viewing: Navigate to the "Dashboard" sheet to access the curated visual insights.
22
Seasonality Analysis: Data here is categorized by month. The "Probability of Day with Snow per Month" graph represents the likelihood of encountering snow in Warsaw, not necessarily the probability of snowfall on any given day.
23
Detailed Time Analysis: Use the Timeline Slicer to pinpoint specific daily/monthly/quarterly/yearly values from 01/01/1993 to 31/12/2022.
24
Yearly Trend Analysis: This section groups data by year for a lucid understanding of evolving trends.
25
If you wish to inspect or modify the raw data, head to the "Data" sheet. Please be cautious when altering data to maintain dashboard accuracy.
26
27
5. Data Cleaning and Preprocessing:
28
The data was explored and manipulate with Python.
29
30
6. Notes & Considerations:
31
The "warsaw_filled.xlsx" dashboard aims to provide a comprehensive view of Warsaw's weather patterns, but it's essential to approach the data with an analytical mindset and consider potential external factors that might affect the readings.
32
The workbook is optimized for use in the latest versions of Microsoft Excel. Display or functionality might vary slightly in older versions or different spreadsheet software.
33
34
7. Feedback & Suggestions:
35
Your feedback is invaluable. If you have insights, corrections, or any queries regarding the data and its presentation, please refer back to this README or contact the creator.
36
37
8. Credits & Acknowledgments:
38
A big thank you to the original data providers on Kaggle for making this dataset available to the public.
39
This dashboard was meticulously prepared to offer users a clear understanding of Warsaw's weather patterns over the years.
40
41
42
43
44
45
Version 1.1 Updates
46
UX/UI Improvements, more space between visualizations.
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100