Anushka Gupta

Anushka Gupta

Data Analyst

I craft data-driven solutions that bridge the gap between information and impact.

View Projects Download Resume

Experience

Data Analyst Intern

upGrad

May 2025 – Oct 2025 | Noida, India (Hybrid)

  • Consolidated 25K+ records using SQL and Excel, improving data accuracy and reliability by 20%.
  • Engineered automated Power BI dashboards tracking KPIs (impressions, CTR, conversions), cutting manual reporting time by 40%.
  • Implemented ETL workflows for daily data ingestion, improving stakeholder access to real-time reports.
  • Collaborated with cross-functional teams to deliver actionable insights, improving campaign efficiency by 25%.

Member of Technical Staff Intern

GeeksforGeeks

Dec 2024 – May 2025 | Noida, India (Hybrid)

  • Automated processing of 50,000+ user activity records using Python (Pandas) and SQL, identifying churn drivers and reducing user drop-off by 12%.
  • Developed SQL queries and dashboards for weekly executive reporting, accelerating insight delivery by 30%.
  • Designed repeatable data workflows and scripts that standardized KPI calculations across product teams.

Projects

HR Analytics Logo

Workforce360 - HR Attrition Analysis Dashboard

End-to-end HR Analytics project using Python, MySQL, and Power BI to analyze workforce attrition trends and design an interactive HR dashboard.

Adidas Logo

Adidas US Sales Analysis and Prediction

Analyzed 9K+ Adidas sales records to build Excel dashboards and predictive models using Python (MLR, Random Forest, XGBoost), improving sales forecast accuracy by 18%.

GeeksforGeeks Logo

GeeksforGeeks Content and YouTube Engagement Analysis

Cleaned and analyzed 2K+ YouTube videos and 34K+ articles using Pandas and NumPy, visualizing engagement trends with Matplotlib and Seaborn to improve content performance.

View on GitHub
Airbnb Logo

Airbnb NYC Data Dashboard

Designed Tableau dashboard on 48K+ listings, showing pricing, bookings & reviews; standardized 40K+ records in Excel.

Digit Classification Logo

Handwritten Digit Classification using Deep Learning

Built a deep learning model using TensorFlow and Keras to classify handwritten digits from the MNIST dataset with 98% accuracy.

View on GitHub

Branch Network & Digital Readiness of Indian Banks (IFSC-based analysis)

Currently In Progress

Skills

Languages/Query

SQL, Python, R, HTML, CSS, JS

BI & Visualization:

Power BI, Tableau, Excel (Pivot, Power Query), Matplotlib, Seaborn

Data & Machine Learning:

Pandas, NumPy, Sklearn, TensorFlow, Keras, Feature Engineering, Predictive Modeling, XGBoost, Random Forest, Logistic Regression

Databases & ETL

MySQL, PostgreSQL, ETL Pipelines, Data Warehousing Concepts

Tools & Cloud

Git, Kaggle, VSCode, Jupyter Notebook, Google Collab, MySql Workbench, SQLite, AWS (S3, RDS), Azure (SQL Database, Synapse)

Certificates

Python for Data Science

Issuer: IIT Madras

Issued: March 2024

View Certificate

Web Technology

Issuer: SWAYAM

Issued: June 2024

View Certificate

GATE Computer Science

Issuer: IISc Bengaluru

Issued: June 2024

View Certificate

GATE Data Science & AI

Issuer: IISc Bengaluru

Issued: June 2024

View Certificate

Education

Bachelor of Technology (Honours)

Mahatma Jyotiba Phule Rohilkhand University, Bareilly | 2021 – 2025

GPA: 8.75 / 10

Resume

You can download my latest resume or open it directly to view my professional experience, education, and project work.

Last Updated: November 06, 2025

Contact Me

I’d love to connect! Whether you have a question, an opportunity, or just want to talk data — feel free to reach out.