As requested by many. I have packaged up the National Weather Service Data Collector Powershell that I demo. This is a project I built with my son over a weekend last year as he is learning SQL and we both like data so we decided to build our own weather station collector.
The Solution picks up the current observations at the weather stations that update hourly and stores then in SQL Server. The GITHub Repo contains all of the Database build scripts, Weather feed Data Population Scripts, PowerShell Collector Script and of course no solution would be complete without a PowerBI dashboard.
Everything is published on GitHub at the below link. Please leave some feedback and let me know what you think.