abhi_portfolio — bash
$
$
$
Open to Opportunities

AbhishekGupta

~$ 

Detail-oriented Data Analyst with 6+ months of experience and 12 real-world projects across Power BI, Python ML, NLP & Supply Chain Analytics.

12
Projects
8
Certificates
79%
ML Accuracy
6mo
Experience
Abhishek Gupta
12
Projects
data_analyst.py
Scroll
SQL Python Power BI Tableau Excel Machine Learning Data Visualization ETL Pipelines NLP Pandas & NumPy SQL Python Power BI Tableau Machine Learning Data Visualization ETL Pipelines NLP Pandas & NumPy
About Me

Who I Am

Passionate about turning raw data into meaningful business decisions.

Turning Data Into Decisions

I am a results-driven Data Analyst with 6 months of professional experience at IARDO, working on real-world business data using SQL, Python, and Power BI to drive strategic decisions.

Currently pursuing B.Tech in Computer Science at CCS University, Meerut. With 12 projects spanning Power BI dashboards, Python ML models, and NLP classifiers — each project tells a data story.

Data AnalyticsMachine LearningPower BI NLPBusiness IntelligenceETL
Name
Abhishek Gupta
Location
Delhi, India
Phone
+91 6307647757
Degree
B.Tech CS (2022–26)
Experience
6 Months ✓
12
Projects
5
Certifications
79%
ML Accuracy
40%
Time Saved
Open to Full-time & Freelance
Technical Skills

My Expertise

Tools and technologies I use to extract insights and build data solutions.

SQL & Databases

Complex queries, joins, aggregations, data extraction & transformation.

Advanced SQL90%
ETL Processes85%
Data Modeling80%
Python & ML

Pandas, NumPy, Scikit-learn for modeling & machine learning pipelines.

Python / Pandas88%
Scikit-learn / ML82%
NLP / TF-IDF78%
Power BI & Tableau

DAX, interactive dashboards, drill-downs & KPI tracking.

Power BI / DAX92%
Tableau80%
Google Data Studio75%
Excel & Reporting

VLOOKUP, Pivot Tables, VBA macros & automated reporting.

Excel / VBA88%
Report Automation85%
Dashboard Design90%
Statistical Analysis

Regression, classification, clustering & feature engineering.

Predictive Modeling82%
EDA & Insights90%
Feature Engineering80%
Programming & Tools

Java, C, Git, VS Code & Jupyter with strong CS fundamentals.

Java / C75%
Git & GitHub80%
Jupyter Notebook90%
Projects

All 12 Projects

Real-world data analytics, BI dashboards, ML models & NLP classifiers — all on GitHub.

🏏ML Model
PythonScikit-learnPandasMatplotlib
IPL Match Prediction Model

ML model predicting IPL match outcomes with 79% accuracy using Logistic Regression & Random Forest on historical match data.

  • 79% accuracy using ensemble methods
  • Feature engineering & data cleaning with Pandas
  • Visualizations with Matplotlib & Seaborn
🚀Dashboard
Power BIDAXData Viz
Chandrayaan Mission Analytics

Interactive Power BI dashboard analyzing 65+ years of lunar missions (1958–2023), highlighting Chandrayaan-3's south pole landing.

  • 65+ years of NASA & ISRO mission data
  • DAX calculations & comparative trend analysis
  • Mission success rate by agency & year
🏨BI Dashboard
Power BIBusiness IntelligenceKPI
Hospitality Domain Dashboard

Comprehensive BI dashboard tracking occupancy rate, ADR, RevPAR & customer satisfaction with drill-down capabilities.

  • KPI tracking: Occupancy, ADR, RevPAR
  • Drill-down by property, time & segment
  • Interactive filters for stakeholders
📞Dashboard
Power BICustomer AnalyticsKPI
Customer Retention Dashboard

Call center performance dashboard tracking 5000+ calls, agent activity, resolution rates & customer satisfaction ratings.

  • 5000+ calls handled across multiple agents
  • Resolution rate & satisfaction score tracking
  • Response time & agent performance metrics
🌍HR Analytics
Power BIDAXHR Analytics
Diversity & Inclusion Dashboard

Power BI dashboard analyzing gender representation, promotions, performance ratings & workforce diversity across departments.

  • Gender & nationality representation analysis
  • Promotion & performance tracking by fiscal year
  • Turnover rate & tenure insights for HR planning
📊Dashboard
Power BICall AnalyticsDAX
Call Centre Solution

Interactive Power BI dashboard tracking call center KPIs — customer satisfaction, answered vs abandoned calls, peak hours & agent performance.

  • Peak call hours & speed-of-answer analysis
  • Agent performance identification & benchmarking
  • Live data filtering with dynamic slicers
🛒Dashboard
Power BIE-commerceSales Analytics
Flipkart E-Commerce Dashboard

Flipkart sales performance dashboard with monthly profit trends, payment mode analysis, state-wise distribution & top customer insights.

  • Monthly profit & sub-category breakdown
  • Payment mode & state-wise sales distribution
  • Quarterly performance indicators & ADV metrics
👥HR Analytics
Power BIHR AnalyticsAttrition
HR Analytics Dashboard

Comprehensive HR dashboard analyzing employee attrition by education, age, salary slab, job role & years at company across departments.

  • Attrition rate analysis across HR, R&D & Sales
  • Salary distribution by job role & demographics
  • Data-driven HR decision support visualizations
📦Dashboard
Power BIGlobal SalesBusiness Analytics
Amazon Global Sales Dashboard

Amazon global sales dashboard covering 2012–2014 with segment analysis, market distribution across Africa, Asia Pacific & Europe.

  • Year-wise sales & KPI projections (2012–14)
  • Top/bottom products by profit analysis
  • Regional heat map & customer profitability
📱NLP / ML
PythonNLPScikit-learnTF-IDF
SMS Spam Classifier

NLP-based spam detection system classifying SMS messages using TF-IDF vectorization with multiple ML models compared for accuracy.

  • Logistic Regression, Naive Bayes, SVM & Random Forest
  • TF-IDF feature extraction with NLTK stopwords
  • Text cleaning: lowercase, special chars, stopwords removal
ML / Classification
PythonRandom ForestFeature Engineering
Titanic Survival Prediction

Titanic survival classification using Random Forest Classifier on Kaggle dataset with feature engineering and model evaluation.

  • Random Forest Classifier on Kaggle Titanic dataset
  • Feature engineering from age, sex, class, embarked
  • Full pipeline: EDA → engineering → training → prediction
🚚AI Pipeline
PythonN8NSupabaseQuadratic AIPostgreSQL
Atlique Mart — Supply Chain Analytics

End-to-end supply chain analytics pipeline for a Gujarat-based FMCG company analyzing 24,195 order lines across March–May 2025, with automated KPI reporting.

  • OTIF: 47.84% vs 90–95% benchmark — critical insight found
  • N8N workflow auto-ingests Gmail CSVs → Supabase PostgreSQL
  • Quadratic AI for KPI calculation + Python/openpyxl Excel report
Journey

Experience & Education

My story — from classroom to real-world data impact.

Work Experience
Data Analyst Completed
IARDO
Sep 2024 – Mar 2025Delhi, India

Analyzed business data using Excel, SQL, and Python to generate actionable insights. Developed automated reporting systems reducing manual time by 40%. Performed ETL operations ensuring data quality for analytics.

SQLPythonExcelPower BIETL
Data Science Intern Completed
Internshala × IITM Partnership
Jan 2025 – Apr 2025Remote

Built predictive models using regression, classification, and clustering achieving 79% accuracy. Conducted EDA & feature engineering, presenting findings through visualizations and statistical reports.

Scikit-learnEDAFeature Eng.Regression
Education & Certifications
B.Tech — Computer Science
CCS University, Meerut
2022 – 2026Pursuing
Specializing in CS with focus on data structures, algorithms, ML and software engineering.
Intermediate — Science
SBD Sen. Sec School, Kushinagar
2020 – 2022Completed
Strong foundation in Mathematics, Physics, and Computer Science.
Certifications
Career Essentials in Data Analysis
Microsoft & LinkedIn · Jan 2025
Data Science Training
Internshala & IITM · Jan 2025
Power BI Certification
Forage · Feb 2025
Data Analysis
Deloitte · Jan 2025
Master Data Management
TCS iON · Jan 2025
Get In Touch

Let's Connect

Open to full-time Data Analyst roles, freelance projects, and collaborations. Let's turn data into decisions together.

Delhi, India — Remote Friendly
Certifications

My Certificates

8 verified certifications — click any to view full size.

Power BI Job Simulation
View
Feb 2025
Power BI Job Simulation
PwC / Forage
Data Analytics Job Simulation
View
Feb 2025
Data Analytics Job Simulation
Deloitte / Forage
Foundations of AI
View
Apr 2025
Foundations of AI
Microsoft / AICTE / Edunet
Career Essentials in Data Analysis
View
Jan 2025
Career Essentials in Data Analysis
Microsoft / LinkedIn Learning
Master Data Management
View
Jan 2025
Master Data Management
TCS iON
Data Science Course
View
Feb 2025
Data Science Course
Internshala / Skill India / NSDC
Internship and Job Preparation
View
Apr 2025
Internship and Job Preparation
Internshala Trainings
Learning Data Analytics Foundations
View
Jan 2025
Learning Data Analytics Foundations
LinkedIn Learning