Recently, I published a dashboard that took a broad look at PPP loan data. Over the past few weeks, I looked deeper into that data set in order to pull more interesting findings from it.
Before you take a look, here are the most significant highlights in my opinion:
- Spelling mistakes were prominent. Out of some of the 9 largest cities in the USA, there were more than 100 spelling variations.
- About 4000 investment-related firms took out loans totaling between 1 and 3 billion dollars. This is interesting because investment fees and activities were at record highs during lockdowns.
- The top 10 industries by loan count were heavily in-person industries, indicating that loans were distributed largely to businesses who needed them most.
While the dashboard has been developed for mobile as well, the viewing experience will probably be better on desktop.
Like this post? Enter your email below to subscribe for more visualizations and Tableau related posts.
4 replies on “Where Did PPP Loans Go? Taking a Deeper Dive.”
Your point of view caught my eye and was very interesting. Thanks. I have a question for you.
Thank you for your sharing. I am worried that I lack creative ideas. It is your article that makes me full of hope. Thank you. But, I have a question, can you help me?
Thank you for your sharing. I am worried that I lack creative ideas. It is your article that makes me full of hope. Thank you. But, I have a question, can you help me?
I don’t think the title of your article matches the content lol. Just kidding, mainly because I had some doubts after reading the article.