1- Sales & Delivery Performance Analysis (Power BI) 

In this project, I analyzed over 66,000 orders to uncover trends in sales performance and delivery efficiency across global markets using Power BI. The goal was to answer critical business questions and identify the root causes of delayed deliveries, while tracking profitability and customer segment performance. 

This interactive dashboard was developed using Power BI to analyze sales data from 2014 to 2017. The goal was to provide key insights into sales performance across product categories, customer segments, regions, and time.

📊 Key Features:

• Time Trend Analysis: Tracked yearly sales and order volume, revealing peaks in 2015 and 2017.

• Sales by Category: Compared performance across Furniture, Office Supplies, and Technology.

• Profitability Insights: Included income statement breakdown (Sales, COGS, Profit), showing an overall 12.5% profit margin on $2.3M total sales.

• Regional Analysis: Showed highest revenue in the West and East regions, with detailed % profit per region.

• Shipping Mode Breakdown: Highlighted that 59.7% of orders were shipped via Standard Class.

• Customer Metrics: Analyzed data from 793 customers, across 5K orders, and tracked 296 returns.

• Geographic Visualization: Plotted state-level sales performance across the US by product category.

3-HR Analytics Dashboard (Power BI) 

This Power BI dashboard provides a detailed analysis of HR data, focusing on employee demographics, attrition rates, job satisfaction, and salary trends across various departments and job roles. It helps identify patterns in employee turnover and offers insights to support data-driven HR decisions. 

This interactive HR analytics dashboard was created in Power BI to explore key human resources metrics such as attrition rate, salary distribution, employee demographics, and job satisfaction. It provides HR teams with insights into workforce trends, helping identify departments with high attrition, analyze job satisfaction across roles, and understand how education, age, and performance correlate with employee retention.

📊 Key Features:

• Attrition Analysis: Identifies an overall attrition rate of 16.12% across 1,233 employees.

• Salary by Job Role: Shows that Sales Executives have the highest average monthly salary.

• Demographics & Education: Visualizes employee distribution by age group, education level, and marital status.

• Department Insights: Reveals that R&D has the largest employee count, while HR has the smallest.

• Job Satisfaction Ratings: Summarizes satisfaction scores across 9 job roles, showing where improvements may be needed.

• Performance Ratings by Department: Helps correlate satisfaction and retention with performance evaluations.