Garvit Gupta
Data Analyst

Transforming raw data into actionable business insights

SQL | Tableau | Power BI | Python

SQL Data Cleaning & Exploratory Analysis

Cleaned and transformed a large dataset of global layoffs using SQL. Applied advanced queries and window functions to remove duplicates, standardize data, and uncover trends across industries and companies over time. The project demonstrates my ability to take raw, messy data and turn it into structured, reliable insights.

SQL Data Cleaning & Exploratory Analysis

Cleaned and transformed a large dataset of global layoffs using SQL. Applied advanced queries and window functions to remove duplicates, standardize data, and uncover trends across industries and companies over time. The project demonstrates my ability to take raw, messy data and turn it into structured, reliable insights..

Data Science Job Market Analysis (Python)

Analyzed Data Science job postings using Python (Pandas, Matplotlib, Seaborn). Cleaned the dataset and performed exploratory data analysis to uncover trends in job titles, salaries, and skill requirements. Built visualizations that reveal the most in-demand skills and locations for Data Science roles..

Sales Performance Dashboard (Power BI)

Built a Power BI dashboard to track sales performance across regions, products, and time periods. Implemented data cleaning with Power Query and calculated KPIs using DAX. Key visuals include sales funnels, regional maps, and product-wise profitability. The dashboard helps managers monitor revenue, cost, and profit in real time..

Interactive HR Analytics Dashboard (Tableau)

Designed and published a Tableau dashboard to analyze complex HR data. Created visualizations for employee distribution, attrition trends, and department-level KPIs. The dashboard is interactive and shareable online, allowing managers to drill down and track workforce performance in real time.

Smart City Litter Detection & Offender Analytics System

Developed an automated system to detect roadside litter and identify offending vehicles using image data. The project combined computer vision (YOLO, OCR) with analytics to extract actionable insights such as frequency of violations, high-risk locations, and repeat offenders.