Yogita Gupta

Motivated and detail-oriented Data Analyst fresher with strong knowledge of Excel, SQL, Python, and data visualization tools. Seeking an opportunity to apply analytical skills to transform data into meaningful insights and support business decision-making.

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

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

• Hardworking and disciplined
• Quick learner with positive attitude
• Strong attention to detail
• Ability to work under pressure

Python Internship Training - Solitaire Infosys Pvt.Ltd.