DS20: Dashboard Week Day 3 - SBA Paycheck Protection Program

by Andy Kriebel

The CARES Act (one of the programs the US Congress passed to help companies through the early stages of the COVID debacle) included loans to “small” businesses. One of the requirements was to release the data for who the loans for payroll protection were given to. DS20 has the task of creating a KPI dashboard based on the data.

Photo by NeONBRAND on Unsplash

There is data for loans above $150K and below $150K by State. They can choose to use either or both. The data for above 150K is all in one file, whereas, for some dumb reason, the data for below 150K is in separate files by State. I swear they do this on purpose to make it difficult for people to analyze and to hold them accountable.

Good luck team!

Avatar

Andy Kriebel

Dashboard Week Day 5 - Eastern Bering Sea Crab Distribution

1 mins read

Fri 27 Nov 2020

Dashboard Week Day 4 - California Fire Incidents

1 mins read

Wed 25 Nov 2020

Dashboard Week Day 3 - Historical Tornado Tracks

1 mins read

Wed 25 Nov 2020

Dashboard Week Day 2 - The Change in Forest Cover

1 mins read

Tue 24 Nov 2020