Posted by John David Sant
August 21, 2020
As COVID-19 continues to affect millions of people around the world, many are taking a closer look at their finances. Mint.com and the Mint app can help with this as it allows you to connect to all of your accounts in one place to stay on top of your money. The one drawback (especially in the app) is the data visualization. The data visualizations consist of donut charts, bar charts and text tables and do not facilitate any type of comparison whether that is year-over-year or month-over-month.
Connecting to the transactional Mint data in Tableau allows the creation of more impactful visualizations to stay on top of your money. At the end of this post, you can download the sample dashboard that was created and then switch out the data source with your transactional data.
I will be using a fake dataset that contains John Smith’s transactions over the past year and a half. John Smith is a Business Analyst who works in the city, and he is interested in knowing how his spending has changed this year due to the global pandemic. Fortunately, he still holds a job. He now works from home and has been spending a lot less money at restaurants and on take-out.
The main questions that he would like answered from the dashboard are the following:
The finished dashboard can be found HERE . Note that after connecting to your data, you might need to tweak it to suit your needs. For example, there is a category in Mint called “Hide from Budget & Trends”. I use this category to classify any duplicate transactions that might occur in my transactional data. In Tableau, you would need to add category as a data source filter and exclude the “Hide from Budget & Trends” category.
You can follow the steps below to connect the finished Tableau dashboard to your own Mint.com data.
And there you have it! Now you can start exploring this incredibly insightful dashboard and get answers for those important questions about your finances.
At Unilytics one of our core specializations is assisting SMBs with business intelligence strategies that will facilitate data driven decision making. We provide a full range of business intelligence services including: helping you evaluate and select the right tools, creating an advanced BI reporting system, and providing ongoing assistance and support. Let us know how we can help you.