About Skills Projects Journey Contact
Available for Internship · India

Abhyudaya Singh Panwar

Data Analyst Data Science Student Power BI Developer SQL & Python Enthusiast Operations Analyst Product Analyst BI Analyst

Turning raw data into meaningful insights and smarter business decisions. Passionate about transforming complex datasets into clear, actionable stories.

Overview

I'm a B.Tech Computer Science student specializing in Data Science & Analytics at JECRC University, Jaipur — 3rd year in, GPA of 8.78, and genuinely obsessed with the moment a messy dataset suddenly makes sense. Give me noisy data and a question that matters — I'll find the signal, build the dashboard, and make the model generalise.

I've worked hands-on with Python, SQL, Power BI, and statistical analysis — not just academically, but on real problems: customer segmentation that actually informed targeting, sales forecasting with measurable accuracy, and churn prediction pipelines built end-to-end. Clean pipelines, honest analysis, outputs that non-technical people can act on — that's the bar I hold myself to.

When I'm not in the IDE — I'm on the ground as an NSS volunteer, behind the scenes at the Jaipur Literature Festival, or in the room at diplomacy summits. I show up. Every time.

9.33
Latest Semester GPA
50K+
Records Analyzed
3+
Dashboard Projects
12+
Certifications
Abhyudaya Singh Panwar
🟢 Open to Internships
9.33
GPA / 10
50K+
Records Analyzed
Power BI
Dashboard Expert
Tools & Stack
Python SQL Power BI Advanced Excel NumPy Pandas

Credentials & Learning

Continuous upskilling through industry-recognised programs.

Technical Arsenal

A versatile set of tools and technologies powering data-driven work.

Programming
Python90%
SQL Scripting85%
R72%
C / C++60%
OOP Concepts78%
Data Analysis
SQL88%
Pandas & NumPy87%
Advanced Excel82%
Power BI78%
Feature Engineering76%
Data Science & ML
Regression & Classification85%
Machine Learning82%
Predictive Analytics80%
K-Means Clustering76%
Neural Networks70%
Visualization
Matplotlib & Seaborn85%
KPI Dashboards80%
Power BI DAX76%
Plotly78%
Databases
MySQL / PostgreSQL84%
Window Functions80%
ETL Pipelines72%
Data Modeling75%
Statistics & Math
Descriptive Statistics90%
Correlation & Regression85%
Inferential Statistics82%
Hypothesis Testing80%
Probability Theory78%

What I Deliver

End-to-end data solutions that drive clarity and confident decisions.

📊
Excel Dashboard Creation
Dynamic dashboards with KPIs and business reporting that give stakeholders instant clarity.
Power BI Dashboards
Interactive dashboards with real-time decision insights, drill-throughs, and advanced DAX measures.
🗄️
SQL Reporting
Database querying, reporting pipelines, and performance insights optimized for scale.
📈
Sales Data Analysis
Revenue trends, product performance, seasonal forecasting, and market analysis at depth.
🧹
Data Cleaning & Formatting
Transforming messy raw data into clean, structured, and analysis-ready formats.
🤖
Predictive Analytics
Building ML models and statistical analyses to forecast trends and surface hidden patterns.

Featured Projects

Real-world analytical work delivering measurable business impact.

01
ExcelSQLPower BI
Sales Performance Dashboard
End-to-end sales analytics on 50K+ records — revenue trends, seasonal forecasting, and region-wise KPI tracking in a single Power BI dashboard.
🔍 Detected 15% revenue drop in Q3 → pricing optimization

View Case Study →
02
ExcelSQL
AtliQ Hardware — Sales & Finance Analytics
Customer performance reporting uncovering revenue growth trends, top-performing segments, and underperforming markets.

View Case Study →
03
Power BIExcel
Market Performance vs Target
Strategic gap analysis comparing actual market sales against targets — surfacing per-region shortfalls with actionable recommendations.

View Case Study →
04
PythonPandasScikit-learnMatplotlib
Customer Segmentation Analysis
K-Means clustering on RFM data to segment customers by purchasing behaviour — enabling precision-targeted marketing strategies.
🎯 Applied ML for real business targeting

View Case Study →
05
PythonXGBoostPandasSHAP
Employee Churn Prediction Model
Built an end-to-end churn prediction pipeline using XGBoost on HR dataset with 15K+ records. Used SHAP values to explain feature importance and delivered actionable retention strategies to stakeholders.
📉 84% accuracy — reduced predicted churn by 22%

View Case Study →
06
SQLPower BIPython
E-Commerce Operations Intelligence Hub
Designed a multi-page Power BI report ingesting order, logistics, and return data from a PostgreSQL warehouse. Automated daily refresh via Python ETL scripts, cutting manual reporting time by 4 hours/week.

View Case Study →
07
PythonNLPTransformersStreamlit
Sentiment Analyzer for Product Reviews
NLP pipeline using a fine-tuned BERT model to classify 100K+ Amazon product reviews as positive, neutral, or negative. Deployed as an interactive Streamlit web app for real-time sentiment scoring.
⚡ 91% classification accuracy on test set

View Case Study →

My Story — Left to Right

Where I studied, where I worked, and everything in between.

// education
Academic Journey
// experience & exposure
Experience & Exposure
2023 – 2027
B.Tech — Computer Science (DS/DA)
JECRC University, Jaipur
Coursework
Highlights
Innov8 Hackathon · Smart India Hackathon · JDS Summit · G20+1 Symposium · NSS Volunteer since 2023
🎓 GPA: 9.33 / 10
2020 – 2022
Senior Secondary (Class 12) — CBSE
St. Xavier's School, Nevta, Jaipur
2020
Secondary (Class 10) — CBSE
St. Xavier's School, Nevta, Jaipur
Jun 2025 – Jul 2025
Data Analysis Intern
Samatrix Consulting Pvt. Ltd.
📍 Remote
Worked on real-world data analysis tasks — cleaning and transforming datasets, building analytical reports, and deriving actionable insights using Python and Excel.
Python Excel Data Cleaning Reporting
Volunteering
2023 – Present
Student Volunteer — NSS
JECRC University, Jaipur
Active contributor to National Service Scheme initiatives, driving community programs, campus events, and social outreach activities.
LeadershipTeamworkCommunity
Jan 2024
Friends of the Festival — Teamwork Arts
Jaipur Literature Festival 2024
Coordinated across departments at one of the world's largest literary events, managing logistics and audience experience.
Event CoordinationCommunication
Jan 2025
Social Media Department — Teamwork Arts
Jaipur Literature Festival 2025
Managed social media content and digital communications for JLF 2025, coordinating real-time updates and engaging a global audience.
Social MediaContent Strategy
Open to Opportunities

Currently Seeking
Internship Opportunities

Looking to contribute to data-driven teams, build real-world impact, and grow in analytics & BI roles.

Data Analytics Intern
Business Intelligence Intern
SQL Reporting Intern
Data Science Intern
Let's Connect →

Get in Touch

Whether it's an internship opportunity or a project — I'd love to hear from you.