Gajendra Singh | Data Science Student Portfolio

PostgreSQL 16.2

WITH CareerPath AS (

SELECT name, skill, proficiency

FROM analytics_students

WHERE id = 'Gajendra_Singh'

)

SELECT skill, proficiency

FROM CareerPath

ORDER BY proficiency DESC;

-- Status: Learning SQL, practicing daily

-- Focus: Clean logic, performance-aware queries

Tech Stack

Database

MySQL PostgreSQL

I finished some basic MySQL and PostgreSQL courses online. Now I'm trying to practice more complex queries and getting comfortable with joins and subqueries.

Languages

Python Pandas NumPy Scikit-learn

I know some Python basics from college courses. I haven't really used Pandas or NumPy much yet, but I'm planning to learn them soon. Same with scikit-learn for machine learning.

Visualization

Tableau Power BI Matplotlib

I haven't really started with visualization tools yet. I've downloaded Tableau and Power BI but haven't made anything with them. This is definitely on my to-learn list after I get better at SQL.

Tools

Excel Git Jupyter

I use Excel for simple data stuff. I know basic Git commands (commit, push, pull) but I'm still learning. I use Jupyter notebooks for Python practice.

Portfolio Hub

learning by doing

Learning Portfolio; Building in Public

As a Data Science student, I’m building small, hands-on projects while learning SQL and data analysis. This space will grow over time with practice work, dashboards, and analysis exercises as I progress.

Portfolio Progress

25%

Current Learning Projects

In Progress SQL #P1

SQL Data Exploration

This is my first real SQL project! I'm using some sample datasets to practice basic queries like SELECT, WHERE, GROUP BY, and simple aggregations. I'm learning how to filter data and find basic patterns. It's pretty basic stuff, but I'm getting better at writing queries and understanding how data analysts think about questions.

Database Schema Setup

CRUD Operation practice

Complex Joins implementation

SQL MySQL

Planned SQL #P2

SQL Data Cleaning

I haven't started this one yet, but I'm planning to work on it soon. I want to learn how to clean messy data using SQL - things like handling missing values, removing duplicates, and fixing data types. I heard that real-world data is always messy, so I should learn how to deal with that. This will be my next project after I finish my current SQL exploration project.

Data Cleaning Basics

Handling Missing Values

Removing Duplicates

Preparing Analysis-Ready Data

SQL MySQL Data Cleaning

Major Projects

Still Learning the Basics

I'm still working on getting good at SQL and understanding statistics better. I don't have any major projects to show yet - I'm focusing on learning the fundamentals first. Once I get more comfortable with SQL and start learning visualization, I'll try to build some bigger projects. Check back later!

#AdvancedSQL #DataAnalysis

Case Studies

Case Studies (Coming Soon)

I don't have any case studies yet. I'm still learning the basics and haven't done any real-world analysis projects. Once I finish my SQL learning projects and start learning visualization, I'll try to work on some case studies. For now, I'm just focusing on getting better at the fundamentals.

#CaseStudies #RealWorldProjects

How I Approach Data Problems

This is the basic process I'm trying to follow as I learn. I'm still figuring it out, but this is what I've learned so far from tutorials and courses.

01

First, I try to understand what question I'm trying to answer. Sometimes this is the hardest part!

02

Then I use SQL to get the data I need. I'm still learning joins and subqueries, so this takes me a while sometimes.

03

I look at the results and try to find interesting patterns or insights. I'm still learning what to look for.

04

Finally, I try to explain what I found. I haven't learned visualization tools yet, so I usually just write about it or make simple tables.

Where I'm At Right Now

SQL & Data WranglingStill Learning

I know basics, working on advanced stuff

StatisticsFoundational

Learning from college courses

VisualizationHaven't started

Planning to learn Tableau/Power BI

Python for Datajust started

Know basics, need to learn Pandas, NumPy

Education

Academic foundations in data and technology

UG

Bachelor's in Data Science & AI

Indian Institute of Technology Madras (IIT Madras)

2024 – 2028

Focus on Statistics, Machine Learning, SQL, and Python.

AD

Diploma in Electronics & Communication Engineering

GNDIT Rohini, BTE Delhi

2018 – 2021

Core electronics, digital communication, and signal processing.

Hey!, I'm Gajendra Singh

Turning messy data
into actionable insights.

Learning Roadmap