Dashboard Views Gallery (Views 1, 2 & 3)
1. Business Problem
Executive leadership needed a consolidated financial diagnostic portal to monitor quarterly budget variances, operating expenses, and cash flow liquidity. Static monthly spreadsheets hindered real-time decision-making and delayed variance resolution across business units.
2. Project Objectives
- Architect a 3-page Power BI financial intelligence system tracking gross margins, operating expenses, and cash flow.
- Develop complex DAX measures for Year-over-Year (YoY) Growth, Budget vs. Actual Variance %, and EBITDA Margins.
- Enable dynamic scenario slicers to model expenditure cuts and revenue growth targets.
3. Dataset Information
Corporate general ledger and financial dataset comprising 85,000+ line items:
- General Ledger: Transaction ID, Date, Account Code, Department, Amount, Transaction Type (Revenue / Opex / Capex).
- Budget Tables: Fiscal Quarter, Target Revenue, Approved Budget Limit, Forecast Model.
- Dimensional Tables: Dim_Account, Dim_Department, Dim_FiscalCalendar.
4. Tools Used
Power BI Desktop
Advanced DAX
Power Query M Engine
Corporate Finance
5. Data Cleaning & Transformation
Transformation steps executed in Power Query & DAX:
1. Normalized general ledger accounts into standardized P&L reporting hierarchies.
2. Built relational Star Schema connecting Fact_GL to Dim_Department, Dim_Account, and Dim_Calendar.
3. Formulated DAX Measure for Budget Variance %:
Variance % = DIVIDE(SUM(Fact_GL[Actual_Amount]) - SUM(Fact_GL[Budget_Amount]), SUM(Fact_GL[Budget_Amount]), 0)
6. Key Performance Indicators (KPIs)
$18.4M
Annual Revenue Ingested
+14.2%
Gross Margin Growth
96.8%
Budget Accuracy Rate
7. Dashboard Interface Showcase (Views 1, 2 & 3)
The suite features three dedicated financial reporting tabs:
View 1: Finance Job Market Analysis
View 2: Salary and Skills
View 3: Recruitment Performance
8. Strategic Financial Insights
Finding 1: Opex Leakage Identification
Identified a 16.8% unbudgeted cost overrun in Q2 software licensing expenses across IT and Marketing operations.
9. Strategic Recommendations
- Consolidate enterprise software vendor subscriptions to save an estimated $84,000 annually.
- Implement automated weekly DAX alert thresholds for departmental spending exceeding 90% of budget limits.
10. Technical Challenges
Handling fiscal calendar alignment (4-4-5 accounting calendar) was resolved using custom DAX time-intelligence pattern functions.
11. Lessons Learned
Dividing financial reporting into high-level overview, diagnostic breakdown, and forward-looking forecasting views provides executive decision-makers with unmatched financial clarity.
12. GitHub Repository
Open Source Power BI Financial Template
Inspect DAX measures and financial statements setup on GitHub.
13. Downloads & Resources
14. Related Analytics Case Studies
