E-commerce Analytics Dashboard

Description: This project creates a dashboard to analyze online retail performance. It includes DAX measures to calculate Total Revenue, Revenue Growth %, and Customer Lifetime Value. The dashboard features visualizations such as a revenue trend line chart, a product performance scatter plot, customer segment cards, and a geographic sales map with slicers for Date Range, Product Category, and Customer Segment.

Supply Chain Management

Description: This project focuses on supply chain efficiency. It uses DAX measures like Inventory Turnover, Stock Coverage Days, and Stockout Risk Score. Visualizations include a treemap for inventory health, a Sankey diagram for supply chain flows, a box and whisker plot for lead time analysis, and a time series forecast for demand forecasting. Slicers enable filtering by Warehouse Location, Product Category, and Time Period.

Healthcare KPI Dashboard

Description: Designed for healthcare organizations, this dashboard tracks key performance indicators. It uses DAX measures to calculate Patient Wait Time, Bed Occupancy Rate, Revenue Per Patient, and Emergency Response Time. The visuals include a department performance matrix, a custom patient flow diagram, gauge charts for resource utilization, and KPI cards for quality metrics. Slicers allow filtering by Department, Date Range, and Patient Type.

Financial Performance

Description: This project provides a comprehensive view of financial performance with key ratios. DAX measures like Gross Profit Margin, Working Capital, Quick Ratio, and YoY Growth are used. Visualizations include multi-row cards for financial ratios, a waterfall chart displaying the P&L statement from revenue to net profit, an area chart for cash flow analysis, and a column chart for Budget vs Actual variance analysis. Slicers help filter by Fiscal Year/Quarter, Business Unit, and Account Category.