This project provides a comprehensive Power BI dashboard and financial report analyzing the financial performance of an e-commerce superstore. Designed to support financial analysts and business decision-makers, this solution helps monitor key metrics, budget tracking, and profitability insights.
This financial dashboard delivers a deep analysis of the company's financial health, including:
- 📈 Key performance metrics
- 🧾 Budget vs. actual tracking
- 💵 Revenue and expense trends
- 💹 Profitability ratios
The data was collected from multiple structured reports:
- Balance Sheet → Assets, liabilities, equity
- Income Statement → Revenues, expenses, net profit
- Budget Data → Target vs. actuals
- Date Table → Time intelligence and period analysis
Data Cleaning & Preparation:
- Handled missing values
- Standardized naming conventions
- Filtered relevant financial periods
Transformations:
- Merged datasets for unified analysis
- Created custom columns for segmentation
- Filtered by active entities and valid transactions
- KPI Cards → Net Profit, Revenue Growth, Expense Growth, Leverage Ratio
- Monthly Trends Overview
- Interactive Navigation Buttons
- Waterfall Chart → Net profit breakdown
- Line Chart → Revenue vs. Expenses over time
- Pie Chart → Expense category analysis
📸 Sample:
- Variance Table → Actual vs. Budget (Revenue & Expenses)
- Bar Chart → Monthly performance
- KPI Card → Budget achievement %
📸 Sample:
- Trend Lines → Risk over time
- Entity Status Table → Highlights dormant or inactive entities
- Total Assets: $350M
- ROA: 5% | ROE: 103% | D/E Ratio: 1978% | Liquidity: 1.06
🔍 Insight: Heavy reliance on debt raises financial risk.
- Profit: $17.42M (vs. $6.96M planned)
- Revenue: $115.92M (vs. $45.55M planned)
- COGS: $98.5M (vs. $38.53M planned)
🔍 Insight: Strong overperformance, but poor forecasting accuracy.
- Net Profit: $17M (15.02%)
- Gross Profit: $49.4M (42.61%)
🔍 Insight: High revenue offset by rising operational costs.
- Entity 3: Dormant, only insurance costs
- Entity 2: Missed revenue target
- Profit Drop: Noted in April & October, recovered later
- Leverage Spike: Q2 → Increase in liabilities
- 📅 Monitor seasonality → Adjust plans for April & October dips
- 💤 Review dormant entities → Especially Entity 3
- 💰 Optimize expenses → Reduce operational inefficiencies
- 📉 Enhance forecasting → Improve planning accuracy
- 📉 Reduce debt → Address 1978% D/E ratio through restructuring
- Power BI Desktop & Service
- Power Query (M Language)
- Excel & CSV Data Sources
📄 Click here to view full documentation (PDF)
For inquiries or feedback, feel free to connect:
Omar Wahby
📧 omarwahby35@gmail.com