Weather Wind & Snow Dashboards
Budget: $30 – $250 USD
I have a clean historical-weather spreadsheet and I want to turn it into a set of engaging dashboards and interactive 3d models.
I am trying to prove a thesis that wind direction during winter months contributes to snow blocking a road.
The key stories I need to see are:
• Predominant wind direction, average wind speed, and peak gusts broken down month-by-month. These should be sliders on a model.
• Daily snow-depth trends across the winter, with an overlay or clear link to the prevailing wind direction on each day or month.
Focus is on Dec-March
Please build whatever pivot tables, Power Query steps, or helper columns you feel are necessary and then surface the insights in a mix of 2D and 3D models—I’d like to be able to switch between the two for presentations. While winter is the primary focus, I still need the same wind metrics visible for the rest of the year so the workbook tells a complete story.
Deliverables
1. Output will be a proposal (MS Word) so static graphs via excel.
2. 3D model.
What I provide:
Source excel file.
Address location for Google Earth/3D model
subject matter knowledge
I am trying to prove a thesis that wind direction during winter months contributes to snow blocking a road.
The key stories I need to see are:
• Predominant wind direction, average wind speed, and peak gusts broken down month-by-month. These should be sliders on a model.
• Daily snow-depth trends across the winter, with an overlay or clear link to the prevailing wind direction on each day or month.
Focus is on Dec-March
Please build whatever pivot tables, Power Query steps, or helper columns you feel are necessary and then surface the insights in a mix of 2D and 3D models—I’d like to be able to switch between the two for presentations. While winter is the primary focus, I still need the same wind metrics visible for the rest of the year so the workbook tells a complete story.
Deliverables
1. Output will be a proposal (MS Word) so static graphs via excel.
2. 3D model.
What I provide:
Source excel file.
Address location for Google Earth/3D model
subject matter knowledge