Khanak Gupta

Data Analyst (Fresher)

Kanpur, Uttar Pradesh 0+ yrs exp 70 · Very Good

About

Data Analyst (Fresher) with hands-on experience in SQL, PostgreSQL, Python, Power BI, DAX, Advanced Excel, Azure Databricks, and Apache Spark. Reduced manual reporting effort by 30% through Power BI dashboard automation during a Data Analyst internship. Experienced in data cleaning, exploratory data analysis (EDA), ETL pipelines, dashboard development, KPI reporting, and business intelligence, with a strong ability to transform raw data into actionable business insights.

Skills & Expertise (17)

Advanced Excel Intermediate

6.0/10

0.25

Years Exp

Power Query Intermediate

6.0/10

0.25

Years Exp

Data Cleaning Intermediate

6.0/10

0.25

Years Exp

Exploratory data analysis Intermediate

6.0/10

0.25

Years Exp

Data Visualization Intermediate

6.0/10

0.25

Years Exp

Business Intelligence Intermediate

5.0/10

0.25

Years Exp

Postgresql Intermediate

5.0/10

0.25

Years Exp

Statistical Analysis Intermediate

5.0/10

0.25

Years Exp

Data Modeling Intermediate

5.0/10

0.25

Years Exp

KPI Reporting Intermediate

5.0/10

0.25

Years Exp

GitHub Intermediate

5.0/10

0.25

Years Exp

Jupyter Notebook Intermediate

5.0/10

0.25

Years Exp

DAX Intermediate

4.0/10

0.25

Years Exp

ChatGPT Beginner

4.0/10

GitHub Copilot Beginner

3.5/10

Azure Databricks Beginner

3.0/10

Apache Spark Beginner

3.0/10

Work Experience

Data Analyst Intern

Anasuya Shakti Private Limited

Jul 2025 - Sep 2025

Cleaned and processed business datasets of 5,000+ records using SQL, Advanced Excel, and Power Query; conducted EDA to uncover trends and improve data accuracy for reporting. Automated Power BI dashboards tracking 10+ key business KPIs using DAX and Power Query, reducing manual reporting time by 30%.