Akshat Pandey

Data Analyst

Prayagraj 0+ yrs exp 71 · Very Good

About

No bio added yet

Skills & Expertise (15)

Python Intermediate

5.5/10

Years Exp

SQL Intermediate

5.5/10

Years Exp

Microsoft Excel Intermediate

5.0/10

Years Exp

Data Cleaning Intermediate

5.0/10

Years Exp

Exploratory data analysis Intermediate

5.0/10

Years Exp

Data-driven decision making Intermediate

5.0/10

Years Exp

Power BI Beginner

4.5/10

Years Exp

Google Sheets Beginner

4.0/10

Years Exp

Tableau Beginner

4.0/10

Years Exp

Google Analytics Beginner

4.0/10

Years Exp

A/B testing Beginner

4.0/10

Years Exp

Hypothesis Testing Beginner

4.0/10

Years Exp

Root Cause Analysis Beginner

4.0/10

Years Exp

Stakeholder Management Beginner

4.0/10

Years Exp

Requirement gathering Beginner

4.0/10

Years Exp

Work Experience

Data Analyst Intern

Unified Mentor Pvt. Ltd.

Jun 2025 - Aug 2025

Queried and transformed learner data using SQL & Python (pandas), performed EDA, and built dashboards with engineered KPIs such as engagement score & completion rate to enable real-time tracking. Identified dropout spike in weeks 3–4, enabling targeted interventions to improve retention by 10–15%; automated reporting reduced manual effort by 70% and improved decision-making speed.

SEO Analyst (Freelance)

Ditto Insurance

Dec 2024 - Jan 2025

Analyzed 3-month data using Excel & SQL, built traffic-to-potential and MoM growth metrics, segmenting pages into clusters, enabling trend tracking. Designed data-driven backlink outreach strategy. Prioritized 40% pages for optimization, enabling targeted SEO actions and improving growth visibility. Identified 50+ high-DA backlink opportunities, driving a projected 25–35% uplift in organic traffic.