Afnan Khan

Data Analyst

Mumbai, Maharashtra 0+ yrs exp 80 · Excellent

About

Entry-level Data Analyst with hands-on experience in SQL, Python, Pandas, NumPy, Excel, and Power BI, built through a 3-month Data Science & Analytics internship and independent analytics projects in sales performance and customer behaviour. Skilled in data cleaning, exploratory data analysis, dashboard reporting, and translating structured data into actionable business insights.

Skills & Expertise (31)

Python Intermediate

6.5/10

0.25

Years Exp

Pandas Intermediate

6.5/10

0.25

Years Exp

NumPy Intermediate

6.5/10

0.25

Years Exp

Aggregations Intermediate

6.5/10

0.25

Years Exp

Data Cleaning Intermediate

6.5/10

0.25

Years Exp

Data Preprocessing Intermediate

6.5/10

0.25

Years Exp

Exploratory data analysis Intermediate

6.5/10

0.25

Years Exp

HAVING Intermediate

6.5/10

0.25

Years Exp

GROUP BY Intermediate

6.5/10

0.25

Years Exp

WHERE Intermediate

6.5/10

0.25

Years Exp

Select Intermediate

6.5/10

0.25

Years Exp

Charts Intermediate

6.0/10

0.25

Years Exp

Pivot Tables Intermediate

6.0/10

0.25

Years Exp

Data Quality Analysis Intermediate

6.0/10

0.25

Years Exp

Trend Analysis Intermediate

6.0/10

0.25

Years Exp

Excel Intermediate

6.0/10

0.25

Years Exp

SQL Intermediate

5.5/10

0.25

Years Exp

Interactive Reports Intermediate

5.0/10

0.25

Years Exp

KPI Reporting Intermediate

5.0/10

0.25

Years Exp

Data Visualization Intermediate

5.0/10

0.25

Years Exp

Dashboard Reporting Intermediate

5.0/10

0.25

Years Exp

Power BI Intermediate

5.0/10

0.25

Years Exp

Insight Generation Intermediate

5.0/10

0.25

Years Exp

Business Analysis Intermediate

5.0/10

0.25

Years Exp

Joins Beginner

4.0/10

0.25

Years Exp

Subqueries Beginner

4.0/10

0.25

Years Exp

CTEs Beginner

4.0/10

0.25

Years Exp

Window Functions Beginner

4.0/10

0.25

Years Exp

LAG Beginner

4.0/10

0.25

Years Exp

RANK Beginner

4.0/10

0.25

Years Exp

DENSE_RANK Beginner

4.0/10

0.25

Years Exp

Work Experience

Data Science & Analytics Intern

The Developer Arena

Jan 2026 - Mar 2026

Performed data cleaning and preprocessing on structured datasets using Python, Pandas, and NumPy to prepare them for analysis. Conducted exploratory data analysis (EDA) to identify trends, patterns, and actionable business insights. Analyzed datasets in Excel using Pivot Tables and charts to support business-focused reporting. Resolved data-quality issues, including missing values, duplicate records, and inconsistent formats, to improve dataset usability.