Projects :
1. Electric Vehicle Market Analysis Dashboard
- Designed and developed an interactive Power BI dashboard to visualize electric vehicle metrics such as sales trends, market penetration, customer adoption rates, and regional performance.
- Used Power Query Editor to clean and transform large EV datasets, enabling real-time analytics and predictive trend identification.
- Created dynamic visualizations including monthly and quarterly sales growth, top-performing regions, and customer segmentation.
- Supported strategic business decisions by providing clear, data-driven insights into electric vehicle market dynamics and growth opportunities.
2. Healthcare Analytics and Performance Dashboard
- Developed a Power BI dashboard to analyze patient admissions, treatment outcomes, and hospital resource utilization.
- Applied Power Query and DAX to clean, model, and visualize healthcare data for real-time performance tracking.
- Created dynamic visualizations such as admission trends, bed occupancy rates, and department-wise performance analysis to support hospital management decisions.
- Delivered actionable insights to support improvements in patient care quality and hospital operations.
3. Online Retail Sales Analytics Dashboard
- Built an interactive Power BI dashboard to analyze ecommerce sales, profit, quantity, and average order value across regions, categories, and payment modes.
- Applied Power Query and DAX for data transformation, trend analysis, and performance tracking by customer, city, and product category.
- Delivered actionable insights to support sales optimization and strategic business decisions.
4. HR Analytics – Data Visualization using Power BI
Developed an interactive HR Analytics Dashboard using Power BI to analyze employee data and visualize
key metrics. The dashboard supports strategic decision-making by highlighting trends in attrition,
employee satisfaction, salary distribution, and tenure.
Key Contributions:
• Built an interactive Power BI dashboard to analyze ecommerce sales, profit, quantity, and average
order value across regions, categories, and payment modes.
• Applied Power Query and DAX for data transformation, trend analysis, and performance tracking by
customer, city, and product category.
• Delivered actionable insights to support sales optimization • and strategic business decisions.
• Built custom DAX measures for KPIs like attrition rate, active employee count, and distance
categorization (Near, Far, Too Far)
• Analyzed relationships between job satisfaction, overtime, job involvement, and attrition
• Created slicers and filters for dynamic insights based on job role, education field, salary range, and
marital status
• Presented insights such as:
->Highest attrition by department and age group
->Monthly income by job level
->Employee distribution by satisfaction level and distance from home
