Personal project used to consolidate all bank statements creating an ETL framework ending in a published Tableau dashboard. Reason for creation of this is to have an interactive way to manage spending from different accounts and highlight specific spending patterns that I have in order to minimise my spend and maximise saving potentials.
Tools and techniques used: Python, SQL, Tableau, Pandas, REST API, Data Warehousing, Data Manipulation, Data Visualisation
Initial thoughts when conducting this is to both answer certain questions and confirm initial budgeting hypothesis that I had:
- I am spending more than I am earning
- Biggest expenditure is my partner (main category over-budget)
- How consistent are my additional income streams?
An intiial flow was created below to map out the different stages of the ETL process
From the initial flow an interactive dashboard can be seen via this link (a screenshot of dashboard can be seen below)
We can see that on average I am spending more than I am earning.
Looking at the months where I spent less than what I earn, the root cause of this was a reduction in other
expenditure
Also the largest month of income both from tutoring alongside salary bonus.
We can see that the majority of the time, I am spending more than I am earning. What is next is to see what exactly is the largest driver and is this in line against the budgets that have been made for them.
Initial hypothesis was my partner was my main expense which is why I mapped a max budget of £600 against her. Looking at my mapped categories over time, I can see that my partner Girlfriend_tax
is significantly under the amount.
The main category that has been significantly sporadic are my groceries
month over month alongside transport
. A re-evaluation of my budgets should be considered to keep me consistent against my budget.
From the time series chart we can see that there was a downward trend in the additional income (tutoring) from February. Tutoring also only accounts for at highest <3% of income so recommendations would be to increase tutoring amount to acount for 5% of my income.
- Looking at spend over time, we can see that
other
is the main driver of spend- Looking into the description of what this entails the majority of this is food and luxury miscalaneaous expenditure
- Seeing the trend chart of account balance, we can see the positive months are when I increase my amount of additional income streams
- I have overestimated the amount of budget for my partner and underestimated the amount for groceries and trasnport
This calls for a re-evaluation and recommendation for spending behaviour
In order to improve spending behaviour a number of factors need to be done to chnage:
- Reduce expenditure on luxury goods to have a postitive account balance
- Increase the amount of additional income streams. This will allow to spend more and remain still at a positive balance
- Re-map muy budget reducing the amount for budget
- Reduce
girlfriend_tax
to 350 - Increase
groceries
to 150 - Increase
transport
to 200
- Reduce