Powered by
Codebasics DA Bootcamp

Gudiya Yadav

Data Analyst

[email protected]

Resume

Hello, I am

Gudiya Yadav.

1

Excel Project

3

PowerBI Projects

1

SQL Project

1

Python Project

About Me

👋 Hi, I’m Gudiya Yadav — a data-driven and detail-oriented person who enjoys working with numbers and solving real problems.

🎓 I come from a B.Tech (IT) background, which gave me a strong foundation in logic, math, and analytical thinking.

📊 I work with Power BI, Excel, SQL, MySQL, and Python, and I enjoy transforming raw data into clear, actionable insights.

🏥 I’m currently an EDI Analyst in the healthcare domain, where I handle 834 enrollment files, multiple healthcare formats, and use Salesforce for daily case tracking.

🔍 I’m very detail-focused, and I enjoy fixing data issues, improving workflows, and making information easy to understand.

📈 I’m also continuously learning and building my skills to grow as a strong, reliable Data Analyst.

Key Skills

SQL

Python

Communication Skill

Stakeholder Management

Problem Solving

Power BI

Excel

PowerPoint

My Projects

My Experience

I’m a data-driven problem solver with hands-on experience in both data analytics and healthcare EDI. I work confidently with Power BI, SQL, Excel, and Python, and I enjoy turning messy datasets into clear dashboards and meaningful insights. In my current role as an EDI Analyst, I handle 834 enrollment files, work across multiple healthcare data formats, and use Salesforce to track cases and ensure accurate, timely enrollment updates. I’m focused on improving data quality, strengthening workflows, and continuously growing my skills to deliver dependable, insight-driven results.

Awards & Certificate

Excel: Mother of Business Intelligence

Scam Awareness Course

Get Job Ready: Power BI Data Analytics for All Levels 3.0

SQL Beginner to Advanced For Data Professionals

Data Analytics Bootcamp 5.0: Job Placement Support + AI Automation & Data Engineering Basics

Data Visualisation: Empowering Business with Effective Insights

Data Visualisation: Empowering Business with Effective Insights

Internship Completion Certificate

Internship Completion Certificate

Analyse Promotion and Provide Tangible Insights to Sales Director

Analyse Promotion and Provide Tangible Insights to Sales Director

Let's Connect

Feel free to get in touch with me. I am always open to discussing new projects, creative ideas or opportunities to be part of your visions.

[email protected]

https://www.linkedin.com/in/gudiya-y-dataanalyst/

https://github.com/Gudiya-yadav-464

Excel Project

Vrinda Store Analysis

Domain/Function: Sales

The Project is about the retail Store name Vrinda store analysis. The Project's key objective is to analyze the stored data and find the key objectives. And Gain Some insights to improve the decision-making for the future growth of the store.

View Project
Engagement

View Project
on GitHUB

Vrinda Store Analysis

Overview of the Project

Vrinda Store Analysis

Project view

Project Details

Let's little bit talk about the Project

Project Title -- Vrinda Store Analysis
Objective -- The objective of this project was to analyze sales data for Vrinda Store and identify key trends and insights to improve business decision-making.
Data source -- Excel
Analysis method -- For analyzing the data I used some Pivot tables, data modeling, and charts to visualize the data.
Key findings-- The Trend in sales and the product purchasing by men and women and what age group shopping the most from Vrinda Store.
Recommendation -- After the analysis give the recommendations to the stakeholder for improving their store revenue.
1. Focus on women most because they are the customers who purchase the most groceries from our store you ran any promotion to grab the attention of
the customers.
2. Amazon is the best sales channel for the Vrinda store so make a better connection with that and give pre-discount on large orders.

PowerBI Project

Retail Promotional Analysis of Atliq Mart

Domain/Function: FMCG

The Atliq Mart is a retail giant store with over 50+ Supermarkets in southern region of India. All their 50 stores ran a massive promotion during the Diwali 2023 and Sankranti 2024. The sales Director wants to know which promotion did well or which did not. The tools I used were Power BI and SQL.

View Project
Engagement

View Project
on GitHUB

Retail Promotional Analysis of Atliq Mart

Menu of the Project

Retail Promotional Analysis of Atliq Mart

Store Performance Analysis

Project Details

Here's a concise Description of the Project

Project Title -- Retail Promotional Analysis of Atliq Mart

Objective -- Developed a Power BI Dashboard to analyze and visualize the sales and promotional data of Atliq Mart. Enabling data-driven decision-making and performance tracking.

Data Source -- Integrate data with Atliq mart SQL file.

Key features --

1. Store Performance Analysis - Visualize the top 10 stores in terms of Incremental Revenue and Bottom 10 stores In terms of Incremental Sold Units. How does the
Performance of stores vary city by city?

2. Promotional Type Analysis -- Visualize the top 2 promotions that generate the highest IR and the Bottom 2 promotions in terms of their ISU(Incremental Sold Units). Also, analyze which promotions perform well and which do not.

3. Product and category Analysis -- analyze the Performance of category and Product.

Project video

Live Interactive Dashboard

SQL Project

Consumer Goods Ad Hoc Insights Analysis

Domain/Function: Consumer Goods

Using SQL queries answered 10 ad-hoc requests, making data the compass for Atliq's journey to success. SQL, Excel, and PowerPoint tools are used. Key insights included a significant increase in unique products, a dominant 'Notebook' segment, and seasonal sales trends.

View Project
Engagement

View Project
on GitHUB

Consumer Goods Ad Hoc Insights Analysis

MYSQL query

Consumer Goods Ad Hoc Insights Analysis

Another MYSQL Query

Project Details

In the "Consumer Goods Domain" Project I Worked on the database of the Atliq hardware project. Facing the challenge of finding a data-informed decision. I answered 10 ad-hoc requests to extract actionable insights.

Find unique products in different categories like Accessories and notebooks and find which channel brings the most sales Retailer or Distributors.
In SQL I used some advanced concepts like CTE, some Windows functions Like Rank, Over Clauses, etc.

Key learnings included the transformative potential of data analytics for informed decisions, the consumer goods market's dynamic nature, the value of product diversity, the significance of seasonality awareness, and the role of distribution channels in shaping sales outcomes.

The project enhanced my data analysis, problem-solving, and communication skills, contributing to my growth as a data analyst.

Project video

PowerBI Project

Marketing Insights Analysis For Codex

Domain/Function: Marketing

Codex is a German Beverage Company that launched its energy drink in 10 cities in India. Their Marketing Team wants the data analyst to analyze the data and with the help of that, they successfully launched its energy drink in India. The tools I used In this Project were Power BI and PowerPoint.

View Project
Engagement

View Project
on GitHUB

Marketing Insights Analysis For Codex

Home Page

Marketing Insights Analysis For Codex

Demographic View

Project Details

Project Title -- Marketing Insights Analysis For Codex

Objective -- The Codex Company wants to launch its new Product in the 10 Cities in India so for that the data analyst analyzes the data and gives insights and recommendations to Codex for their efficient Product Launch.

Data Sources -- Data Integration In Power BI With the help of Excel File

Key features -- Data Modelling In Power BI and used DAX functions to calculate advanced formulas for the analysis and different kinds of charts to show the Insights.
1. Demographic View
2. Consumer preferences
3 Purchasing Behavior
4. Marketing View
5. Codex performance
6. Competition Analysis
The Project helped me improve my Problem-Solving, Communication skills and Power BI skills.

Project video

Live Interactive Dashboard

Python Project

Hotel Data Analysis

Atliq Grands encountered tough competition and a decline in revenue. They sought to utilize data and strategic insights but lacked internal expertise. My aim is to conduct a comprehensive analysis using Python to empower Atliq Grands with insights for customer retention and revenue growth.

View Project
Engagement

View Project
on GitHUB

Hotel Data Analysis

Crafting the Revenue by each business Category through Pie Chart

Hotel Data Analysis

Crafting the average rating by per city

Project Details

In this project, I performed the following operations to get insights.
1. Data Cleaning- Handling missing values and outliers.
2. Data Transformation - Added occupancy% columns.
3. Insights generation-key questions answered
#calculating average occupancy rate by room type and city.
# Identifying occupancy rate on weekdays and weekends.
# Analyzing revenue generated per city.
# Analyzing monthly revenue trends.
# Assessing revenue by booking platforms.
This was all done in Python some of the Python libraries I used Pandas and Matplotlib for this project.

Project video

PowerBI Project

Shield Insurance Project

Domain/Function: Insurance Project

This project is part of a Virtual internship at Atliq Technologies. The objective is to create a comprehensive dashboard that provides valuable insights for decision-making by analyzing customer demographics and revenue trends over six months.

View Project
Engagement

View Project
on GitHUB

Shield Insurance Project

Overview of the Dashboard

Shield Insurance Project

Sales Analysis

Project Details

𝐀𝗯𝗼𝘂𝘁 𝗦𝗵𝗶𝗲𝗹𝗱 𝗜𝗻𝘀𝘂𝗿𝗮𝗻𝗰𝗲: Shield Insurance is a leading provider of insurance solutions, operating in five major cities: Chennai, Hyderabad, Indore, Delhi NCR, and Mumbai. The company offers a diverse range of policies, ensuring suitable options for every age group. Their sales channels include both offline modes (agents and direct engagement) and online modes (mobile app and website).

The objective is to create a comprehensive dashboard that provides valuable insights for decision making by analyzing customer demographics and revenue trends over six months.

𝗣𝗲𝗿𝗳𝗼𝗿𝗺𝗮𝗻𝗰𝗲 𝗜𝗻𝘀𝗶𝗴𝗵𝘁𝘀:
• 𝗥𝗲𝘃𝗲𝗻𝘂𝗲 𝗮𝗻𝗱 𝗖𝘂𝘀𝘁𝗼𝗺𝗲𝗿 𝗚𝗿𝗼𝘄𝘁𝗵: Earned $989 million in revenue and served 26,841 customers over six months.
• 𝗠𝗼𝗻𝘁𝗵𝗹𝘆 𝗧𝗿𝗲𝗻𝗱𝘀: March 2023 was the highest-performing month with $263 million in revenue and 7,081 customers.
• 𝗖𝗶𝘁𝘆 𝗣𝗲𝗿𝗳𝗼𝗿𝗺𝗮𝗻𝗰𝗲: Delhi NCR led with 11,007 customers and $402 million in revenue.

Project video

Live Interactive Dashboard