Work Preference
Education
Timeline
Overview
Skills
Summary
Languages
Certification
Projects
Websites
AdministrativeAssistant
Yogita Gupta

Yogita Gupta

Data Analyst
Narayangarh,HR

Work Preference

Work Type

Full Time

Location Preference

On-SiteRemote

Important To Me

Career advancementWork-life balance

Education

Bachelor in Computer Application - Data Science

Maharishi Markandeshwar (Demeed To Be University)
Mullana
09.2022 - 03.2026

Timeline

Bachelor in Computer Application - Data Science

Maharishi Markandeshwar (Demeed To Be University)
09.2022 - 03.2026

Overview

3
3
years of post-secondary education

Skills

  • Data Analysis & manipulation: Python (Pandas, NumPy), SQL (Joins, CTEs, Window Functions), Advanced Excel (Power Query, Pivot Tables)
  • Data Visualization: Power BI (DAX, Power BI Service, Interactive Dashboards)
  • Statistical Analysis: Descriptive Statistics, Data Distribution
  • Database Management: Relational Databases (MySQL), Data Cleaning & ETL
  • Soft Skills: Data Storytelling, Analytical Thinking, Problem-Solving, Stakeholder Communication, Time Management

Summary

Data analysis professional prepared to deliver impactful insights and drive business decisions. Adept in data visualization, statistical analysis, and database management, with strong focus on teamwork and adaptability. Known for reliability, analytical thinking, and results-driven approach. Skilled in Python, SQL, and Excel, ensuring robust data solutions and strategic recommendations.

Languages

English
Upper intermediate (B2)
Hindi
Advanced (C1)

Certification

Python Internship Training - Solitaire Infosys Pvt.Ltd - 6weeks

Projects

Food Delivery Data Analysis & Performance Optimization

  • Analyzed 5K+ delivery records using SQL (multi-table joins, CTEs, window functions) to evaluate delivery performance, customer behavior, and revenue trends
  • Identified key patterns such as peak ordering hours (8 PM–12 AM) and analyzed late delivery percentages across cities
  • Developed an interactive Power BI dashboard with KPIs, delivery performance metrics, and customer insights for data-driven decision-making
  • Generated actionable insights, including impact of delivery distance on delays, correlation between faster delivery and higher ratings, and identification of high-value customers contributing majority of revenue

E-Commerce Sales Analysis Dashboard

  • Cleaned and transformed 1,000+ rows of raw sales data using Excel and Power Query to ensure data accuracy and consistency
  • Developed an interactive Power BI dashboard with KPIs, slicers, and dynamic visualizations for real-time business insights
  • Analyzed customer behavior, revenue trends, and product performance to support data-driven decision-making
  • Utilized DAX measures (MTD, YTD, Same Period Last Year) to perform advanced time-based analysis
  • Identified top-selling categories and profit trends, improving visibility into business performance and strategic planning
Coffee Shop Sales Analysis
  • Analyzed retail sales data to identify sales patterns by day, hour, and month, uncovering peak periods and seasonal trends
  • Evaluated store location performance and average order value to understand customer spending behavior and optimize pricing strategies
  • Identified best-selling products by quantity and revenue, supporting inventory planning and product optimization
  • Generated actionable insights to improve staffing efficiency, inventory management, and overall sales performance

Big Data-Driven Customer & Revenue Intelligence System

  • Designed and executed an end-to-end Sales Data Analysis project using Python (Pandas, NumPy) and Power BI, converting raw data into actionable business insights
  • Performed data cleaning, EDA, and feature engineering (profit margin, time-based metrics) to uncover key trends in customer behavior and revenue
  • Developed an interactive Power BI dashboard with dynamic KPIs and visualizations to support strategic decision-making
  • Identified high-value customer segments driving ~80% of revenue and delivered insights to optimize sales performance and customer targeting
Yogita GuptaData Analyst