This project showcases an executive-level Power BI dashboard designed to analyze Finance and Operations KPIs for FY 2023.
The dashboard supports leadership decision-making by providing visibility into revenue performance, customer mix, regional trends, and cost leakage drivers.
- Track Total Revenue (YTD) and customer-level monetization
- Identify cost leakage and operational inefficiencies
- Analyze revenue trends over time
- Compare regional performance
- Enable root cause analysis for cost optimization
- Total Revenue (USD) – YTD
- Cost Leakage (USD) – Variance
- Average Revenue per Customer
- Shows month-over-month revenue movement
- Helps identify growth patterns and seasonal behavior
- Enterprise vs SMB revenue mix
- Enables strategic customer segmentation insights
- Compares regional revenue contribution (APAC, EMEA)
- Supports geographic performance analysis
- Highlights products contributing most to cost overruns
- Supports root cause analysis (RCA) and cost optimization initiatives
- A small subset of products contributes disproportionately to cost leakage
- Revenue is diversified across customer segments with balanced contribution
- Regional revenue performance remains stable across major markets
- Power BI Desktop
- SQL (data extraction)
- Power Query (data transformation)
- DAX (KPI calculations)
- Star Schema Data Modeling
Finance_Operations_KPI_Dashboard.pbix→ Final Power BI reportscreenshots/→ Dashboard visuals for quick previewREADME.md→ Project documentation
- Download the
.pbixfile - Open in Power BI Desktop
- Explore interactive visuals and filters
This project is built as a portfolio demonstration and reflects best practices in:
- BI storytelling
- Executive dashboard design
- KPI-driven analytics
Riya Rastogi
GitHub: https://github.com/riyalytics