This project is a professional multi-page Financial Analytics Dashboard built using Microsoft Power BI. The dashboard provides deep insights into business revenue, profitability, customer behavior, product performance, and operational efficiency.
The goal of this project is to transform raw financial sales data into meaningful business intelligence using interactive visualizations, KPI tracking, and analytical storytelling.
- Microsoft Power BI
- Power Query
- DAX (Data Analysis Expressions)
- Data Modeling
- Interactive Dashboard Design
The dataset contains financial and sales transaction data including:
- Revenue
- Profit
- Orders
- Customers
- Regions
- Categories
- Sub-Categories
- Discounts
- Shipping Modes
- Product Sales
- Customer Segments
Dataset format:
- CSV / Excel
This page provides a high-level overview of overall business performance.
- Total Revenue
- Total Profit
- Profit Margin %
- Total Orders
- Average Order Value
- Revenue & Profit Trends Over Time
- Revenue Distribution by Region
- Revenue Contribution by Category
- Top Performing Product Sub-Categories
- Interactive Filters
- Technology category generated the highest revenue.
- Western region showed strongest sales performance.
- Profit margins remained stable despite fluctuations.
- Product sub-categories strongly influence profitability.
This page focuses on operational efficiency and profitability drivers.
- Average Discount
- Average Profit
- Profit Ratio
- Average Quantity
- Profitability by Product Category
- Discount Impact on Profitability
- Top Profitable States
- Profit Distribution by Customer Segment
- Yearly Profit Growth Trend
- Higher discounts negatively impacted profit margins.
- Consumer segment contributed major revenue share.
- Certain states underperformed despite strong sales.
- Profit trends indicate business growth opportunities.
This page analyzes customer behavior and product performance.
- Total Customers
- Average Revenue
- Average Quantity
- Average Discount
- Top Customers by Revenue
- Revenue Contribution by Segment
- Profit Distribution by Shipping Mode
- Sales Contribution by Segment
- Top Revenue-Generating Products
- Quantity Sold Across Product Categories
- Consumer segment generated the highest customer revenue.
- Technology products showed strong profitability.
- Standard shipping mode contributed major operational profit.
- Top customers significantly influence overall performance.
- Interactive slicers and filters
- Multi-page dashboard navigation
- KPI-driven business analysis
- Consistent professional UI design
- Executive-level analytical storytelling
- Dynamic charts and visual insights
Some important DAX calculations used in the project:
Total Revenue = SUM(FinancialData[Sales])
Total Profit = SUM(FinancialData[Profit])
Profit Margin % = DIVIDE([Total Profit], [Total Revenue], 0) * 100
Total Orders = DISTINCTCOUNT(FinancialData[Order ID])
Average Order Value = DIVIDE([Total Revenue], [Total Orders], 0)
- Dashboard Background: #702254
- KPI Cards: #F191D6
- Visual Accent: Blue Tones
- Text Color: White
The dashboard was created to:
- Analyze financial performance
- Identify profitable business areas
- Understand customer purchasing behavior
- Evaluate product and regional performance
- Support business decision-making using data
This project demonstrates:
- Business Intelligence skills
- Data visualization expertise
- DAX calculation knowledge
- Dashboard design principles
- Analytical storytelling capability
- Real-world financial analysis
(Add Screenshot Here)
(Add Screenshot Here)
(Add Screenshot Here)
Financial-Analytics-Dashboard-PowerBI/
│
├── Dataset/
├── Screenshots/
├── Executive_Financial_Analytics.pbix
├── README.md
Possible future improvements:
- Forecasting using Power BI AI visuals
- Advanced drill-through pages
- Geographic map analysis
- Real-time data integration
- Mobile dashboard optimization
Girija Nagarajan Computer Science Engineering
This project showcases how raw business data can be transformed into actionable insights using Power BI. The dashboard enables business users to monitor financial performance, understand profitability drivers, and make informed strategic decisions through interactive analytics.