Data Analyst · Fresher · 0 yrs
Ananya Deshpande
Data Analyst (Entry-Level)
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.
3
Analytics projects published
12
KPIs in retail dashboard
Top 5
Data-storytelling contest
Skills
Querying & data prep
Visualization
Programming & stats
Workflow
Work experience
Data Analyst Intern · Marketwise Insights
Jan 2026 – Apr 2026Remote
- 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.
Featured projects
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.
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.
Education
B.Sc. Statistics (Honours)
2025Devi 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
See the work in 3D
Explore Ananya's interactive WebGL portfolio — projects, skills and a way to get in touch.