An advanced Power BI dashboard for comprehensive personal finance analysis — tracking income, expenses, savings, and investments with interactive visuals and deep insights.
🔴 Click the banner below to access the interactive Power BI dashboard live:
⚠️ Access may require organizational credentials. The dashboard is hosted on Microsoft Power BI Service.
- Overview
- Live Dashboard
- Key Metrics & Insights
- Features
- Dashboard Components
- Financial Breakdown
- Demo Recording
- How to Use
- Tech Stack
- Future Enhancements
- Author
The Personal Finance Analysis Dashboard simplifies financial management by providing a crystal-clear overview of income sources, expenditure categories, savings progress, and investment distribution.
Built entirely in Power BI with Power Query transformations, this dashboard empowers individuals and families to:
- 💵 Track income, expenses, and savings trends over multiple years
- 📉 Identify overspending categories and cost-reduction opportunities
- 💹 Monitor investment portfolio growth and asset allocation
- 🎯 Set financial goals and measure progress with dynamic KPIs
📌 This dashboard uses sample data for demonstration purposes and does not represent actual financial records.
| Metric | Value |
|---|---|
| 💧 Liquid Cash | ₹2.79M |
| 💰 Income (2024) | ₹1.79M |
| 🏦 Total Savings | ₹1.27M |
| 📤 Expense Rate | 64% of income |
| 📥 Savings Rate | 45% of income |
| 📈 Monthly Income Growth | +6% (2024) |
| 📉 Monthly Expense Growth | -2% (2024) |
| Category | Amount |
|---|---|
| 🏠 House Rent | ₹152,000 |
| 🛒 Groceries & Food | ₹91,000 |
| 💳 EMIs | ₹78,000 |
| 🏥 Health | ₹22,000 |
💡 Insight: House rent and groceries dominate expenses, with EMI payments growing consistently year-over-year — a key area for financial optimization.
| Feature | Description |
|---|---|
| 📉 Expense Tracking | Visualize spending across rent, groceries, health, leisure, and more |
| 📈 Income & Savings Trends | Monthly and yearly breakdowns with growth rate percentages |
| 💹 Investment Insights | Allocation across liquid cash, mutual funds, emergency funds & fixed deposits |
| 🔍 Interactive Filters | Slice data by year, month, or financial category in real time |
| 🎨 Dynamic Visuals | Color-coded KPIs, bar charts, line graphs, and donut charts |
| 📊 Year-on-Year Comparison | Side-by-side performance comparison across multiple years |
- Year-on-year comparison of income, expenses, and savings
- Monthly growth rates for income and savings with trend indicators
- Surplus/deficit highlighting for immediate financial health assessment
- Savings rate as a percentage of total income
- Visual surplus and deficit trend tracking
- Goal-oriented savings performance benchmarks
- Granular spending across all categories (rent, groceries, leisure, health, EMIs)
- Year-over-year comparative expense analysis
- Category-level drill-through for deeper investigation
- Asset distribution across liquid cash, mutual funds, emergency funds, and fixed deposits
- Yearly investment growth trends
- Portfolio health summary with allocation percentages
| Year | Expenses | Savings |
|---|---|---|
| 2021 | ₹1.62M | ₹303K |
| 2022 | ₹1.87M | ₹364K |
| 2024 | ₹1.79M (income) | ₹1.27M |
| Metric | Growth Rate |
|---|---|
| 📈 Monthly Income Growth | +6% |
| 📉 Monthly Expense Growth | -2% |
| 💰 Net Savings Trend | Positive ↑ |
Watch a live walkthrough of the Finance Analysis Dashboard in action:
FD.webm
-
🌐 Access the Dashboard Click the Live Dashboard link above to open the interactive report in Power BI
-
🔍 Explore Interactive Features Use the slicers and filters to drill down by year, month, or spending category
-
📊 Navigate Dashboard Pages Browse through Income, Expenses, Savings, and Investment pages for full financial coverage
-
📥 Download & Customize Clone this repository and connect your own data source to personalize the dashboard
💬 For collaboration or questions, reach out at abdelaaliennamat@gmail.com or open a GitHub Issue.
| Technology | Purpose |
|---|---|
| Dashboard design & interactive visualizations | |
| Source data management & structuring | |
| Data cleaning, transformation & modeling | |
| Custom measures & calculated KPIs |
| Enhancement | Description |
|---|---|
| 🔄 Automated Data Updates | Integrate live APIs for real-time financial data syncing |
| 🤖 Predictive Modeling | Add ML-based projections for future savings and expense forecasting |
| 📊 Benchmark Comparisons | Enable comparisons against national or industry financial standards |
| 📱 Mobile Optimization | Responsive layout optimized for smartphones and tablets |
| 🔐 Personal Data Mode | Allow users to input their own financial data securely |
ABDELAALI ENNAMAT
Data Analyst | Power BI · Excel · DAX · Power Query
⭐ If you found this project useful, please consider giving it a star! ⭐