Web version

Ananya Deshpande

Data Analyst (Entry-Level)

Indore, India • +91 97550 28841 • ananya.deshpande.data@gmail.com • linkedin.com/in/ananya-deshpande-data • github.com/ananyadeshpande

Portfolio: www.eliorexa.com/portfolio/data-analyst-fresher

Professional Summary

Statistics graduate who turns messy spreadsheets into decisions — fluent in SQL, Excel and Python for data cleaning, and in Power BI and Tableau for dashboards that tell a clear story. Comfortable defining KPIs, running descriptive and inferential statistics, and presenting findings to non-technical audiences. Detail-oriented and curious, with 3 published analytics projects and a competition-ranked dashboard.

Skills

Querying & data prep: SQL, Advanced Excel (Power Query, pivots), data cleaning, data validation, VLOOKUP/XLOOKUP

Visualization: Power BI, Tableau, dashboards, DAX (basics), data storytelling

Programming & stats: Python (pandas, NumPy), Matplotlib, seaborn, descriptive statistics, hypothesis testing

Workflow: Google Sheets, Jupyter, Git, KPI definition, stakeholder reporting

Core Competencies

SQL · Excel · Power BI · Tableau · Python · data cleaning · dashboards · KPIs · statistics · storytelling · Data Analyst

Work Experience

Data Analyst Intern — Marketwise Insights

Jan 2026 – Apr 2026

Remote

  • Cleaned and consolidated 14 monthly sales extracts in Python (pandas), removing ~9% duplicate and malformed rows to produce a single trusted dataset for reporting.
  • Built a Power BI sales dashboard tracking 6 KPIs (revenue, AOV, conversion, churn) that replaced a manual Excel report and saved the team ~5 hours/week.
  • Wrote 20+ SQL queries to segment customers by region and tenure, surfacing a high-churn cohort that informed a retention campaign.
  • Presented weekly findings to a 5-person marketing team, translating statistics into 3-slide stories with clear recommendations.

Projects

RetailPulse — sales analytics dashboard — 12 KPIs tracked

End-to-end Power BI dashboard over a 2-year retail transactions dataset.

  • Modeled a star schema and authored DAX measures for revenue, margin and YoY growth across 12 KPIs with drill-down by store and category.
  • Cleaned 180k rows in Python, handling missing values and outliers, then documented the pipeline so results are reproducible.

Tech: Power BI, SQL, Python, KPIs

CityAir — public health data story — Top 5 / 90 entries

Tableau analysis correlating air quality with hospital admissions.

  • Joined 3 open datasets in SQL and tested the correlation with Python (p < 0.05), then built an interactive Tableau story map.
  • Ranked top 5 (of 90 entries) in a campus data-storytelling contest for clarity of the narrative and visuals.

Tech: Tableau, Python, statistics, storytelling

Education

B.Sc. Statistics (Honours)

2025

Devi Ahilya Vishwavidyalaya, Indore

CGPA 8.5/10 · Coursework: Probability, Regression Analysis, Data Mining, Database Systems

Certifications

  • Google Data Analytics (Professional Certificate) — Coursera (2025)
  • Microsoft Certified: Power BI Data Analyst Associate (PL-300) — Microsoft (2026)