Projects About Skills Education Contact Resume ↗
Data Analyst · Noida, Delhi NCR

Numbers without
context are just
noise.

I build dashboards, reports, and analyses that tell a business what to do next — not just what happened. B.Tech CSE · SQL · Python · Power BI · Excel · 5 end-to-end projects.

0
Projects Built
0
Certifications
0
Business Domains
100k+
Rows Analysed
Download Resume ↗ GitHub ↗ LinkedIn ↗
Core Stack
Python SQL Excel Power BI Pandas DAX Dashboarding KPI Reporting EDA Data Cleaning
Jyoti Gupta
Open to opportunities
Location
Greater Noida / Noida · Remote OK
Seeking Roles
Data Analyst BI Analyst MIS Analyst Reporting Analyst Business Analyst
Open To Work In
Noida · Gurgaon · Delhi · Mumbai · Remote · Hybrid
Contact
guptajyoti10898@gmail.com
00

What I Actually Bring

01 — Analysis
Business-First Thinking
I don't just query databases — I ask what decision the business needs to make, then build the analysis backward from that. Every chart I build has a "so what." Five complete projects demonstrate this, not just certifications.
02 — Execution
End-to-End Delivery
Raw CSV to boardroom-ready dashboard — I handle data cleaning, transformation, modelling, and visualization. B.Tech CSE gives me the technical foundation; training at DUCAT Noida gave me the applied analytics toolkit.
03 — Discipline
Structured Execution
Defence preparation built habits most professionals spend careers developing: structured thinking under pressure and consistent delivery. A design background means dashboards people actually read.
01

Featured Projects

Superstore Excel · Business Analysis
Superstore Sales & Profit Analysis
↑ Top loss-making categories found across 9,994 orders
End-to-end Excel dashboard with Pivot Tables, KPI cards, and slicers. Key finding: Furniture generates high revenue but lowest margin in specific regions — actionable for pricing strategy.
View on GitHub →
 IPL Analysis SQL · Power BI
IPL Data Analysis
→ Toss-to-win correlation by venue across 1,000+ matches
MySQL + Power BI analysis of IPL match history. Toss winners field 60%+ of the time — but win rate correlation varies dramatically by venue. Nuanced insight beyond surface stats.
View on GitHub →
 Power BI Dashboard Power BI · DAX
Store Sales Power BI Dashboard
→ Executive KPI system — key answers in under 30 seconds
DAX measures, drill-through pages, dynamic filters, and full data modelling. Designed for a manager who needs answers fast — not someone who wants to explore raw data.
View on GitHub →
 Pizza Sales Python · Pandas · Matplotlib
Pizza Sales Analysis
↑ Revenue peak hours & low-value SKUs identified
Full Python EDA. Went beyond "best sellers" to find items that look popular by count but drag revenue per hour — the kind of insight that changes a menu, not just confirms one.
View on GitHub →
 Vrinda Store Excel · Dashboard
Vrinda Store Dashboard
→ Highest revenue channel ≠ highest order channel
Dynamic Excel dashboard with Pivot Tables and slicers. Answers a critical strategic question: which channel brings the most revenue vs. most orders — two different answers.
View on GitHub →
02

About Me

2017 – 2021
B.Tech CSE — Accurate Institute, Greater Noida
Core coursework: DBMS, Data Mining, Machine Learning, Algorithms, Statistics. Event coordinator for 6+ large-scale campus events across 3 years.
2019 – 2021
Co-Founded Drishti NGO
Led 20+ volunteers in donation drives and education sessions for underprivileged children. First real experience owning outcomes with no formal support structure.
Aug – Nov 2021
Web Development Intern — Axes Geeks India
Built responsive websites and client-focused digital assets. Improved page load performance through code optimisation. Built early instinct for user requirements.
2022 – 2024
Defence Examination Preparation
Developed discipline, consistency, and structured thinking under pressure — qualities I now apply directly to analytical work.
2023 – 2024
Freelance Design Projects
Logo design, branding, and social media creatives. Trained an eye for clear visual communication — useful for every dashboard built since.
2024 – Present
Data Analytics Training — DUCAT, Noida
Advanced training in SQL, Excel, Power BI, Python, and EDA. Five end-to-end analytics projects on GitHub.

I'm Jyoti Gupta, a data analyst who builds reports and dashboards that support real business decisions. B.Tech in Computer Science from Accurate Institute, Greater Noida (2021).

My background is unconventional. Defence prep gave me structure. Freelance design taught me visual communication. Web dev gave me technical thinking. Analytics training brought it together. Open to remote, hybrid, and onsite analyst opportunities across India.

Looking for a team that wants an analyst who asks "so what does this mean for the business?" before writing a single query.

Business-First Analysis
Every project starts with a business question, not a dataset.
Disciplined Delivery
Defence-trained habits: structured thinking, on time, no excuses.
Clear Communication
Design background means dashboards people actually read.
Fast Learner
Taught myself five tools in under a year. Give me a new one.
Certifications
📊
PwC Power BI Experience
Forage
 🔷
Accenture Data Analytics
Forage
 🟠
Tata Data Visualisation
Forage
 🔵
Career Essentials in Data Analysis
Microsoft & LinkedIn Learning
 🟩
SQL Certificate
HackerRank
 🐍
Data Analytics Using Python
DUCAT Institute, Noida
03

Skills & Tools

Python
Pandas · NumPy · Matplotlib · EDA · Automation
SQL
MySQL · Joins · CTEs · Window Functions · ER Modelling
Excel
Pivot Tables · VLOOKUP · XLOOKUP · Charts · Dashboards · Cleaning
Power BI
DAX · Power Query · KPI Cards · Drill-Through · Data Modelling
EDA & Analysis
Exploratory Analysis · KPI Identification · Data Cleaning · Statistical Analysis
Data Visualization
Dashboard UX · Chart Selection · Storytelling · Business Reports
Business Reporting
MIS Reports · KPI Tracking · Requirements Analysis · ETL Basics
Other Tools
GitHub · MS PowerPoint · HTML/CSS/JS · Agile Basics
04

Education & Training

B.Tech — Computer Science & Engineering
2017 – 2021
Accurate Institute of Management and Technology, Greater Noida, UP
Relevant: DBMS · Data Mining · Machine Learning · Algorithms · Statistics
Campus Leadership
Event Coordinator — Tech Fest, Annual Fest, Women's Day, Teachers' Day, Freshers' Night, International Conference Day. 6+ large-scale events across 3 years.
Technical Activities
Poster Presentation at AKTU, Lucknow. Technical Hunt competition participant. Active in technical and cultural activities throughout college.
Advanced Data Analytics Training
Dec 2024 – Jul 2025
DUCAT Institute of IT Training, Noida
SQL · Python · Power BI · Excel · EDA · Business Analytics · Project-Based
Outcome
5 end-to-end analytics projects built and deployed on GitHub. Hands-on with real business datasets across retail, sports, and e-commerce domains.
Virtual Experience
Forage simulations with Accenture, PwC, and Tata — simulating real analyst workflows: data cleaning, stakeholder reporting, Power BI dashboards, and insight communication.
05

Volunteering

Drishti — Co-Founder & Team Lead
2019 – 2021 · Greater Noida · "The Youth Reaching the Needy"
Co-founded a student-led community initiative during college. Led 20+ volunteers across donation drives, weekend education sessions for underprivileged children, and awareness campaigns. Managed event logistics, social media, and all outreach design. First real experience owning outcomes for a team with no formal resources.
Community Leadership Event Management Team Coordination Social Media Graphic Design Education
06

Get in Touch

Available for Data Analyst, MIS Analyst, BI Analyst, Business Analyst, and reporting-focused roles — in Noida, Gurgaon, Delhi, Mumbai, or remote. If you're looking for an analyst who focuses on business impact, let's connect.

✉️ guptajyoti10898@gmail.com Email 💼 linkedin.com/in/jyoti-gupta-- LinkedIn 🐙 github.com/gupta-jyoti GitHub 📒 kaggle.com/jyotigupta09 Kaggle
Send a message
Open to analyst roles, collaborations, and project discussions.