DEL17:38:51
···12:08:51
00:00
X0.0000
Y0.0000
Turning raw data into meaningful insights that drive better decisions.

Deepanshu

Role

Aspiring Data Analyst

Focus

Data Analytics → Data Science
Jun 2024 – Present

Building • Learning • Growing
Deepanshu
PYTHON • SQL • DATA ANALYTICSPANDAS • POWER BI • FASTAPI
Scroll
About

Data is Easy. Finding the story isn't.

Learning with purpose. Building with data.

I am a B.Tech Computer Science student with a strong interest in Data Analytics and a long-term goal of becoming a Data Scientist. My journey began with programming and web development, but over time I discovered that I enjoy working with data, uncovering patterns, and solving real-world problems through analysis. To build a solid foundation, I focused on Python, SQL, Pandas, NumPy, Matplotlib, Excel, Power BI, and Streamlit while strengthening my problem-solving ability by solving 200+ Data Structures & Algorithms questions. This combination has helped me develop both analytical thinking and efficient coding skills.

I believe the best way to learn is by building. That's why I have created projects such as Netflix Data Analysis, Student Result Analysis, Smart College Bus Route Optimization, and other data-driven applications. Alongside my projects, I am currently advancing my SQL skills by solving practical database challenges and learning FastAPI to build scalable backend APIs for data-driven applications.

My next step is to explore Power BI more deeply and build interactive dashboards that transform raw data into meaningful business insights. My goal is to become a Data Analyst who not only analyzes data but also builds practical solutions that create real-world impact, while continuously progressing toward Data Science.

Data Analytics

Raw data rarely has value on its own. The real work begins with asking the right questions, uncovering patterns, and turning information into decisions people can trust.

Thinking Before Coding

Writing code is easy. Building the right solution isn't. Solving 200+ DSA problems taught me to analyze problems first and optimize before implementation.

Always Building

Every new concept becomes a project. From data analysis to backend APIs, I prefer building practical solutions over simply completing another course.

What I Focus On

- Building solutions that solve real problems, not just showcase technology.

- Learning by creating projects, not collecting certificates.

- Growing through consistency, curiosity, and continuous improvement.

• Journey & Milestones •
Google Data Analytics
2026
Professional Certificate • Coursera
200+ DSA Problems
2025
Coding Blocks • C++
Netflix Data Analysis
2026
Python • Pandas • Matplotlib
Smart Bus Route Optimizer
2026
Major Project • FastAPI • SQL
Advanced SQL
2026
Database Design & Queries
Streamlit Apps
2026
Interactive Data Applications
Open to Internships
Now
Data Analyst • Summer 2026
Google Data Analytics
2026
Professional Certificate • Coursera
200+ DSA Problems
2025
Coding Blocks • C++
Netflix Data Analysis
2026
Python • Pandas • Matplotlib
Smart Bus Route Optimizer
2026
Major Project • FastAPI • SQL
Advanced SQL
2026
Database Design & Queries
Streamlit Apps
2026
Interactive Data Applications
Open to Internships
Now
Data Analyst • Summer 2026
LEARNING TIMELINE

Growth Through Practice.

2023
2024
2025
2026
2027
Web Development Journey2023– 2025
Self Learning
Explored HTML, CSS, JavaScript, React, Vite, and Tailwind CSS
Built and customized portfolio-style projects to understand UI structure and components
DSA & Problem Solving2025
Coding Blocks
Solved 200+ Data Structures & Algorithms problems
Completed DSA in C++ with focus on logic building and optimization
Scored 92% and earned Certificate of Excellence
Advanced SQL & FastAPIAug 2026 – Present
Currently Learning
Currently advancing SQL skills through practical database challenges and query-based exercises
Learning FastAPI to build backend APIs for data-driven applications
Preparing to explore Power BI more deeply for dashboards and business intelligence projects
B.Tech Computer Science2023 – 2026
PDM Institute of Technology
Building foundations in programming, DBMS, operating systems, computer networks, and software development
Focused on Data Analytics with a long-term goal of moving toward Data Science
Strengthening practical skills through projects, certifications, and hands-on learning
Data Analytics FoundationOct 2025 – Dec 2025
Python • Pandas • Matplotlib
Completed Python, NumPy, Pandas, and Matplotlib fundamentals
Built Netflix Data Analysis and Student Result Analysis projects
Google Data AnalyticsMay 2026 – Aug 2026
Coursera Professional Certificate
Learning the data analysis process: ask, prepare, process, analyze, share, and act
Building understanding of spreadsheets, SQL, data cleaning, visualization, and case-study based analysis
Projects

Practical projects, clean executions.

01Featured

Data Analytics Project

Customer Retention & Growth Analytics

An end-to-end retention analytics pipeline on e-commerce order data to identify repeat-purchase drivers, churn patterns, and campaign impact.

PythonSQLStatisticsPower BITableauStreamlit

View details ↗

02Featured

Data Analytics Project

E-Commerce Sales Analysis

An end-to-end data analytics project that transforms raw e-commerce sales data into actionable business insights using Python, SQL, Excel, Power BI, and Streamlit.

PythonSQLExcelPower BIStreamlitPandasEDA

View details ↗

03Featured

Major Project

School / College Bus & Van Route Optimization

A route optimization system for school and college transport to reduce travel time, fuel usage, and route confusion.

PythonSQLRoute OptimizationMapsDashboard

View details ↗

04Completed

Data Analytics

Real Life Netflix Visualization Project

A real-world Netflix data analysis project focused on cleaning, exploring, and visualizing content trends.

PythonPandasMatplotlibEDA

View details ↗

05Completed

Machine Learning

Air Quality Prediction

A machine learning project built to predict air quality levels using environmental data.

PythonMLPredictionData Cleaning

View details ↗

06Completed

Data Project

Capstone Project

A capstone-level project focused on applying data analysis concepts in a structured project workflow.

AnalyticsPythonVisualizationReport

View details ↗

07Completed

Python CLI

Password Manager Program

A command-line password manager built in Python with save, search, update, delete, and generate password features.

PythonCLIJSONFile Handling

View details ↗

08Collection

Python Projects

Python Small Projects

A collection of small Python projects built for practice and logic building.

PythonBeginnerLogic Building

View details ↗

09Collection

Frontend Collection

Web Development Projects

A collection of frontend clone and UI practice projects created while learning web development.

HTMLCSSJavaScriptFrontend

View details ↗

Credentials

Verified learning & achievements.

Stack

What I run in production.

Profiled under load. Not just imported.

Programming
Python(Data analysis)
SQL(Advanced SQL)
C++(DSA)
JavaScript
TypeScript
Data Analytics
Pandas
NumPy
Matplotlib
Seaborn
Excel
Databases
MySQL(SQL queries)
MongoDB(NoSQL)
Development Stack
HTML5
CSS3
Tailwind CSS
React
Node.js
Express.js
FastAPI(Currently learning)
Visualization
Streamlit(Data apps)
Power BI(Next focus)
Dashboards
Problem Solving
DSA(200+ problems)
Algorithms
Data Structures
Optimization
C++ Practice(92% score)
Tools
Git
GitHub
VS Code
Jupyter
Postman
Contact

Let's turn data into decisions 😊.

ANALYSING · BUILDING · LEARNING · ITERATING

I'm currently building real-world data analytics projects while expanding my skills in Advanced SQL and FastAPI. My focus is transforming raw data into actionable insights through analysis, visualization, and interactive dashboards. I'm always excited to collaborate on data-driven projects, internships, and opportunities where I can learn, contribute, and solve meaningful business problems.

🎨 Vision & design by Deepanshu • ⚡ Engineered with Claude Code • 🚀 Deployed on Vercel