Skip to content

Latest commit

Β 

History

5 Commits

Folders and files

NameName
Last commit message
Last commit date
Β 
Β 

Repository files navigation

πŸ‘‹ Hi, I'm Devansh Gupta

πŸ“Š Aspiring Data Analyst | Excel | Python | Business Intelligence

B.Tech CSE graduate focused on building practical skills in Data Analytics, Data Visualization, and Business Analysis through hands-on projects and continuous learning.

Learning by building, testing, improving, and documenting real projects.

Profile Views

GitHub LinkedIn Instagram

GitHub Streak

πŸ‘¨β€πŸ’» About Me

  • πŸ” Transforming raw data into meaningful and actionable business insights.
  • πŸ“ˆ Hands-on experience with Microsoft Excel and interactive dashboard development.
  • 🐍 Currently strengthening my Python fundamentals for data analysis and manipulation.
  • 🧹 Interested in Data Cleaning, Data Transformation, Data Visualization, and Reporting.
  • πŸš€ Continuously improving my technical and analytical skills by working with structured datasets and business-oriented scenarios.

πŸ› οΈ Skills & Tools

πŸ“Š Data & Business Intelligence

Data Analysis Data Cleaning Data Transformation Data Visualization Business Intelligence Business Reporting

πŸ“ˆ Spreadsheets & Dashboards

Microsoft Excel Pivot Tables Pivot Charts Slicers KPI Analysis Dashboard Design

πŸ’» Programming & Databases

Python SQL

βš™οΈ Tools & Others

Git GitHub Jupyter Notebook Prompt Engineering


πŸš€ Featured Projects

πŸ₯‡ CS2 Player Performance & Tournament Analytics

Tools: Excel, PivotTables, PivotCharts, Slicers, Excel Formulas

Interactive Excel dashboard analyzing 6,000 CS2 player performance records across teams, maps, player roles, and fatigue levels.

Highlights:

  • πŸ“Š Dynamic KPI Cards
  • 🎯 Team & Role Performance Analysis
  • πŸ—ΊοΈ Map-wise Win/Loss Analysis
  • πŸ“ˆ Fatigue & Performance Analysis
  • πŸ† Dynamic Top 5 Players Table
  • πŸŽ›οΈ Interactive Slicers

πŸ”— View Project Repository


πŸ₯ˆ Indian Sports Footwear E-Commerce Sales Dashboard β€” V2

Tools: Excel, PivotTables, PivotCharts, Slicers, Formulas

Improved and interactive Excel dashboard analyzing India-focused e-commerce sales performance.

Highlights:

  • πŸ“Š Dynamic KPIs
  • πŸ’° Revenue & Product Analysis
  • 🏷️ Brand Performance
  • πŸ—ΊοΈ State-wise Analysis
  • πŸ‘₯ Customer Segmentation
  • πŸ“¦ Order Status Analysis

πŸ”— View Project Repository


πŸ₯‰ Indian Sports Footwear E-Commerce Sales Analysis β€” V1

Tools: Excel, PivotTables, PivotCharts, Slicers

Foundational Excel analytics project focused on developing practical skills in:

  • Dataset preparation
  • PivotTable analysis
  • PivotCharts
  • KPI development
  • Interactive slicers
  • Dashboard creation

πŸ”— View Project Repository


πŸ“š Currently Learning

🟒 Current Focus

Area Focus
πŸ“Š Excel Advanced Excel & Dashboarding
🐍 Python Strengthening Programming Fundamentals
🧹 Data Data Cleaning & Transformation
πŸ“ˆ Visualization Data Visualization
πŸ’Ό Analysis Business-oriented Data Analysis
πŸ› οΈ Projects Practical Project Development

Currently focusing on strengthening fundamentals through consistent hands-on practice.


πŸŽ“ Education & Training

Degree / Training Institute Duration Details
B.Tech (CSE) Shivajirao Kadam Institute of Technology & Management 2021–2025 CGPA: 7.07 / 10
Full Stack & Database Training KodNest Technologies Pvt. Ltd. Apr 2025–Dec 2025 SQL, MongoDB, Programming Fundamentals
Generative AI Prompt Engineering upGrad β€” Prompt Engineering

πŸ† Leadership & Extracurriculars

  • πŸ‘” Placement Coordinator β€” SKITM: Coordinated recruitment activities and pre-placement support logistics for 130+ students.
  • πŸ“Έ Founder β€” OASIS Photography Club: Managed team operations and digital media documentation for university events.
  • πŸ’» Core Team Member β€” SKITECH Innothon 2K24: Supported event execution and logistical workflows for a national-level hackathon.

🎯 Areas of Interest

Data Analytics Microsoft Excel Python Data Visualization Business Analysis Business Intelligence


🀝 Let's Connect & Collaborate!

Interested in Data Analytics, Excel, Python, Data Visualization, or Business Intelligence?


LinkedIn Β  GitHub Β  Instagram



πŸ“Š Learning β€’ Building β€’ Improving

Thank you for visiting my profile! πŸš€

About

Aspiring Data Analyst building practical projects in Excel, SQL and Power BI.

Resources

Stars

0 stars

Watchers

0 watching

Forks

Releases

Packages

Contributors