2022-Personal-Financial-Analysis-DB

Problem Statement

This project was developed as a way to keep track of my expenses, allowing me to make informed and smart money decisions based on my complete financial picture.

Dataset Used

In this dashboard, data is pulled from income and expense statements from January 2022 to July 2022, represented in 345 rows and 10 columns.

Analyses derived from the dataset

• Hierarchial representation of various streams of income and expenditure categories

  

• A summary of monetary inflows and outflows

  

• Weekly breakdown of expenses by categories

  

• Can toggle between income and expenses visualized on a monthly basis with ease

  

• An overview of the top 5 expenditure categories

  

• Easy-to-read cards visualize important KPIs for rapid decision-making

  

Active filters needed to interact with the data and the dashboard

Month and categories column

Tools Used

• Utilized MS Excel to categorize income and expenditure reports into a detailed pivot table to develop an improved financial strategy that resulted in 15% savings.
• Administered IF, COUNTA, and VLOOKUP function to summarize and project monthly monetary inflows and outflows.
• Automated manual filter removal using macros and VBA to reduce budget preparation time by 5%.

Overview