Skip to content
View gauravvxv's full-sized avatar
🎯
Focusing
🎯
Focusing

Block or report gauravvxv

Block user

Prevent this user from interacting with your repositories and sending you notifications. Learn more about blocking users.

You must be logged in to block users.

Maximum 250 characters. Please don't include any personal information such as legal names or email addresses. Markdown supported. This note will be visible to only you.
Report abuse

Contact GitHub support about this user’s behavior. Learn more about reporting abuse.

Report abuse
gauravvxv/README.md
github-header-banner

Hi, I'm Gaurav Sharma πŸ‘‹

A Data Analyst passionate about turning data into actionable insights.
I specialize in leveraging analytical tools and techniques to solve complex problems and support informed decision-making.


🌟 What I Do

  • πŸ” Data Analysis: Skilled in using tools like Python, SQL, Excel, and Power BI to explore data and extract actionable insights.
  • πŸ“Š Data Visualization: Creating clear and effective visualizations to communicate insights.
  • πŸ”’ Statistical Foundation: Strong foundation in statistics for accurate analysis.

πŸ› οΈ Languages & Tools

Python Pandas Matplotlib Seaborn MySQL PostgreSQL Excel Power BI


πŸš€ My Path Ahead

I'm on a continuous journey to enhance my data analysis skills.
I aim to transform raw data into actionable insights that help drive smarter business decisions.

πŸ“„ My Resume

πŸš€ Featured Projects

πŸ“¦ Food Delivery Crisis Impact & recovery Analysis

πŸ”— View Project

End-to-end crisis recovery analysis for a food delivery startup using Python, SQL, and Power BI, focusing on orders, revenue, delivery performance, and customer retention.

Key Highlights:

  • Analyzed how a major operational issue in June 2025 affected the business, focusing on orders, revenue, delivery timelines, and customer ratings.
  • Identified a 61% decline in orders and 71% revenue loss, with delayed deliveries emerging as the main reason behind 83% customer churn.
  • Used SQL and Python to clean and analyze operational data and understand where the business was losing customers and revenue.
  • Created Power BI dashboards to monitor recovery performance by city and shared practical insights to help improve delivery efficiency and customer retention.

Tech Stack: Python, Pandas, SQL, Power BI


🏨 Consumer Purchasing Trends and Insights analysis

πŸ”— View Project

Analyzes customer shopping behavior using transactional data from 3,900 purchases across multiple product categories. The goal is to uncover insights into spending patterns, customer segmentation, product preferences, and subscription behavior to guide strategic business decisions.

Key Highlights:

  • Analyzed 3,900+ retail transactions to understand how age groups, subscriptions, discounts, and shipping preferences affect customer purchasing behavior.
  • Cleaned and structured customer data using Python, and used SQL to compare spending patterns across demographics, product categories, and subscriber types.
  • Built an interactive Power BI dashboard to identify high-value customer segments and support pricing, promotion, and retention decisions.
  • Shared insights on customer preferences and discount effectiveness to help improve sales strategy and customer targeting.

Tech Stack: Python, Pandas, SQL, Power BI


πŸ‘¨β€πŸ’Ό Employee Analytics Dashboard

πŸ”— View Project

An end-to-end HR analytics project covering data cleaning, SQL querying, and dashboard development to uncover workforce insights.

Key Highlights:

  • Salary distribution and compensation analysis
  • Department-wise performance insights
  • Hiring and workforce trend analysis
  • Work type and attrition pattern study

Tech Stack: Python, PostgreSQL, Power BI, Excel



🌐 Let's Connect

If you share a love for data, analytics, or problem-solving, or if you’d like to collaborate on exciting projects, I’d be glad to connect. πŸ“© Feel free to reach out to me at gauravxv0410@gmail.com

LinkedIn LeetCode

let’s create something impactful together!


πŸ“Š GitHub Stats:




πŸ† GitHub Trophies


✍️ Random Dev Quote

Pinned Loading

  1. E-Shop-performance-dashboard E-Shop-performance-dashboard Public

    The E-Commerce Analytics Dashboard is a data analytics project designed to provide insights into the operations of an e-commerce business. It leverages PostgreSQL for data storage and Power BI for …

  2. Zepto Zepto Public

    Zepto Inventory analyzes product sales, discounts, and stock levels to provide actionable business insights. It helps identify top-performing categories, out-of-stock items, and pricing opportuniti…

  3. Airbnb Airbnb Public

    This Excel dashboard presents a comprehensive analysis of Airbnb listings across New York City using the 2019 dataset. It includes multiple pivot tables, charts, and slicers to interactively explor…

  4. Netflix-Users-Database Netflix-Users-Database Public

    This project explores and visualizes Netflix users data to understand user behavior, subscription preferences, and content interests. The analysis was performed using Python with Pandas, NumPy, Mat…

    Jupyter Notebook 1

  5. cafe-sales cafe-sales Public

    Cleaned a messy cafe sales dataset using Pandas. Visualized trends with Matplotlib & Seaborn. Created monthly insights, fixed data types, and handled missing values.

    Jupyter Notebook

  6. Employee-Analytics-Dashboard Employee-Analytics-Dashboard Public

    A complete end-to-end data analytics project where I cleaned and analyzed employee data using Python, Excel (Power Query), PostgreSQL, and Power BI. This project uncovers key business insights such…

    Jupyter Notebook