Harsimarpreet
Singh Sahota

Problem

Leadership needed clearer visibility into revenue drivers, customer spending patterns, and logistics inefficiencies across end-to-end sales operations.

Analysis

Analyzed customers, products, orders, and shipping data using advanced SQL — joins, aggregations, subqueries, and CTEs — to evaluate product performance, sales trends, employee revenue contribution, and shipping efficiency.

Business Impact

Translated findings into actionable recommendations for revenue optimization and logistics improvement, supporting data-driven commercial decisions.

Key Insights

Surfaced customer spending patterns, operational bottlenecks, and product-level performance signals that informed portfolio and process priorities.

Problem

Retail leadership lacked an executive view of profitability across products, categories, regions, and time periods to guide portfolio optimization.

Analysis

Built an interactive Tableau dashboard on four years of Superstore sales data with drill-down analysis, geographic mapping, and trend reporting to identify underperforming segments.

Business Impact

Enabled a simulated executive strategic review with clear profitability recommendations and regional performance visibility.

Key Insights

Identified the Top 10 loss-making products and uncovered regional patterns that informed product mix and go-to-market focus.

Problem

HR leadership needed self-service visibility into workforce KPIs and attrition risk to support retention planning for 1,470 employees.

Analysis

Developed an Excel-based HR Analytics Dashboard using Power Query, Pivot Tables, and data visualization to track attrition rate, active employees, demographics, and related KPIs.

Business Impact

Presented data-driven retention strategy recommendations to simulated HR leadership, supporting workforce performance monitoring.

Key Insights

Identified high-risk attrition segments across departments, age groups, education levels, and job roles to prioritize intervention.