📊 Personal Finance Dashboard Analysis | Power BI Project

🎯 Problem Statement

This project was designed to answer key business questions:

• How does income compare to expenses?
• Which categories contribute most to spending?
• Are savings targets being achieved?
• What trends exist across financial activities?
• How can financial performance be improved?

📈 Key Insights

• ✅ Income consistently exceeded expenses, resulting in positive net savings.
• ✅ Salary and Investments were the largest contributors to total income, indicating diversified income sources.
• ✅ Healthcare, Travel, and Dining emerged as major spending categories and represent opportunities for cost optimization.
• ✅ Financial activity showed monthly fluctuations, highlighting seasonal spending behaviors and varying cash flow patterns.
• ✅ Savings performance remained healthy, with a positive savings rate and strong potential for long-term wealth accumulation.

💡 Recommendations

• 🔹 Implement category-based spending limits for discretionary expenses.
• 🔹 Automate monthly savings contributions to improve consistency.
• 🔹 Expand investment allocations to strengthen long-term financial growth.
• 🔹 Develop real-time budget monitoring and alert systems.
• 🔹 Track KPIs such as Savings Rate, Budget Variance, Net Savings, and Expense-to-Income Ratio for continuous financial oversight.

🛠️ Tools Used:

• Power BI
• Excel
• SQL
• Data Modeling
• DAX
• Data Visualization