Data Analyst & Problem Solver

Transforming raw data into actionable insights using Python, SQL, and Power BI

Passionate about data analysis, visualization, and building efficient solutions. With expertise in Python, SQL, and business intelligence tools, I help organizations make data-driven decisions.

Rohit Kumar

About Me

Data Analysis
Proficient in Python, SQL, and MySQL for comprehensive data analysis and database management
Visualization
Expert in Power BI, Excel, and Python visualization libraries for creating impactful dashboards
ETL & Automation
Experienced with Power Query, data transformation, and process automation

Skills & Expertise

Programming
Data Analysis
BI Tools
Databases
Version Control

Data Cleaning Process

Step-by-step data cleaning methodology used in my analysis projects

1

📊Data Understanding

Check dataset size and structure, understand columns and objective

2

🔧Fix Data Types

Convert to correct formats (numeric, datetime, categorical)

3

⚠️Handle Missing Values

Identify missing data, remove or impute (mean/median/mode)

4

🗑️Remove Duplicates

Delete duplicate rows, validate unique identifiers

5

Standardize Data

Make values consistent (e.g., Male/M/male → Male)

6

📝Fix Formatting Issues

Remove extra spaces, clean text formatting

7

🎯Handle Outliers

Detect extreme values, remove or cap if needed

8

Validate Data

Recheck missing values, confirm data types, ensure no duplicates

Get In Touch

Interested in collaborating or have a question? Feel free to reach out through any of these channels.