Personal Finance Dashboard

Overview

This Power BI dashboard provides an interactive and visually appealing way to analyze personal finance data. It tracks income, expenses, savings, and spending habits, enabling better financial decision-making.

---

Key Features

• Income vs. Expenses: Compare your monthly earnings and expenditures.
• Savings Trends: Monitor savings growth over time.
• Category-wise Breakdown: Understand spending across categories such as groceries, utilities, and more.
• Interactive Filters: Customize analysis with filters for time periods and spending categories.

---

Data Cleaning

• Source: The data was imported from an Excel file.
• Steps:
  1. Addressed missing values to ensure data completeness.
  2. Standardized date formats for consistency.
  3. Removed duplicate entries for accuracy.
  4. Created calculated fields for monthly savings and cumulative totals.

---

Tools and Visualizations

• Tools Used:

  • Microsoft Power BI for dashboard creation.
  • Excel for initial data organization and preprocessing.

• Visualizations:

  • Bar Charts: Income and expense comparisons by month.
  • Line Graphs: Savings trends over time.
  • Pie Charts: Expense distribution across categories.
  • KPI Cards: Key financial metrics like total income, expenses, and net savings.
  • Slicers: Interactive filters for customized views.

---

How to Use

1. Download the personal_finance_dashboard.pbix file from this repository.
2. Open it using Microsoft Power BI Desktop.
3. Use the filters and visualizations to explore your data and gain insights.

---

Future Improvements

• Introduce predictive analysis for forecasting future savings and expenses.
• Add real-time data integration from bank APIs.
• Enhance interactivity with advanced DAX calculations.