Categories
Dashboards Tableau

Bad bookmark behavior – an inside look at a personal habit

Click here to jump straight to the dashboard

Some people are normal when it comes to saving things they care about. Some people have problems physically hoarding objects that link them to past memories. But me… I have problems with digital hoarding. It’s probably related to some combination of FOMO and consumerism that drives me to hitting that save button. Because… you know… I’ll eventually get back around to it.

So naturally, instead of actually revisiting some of my past bookmarks, I built a dashboard to analyze my bad habit.

I use a bookmark tool called Raindrop.io, which has an API I can easily pulled structured data from. Using this API, I extracted the bookmark data to a spreadsheet with a low-code automation tool called Integromat. It took about 2 minutes to do and I can run the automation again in the future or schedule it to run if I want to update my data.

Integromat is something I use frequently in my consulting business (MergeYourData.com) to automate business processes. It’s a great tool you should check out if you have automation needs but don’t want to code custom solutions.

So what did I build?

This was a fun and simple visualization. I just wanted to look at how frequently I was bookmarking things over the past year or so with Raindrop.io. So I did breakdowns by month, day, weekday, and hour.

Aliens and UFOs seem to be a hot topic ever since the Pentagon declassified some Navy videos in 2020. So why not make a viz with that theme?

The Dashboard

Thanks for reading. Any questions or comments? Feel free to reach out to me via email on my contact page.

Categories
Dashboards Tableau

Where Did PPP Loans Go? Taking a Deeper Dive.

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.

Categories
Dashboards Tableau

Looking at PPP Loan Data – A Visualization

$667 billion dollars were set aside in 2020 for businesses across the US. This program was called the Paycheck Protection Program (PPP for short). It was meant to be a stimulus package to hold over businesses who were impacted by COVID-19 lockdowns. Without revenue streams, many businesses had to lay-off workers en masse, providing a potentially catastrophic destabilization of American society. According to the Bureau of Labor Statistics, there were close to 18 million unemployed people in June of 2018. The PPP data indicates that over 31 million jobs were retained due to the program.

Without getting into the inaccuracies of the standard unemployment numbers provided by the Bureau, we can still see that laying off potentially 10% of a country’s population wouldn’t be healthy for society. In the past, the US government has provided stimulus and bailouts primarily via public spending increases and buying toxic assets from big corporations. But this stimulus was meant to directly support businesses of all sizes who were directly impacted by the lockdown. Did it server its purpose? You can be the judge of that! I’ve created a data visualization meant to help show where the money went across the nation. This visualization includes the ability to search and filter on columns of the data. In the near future, I’ll be releasing a dashboard that digs into the… more suspicious loans taken out.

Here’s the dashboard, it’s interactive and has some additional info when you hover over data. It is configured for desktop and phones, but is better to view on desktop.:

This data was recently released regarding PPP loans. It was split into different data sets. For loans greater than $150k, data for the whole nation is provided in one data set. For loans less than $150k, data is split by state or territory into its own data set. I’ll be providing a combined data set of all loans here in a little bit, but for now this visualization is for loans greater than $150k.

Some interesting takeaways from this visualization:

  • Allegedly nearly 10% of the US population’s jobs were retained due to the program
  • There were TONS of misspellings and bad data entry
  • The majority of loans were in the $150k-$300k range

P.S. Check out the next visualization here, where I take a deeper look at the PPP data.

Like this post? Subscribe to be notified of future dashboards and Tableau tips.