Tanya Khurana

About

Aspiring Data Analyst with academic project experience in SQL, Excel, and Power BI. Focused on data cleaning, dashboard creation, KPI analysis, and generating actionable business insights.

Education

• 2027
  M.A. Economics

  Delhi Technological University

  Economics · 2025 – 2027

  Economics · 2025 – 2027
• 2025 SL
  B.COM

  Shyam Lal College

  Awarded by University of Delhi

  2021 – 2025

  2021 – 2025
• 2021 MS
  High School

  St. Mary's School, Hisar

  2021 – 2021

  2021 – 2021

Skills

Tools / apps / platforms

Projects

• TATA Data Visualisation ↗
  Power BI

  Built an interactive Power BI dashboard to process business data, analyze market trends, and deliver strategic recommendations.

• Zepto Sales & Market Analysis ↗
  Excel, SQL, Pivot Tables

  Cleaned sales datasets, executed SQL analysis using joins, CTEs, and window functions, and created dynamic pivot tables to summarize KPIs and analyze sales metrics.

• ONDC Transaction & Network Operations Analytics ↗
  SQL, Excel, Power BI, DAX

  Analyzed 5,000+ ONDC transaction logs across 60 days to uncover funnel drop-off and fulfillment performance issues. Built a 4-page Power BI dashboard tracking conversion rate, SLA compliance, and delivery success rate.

Courses & certifications

• Tata Group Data Visualisation: Empowering Business with Effective Insights ↗ · Forage · 2026

⚽ Extracurricular activities

• Eco-Club Member

  Coordinated awareness campaigns and environmental surveys on urban waste management; managed volunteer teams for campus and community initiatives.

• Inter-College Debate Competition Participant

  Developed critical thinking, verbal communication, and presentation skills.