/2022-Personal-Financial-Analysis-DB-MSExcel

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.

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

    expensesbycategories

  • A summary of monetary inflows and outflows

    Inflow and outflow

  • Weekly breakdown of expenses by categories

    Weekly expenses

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

    expensesincome

  • An overview of the top 5 expenditure categories

    top5outflow

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

    KPI

Active filters needed to interact with the data and the dashboard

Month and categories column

Month category

Tools Used

Microsoft Excel

  • 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

pfdbog