Power Query Archives - SoothSawyer

John Hopkins COVID-19 Time Series Historical Data (with US State and County data) – Up to 9/1/2021

For those of you tracking COVID-19 (Coronavirus) thru John Hopkins, they modified their time series database schema on March 23, 2020 and deprecated their previous schema immediately. I recreated the older schema version of the following files (up to date with September 1, 2021 data). These files have ALL historical data from John Hopkins. You […]

Finance

Over 26K Salaries Exposed! Here’s What I Learned.

About a week ago, askamanager.org (with 2 million monthly visitors) collected over 26,000 salaries from ordinary people like you and me. And Alison Green was kind of enough to share the Google spreadsheet of all the submissions. Although there are some issues with the data collected (which I’ll talk about at the end of this post for those that care), […]

Ryan S

I have been around IT since I was in high school (running a customized BBS, and hacking) and am not the typical person that finds one area of interest at work; I have designed databases, automated IT processes, written code at the driver level and all the way up to the GUI level, ran an international software engineering team, started an e-commerce business that generated over $1M, ran a $5B product marketing team for one of the largest semiconductor players in the world, traveled as a sales engineer for the largest storage OEM in the world, researched and developed strategy for one of the top 5 enterprise storage providers, and traveled around the world helping various companies make investment decisions in startups. I also am extremely passionate about uncovering insights from any data set. I just like to have fun by making a notable difference, influencing others, and to work with smart people.