Hi, I'm Gaurav Kumar

Analyst & Problem Solver | Mechanical Engineering @ BIT Mesra
Proficient in Data Analytics, MS SQL, Excel, Power BI, and Python (Pandas, NumPy, Matplotlib, Seaborn).
Former IEEE Technical Member and Data Analytics Intern.
Passionate about transforming raw data into actionable strategies that drive real-world impact.

@ Pixel Piratey

Exploratory Data Analysis (EDA) in Python

Performed comprehensive EDA on large datasets using Pandas, NumPy, Matplotlib, and Seaborn.
Identified key trends, cleaned missing values, and visualized patterns to generate actionable insights for decision-making.

UPI Transactions Analysis
in Power BI

UPI Transactions Dashboard

Built an interactive Power BI dashboard on UPI transactions with details like amount, status, banks, cities, and devices.
Applied data cleaning and a DAX measure to track total transactions, success rate, age groups, gender, and city-wise usage.

Amazon Customer Reviews
Sentiment Analysis (AI)

Amazon Sentiment Analysis

Performed sentiment analysis on Amazon product reviews using Python, NLP, and Machine Learning.
Preprocessed text data, applied classification models, and visualized customer opinions as positive, neutral, or negative.
The project provides insights into customer satisfaction, product quality, and brand perception.

NYC Airbnb
Data Cleaning & EDA

NYC Airbnb Data Analysis

Cleaned and analyzed the New York City Airbnb 2019 dataset.
Detected and handled missing data, removed outliers using the IQR method, and visualized patterns with boxplots and other EDA techniques.
The project uncovers insights into pricing trends, availability, and neighborhood dynamics.

Wine Quality
Prediction Project

Wine Quality Prediction

Built a machine learning model to predict wine quality using physicochemical properties.
Applied EDA to explore correlations, cleaned and scaled data, and trained models like Logistic Regression, Random Forest, and Linear Regression.
Evaluated model performance and highlighted key factors influencing wine quality.

Get in Touch

Interested in collaborating or discussing opportunities?
Feel free to reach out via email or connect on my socials below.