Skip to content
View mudasirfayaz's full-sized avatar
4 followers · 2 following

Achievements

Achievement: Pull Sharkx2Achievement: YOLO

Achievements

Achievement: Pull Sharkx2Achievement: YOLO

Block or report mudasirfayaz

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 is supported. This note will only be visible to you.
Report abuse

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

Report abuse
mudasirfayaz/README.md

👋 Hi, I'm Mudasir Fayaz

💡 Aspiring Data Analyst | SQL • Power BI • Python • Excel 📍 Anantnag, India

About Me

I'm a data analyst focused on turning raw data into actionable business insights. I learn by building real-world projects and solving practical problems using SQL, Python, Power BI, and Excel.

Recently, I completed an end-to-end E-commerce Funnel Analysis, where I identified key conversion bottlenecks and uncovered price-driven user behavior patterns.

Featured Projects

E-commerce Funnel Analysis

Tech: SQL, Power BI, Python

  • Analyzed 180K+ user events across View → Cart → Purchase funnel
  • Identified ~78% drop-off at View → Cart stage
  • Discovered strong price sensitivity (21% → 5% conversion drop across price tiers)
  • Found that high-priced apparel shows near-zero conversion, revealing key business bottleneck
  • Built interactive Power BI dashboard for funnel and segmentation analysis

👉 View Project

Rideshare Data Analysis

Tech: SQL, Power BI

  • Analyzed 2.5 years of ride data to identify revenue volatility and churn patterns
  • Found top 20% users generate ~70% revenue (high dependency risk)
  • Identified peak demand patterns and user retention issues

👉 View Project

Coffee Sales Dashboard

Tech: Excel (PivotTables, PivotCharts, VBA)

  • Built an interactive dashboard analyzing 3,636 coffee shop transactions
  • Surfaced revenue trends by product, payment method, and time of day using PivotTables and PivotCharts
  • Implemented VBA-driven toggle controls for switching between monthly and daily sales views
  • Translated findings into staffing and promotion recommendations (peak demand in Afternoon/Night)

👉 View Project

Automation Projects

  • Built web scraping pipelines using BeautifulSoup & Selenium
  • Automated workflows and data collection processes

Skills

Languages: SQL, Python Tools: Power BI, Excel (PivotTables, PivotCharts, VBA), Pandas Concepts:

  • Data Cleaning & Transformation
  • Funnel Analysis
  • Exploratory Data Analysis (EDA)
  • Joins, CTEs, Window Functions
  • Dashboard Design & KPI Development

What I'm Working On

  • Building more real-world data projects
  • Improving data storytelling & visualization
  • Preparing for Data Analyst roles

Let's Connect

I'm always open to feedback, collaboration, or just a chat about data!

LinkedIn GitHub Email

"Every expert was once a beginner. I'm showing up every day."

Pinned Loading

  1. ecommerce-funnel-analysis ecommerce-funnel-analysis Public

    Analyzed 180K+ e-commerce events to identify conversion bottlenecks, uncovering strong price sensitivity and category-level performance gaps, and proposed data-driven strategies to improve conversi…

  2. rideshare-data-analysis rideshare-data-analysis Public

    End-to-end rideshare data analysis using SQL & Power BI, focused on revenue trends, demand patterns, driver performance, and rider retention.

  3. cricket-data-cleaning cricket-data-cleaning Public

    This project cleans and validates a historical cricket batting averages dataset using Python and Pandas.

    Jupyter Notebook

  4. coffee-sales-dashboard coffee-sales-dashboard Public

    Interactive Excel dashboard analyzing 3,636 coffee shop transactions — PivotTables, PivotCharts, and VBA-driven toggle controls to surface revenue by product, payment type, and time of day. Dataset…