Skip to content
View Shruti-131202's full-sized avatar

Block or report Shruti-131202

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
Shruti-131202/README.md

Hi, I'm Shruti Khandelwal

I enjoy using data to understand customer behavior, business performance, and operational problems.

I work with SQL, Python, Power BI, and Excel to turn messy datasets into clear insights that support better decisions. My focus is not just building dashboards — I like understanding why numbers change and what businesses should do next.

What I Work On

  • Customer retention & churn analysis
  • Revenue and sales performance analysis
  • Business KPI tracking & reporting
  • Customer behavior and segmentation
  • Operational and business performance analysis
  • Data cleaning, analysis, and visualization

Tech Stack

Analytics & BI

  • SQL
  • Power BI (DAX, Power Query)
  • Excel (Pivot Tables, Lookup Functions, Dashboards)

Python

  • Pandas
  • NumPy
  • Matplotlib

Featured Projects

Customer Retention & Revenue Risk Analysis

Business Problem: High customer drop-off after first purchase and revenue concentration risk.

What I did:

  • Analyzed customer retention behavior and repeat purchase trends
  • Identified customer drop-off patterns affecting growth
  • Investigated revenue concentration risk across customer segments
  • Built KPI dashboards to track business performance

Key Outcome: Found major customer retention gaps and identified revenue dependency on a small customer segment, helping prioritize retention-focused strategies.


SaaS Revenue Risk Detection & Churn Analysis

Business Problem: Revenue dependency on a small group of customers increases churn risk.

What I did:

  • Analyzed customer-level revenue contribution
  • Identified high-value customers at risk of churn
  • Explored churn patterns and business impact
  • Created visual analysis to support retention strategies

Key Outcome: Highlighted revenue concentration risk and surfaced opportunities to reduce customer loss and improve recurring revenue stability.


Sales & Business Performance Analysis

Business Problem: Understand revenue trends, product performance, and customer purchasing behavior.

What I did:

  • Analyzed sales trends and business KPIs
  • Built dashboards for performance tracking
  • Identified top-performing segments and areas of decline
  • Generated business recommendations based on trends

Currently Working On

  • Improving SQL and Python for analytics
  • Building business-focused data projects with measurable insights
  • Strengthening problem-solving and KPI analysis skills
  • Preparing for Data Analyst opportunities

What You'll Find Here

  • Business-focused analytics projects
  • SQL analysis and case studies
  • Power BI dashboards
  • Python data analysis notebooks
  • Real-world business problem solving

Let's Connect

📧 Email: shrutikhandelwal1213@gmail.com 💼 LinkedIn: [https://www.linkedin.com/in/shruti-khandelwal-05a61b2b4] 💻 GitHub: [https://github.com/Shruti-131202]

Always open to connecting with people working in analytics, business intelligence, and data-driven problem solving.

Pinned Loading

  1. customer-retention-revenue-optimization-analysis customer-retention-revenue-optimization-analysis Public

    End-to-end data analysis project using SQL and Power BI to identify customer retention gaps, revenue concentration risks, and growth opportunities through RFM and cohort analysis.

  2. Logistics-Delay-Cost-Leakage-Analysis Logistics-Delay-Cost-Leakage-Analysis Public

    This project analyzes delivery performance and SLA compliance for a logistics operations dataset to identify delay patterns, SLA breach risks, and estimated cost leakage impacting business efficiency.

  3. saas-revenue-risk-churn-analysis saas-revenue-risk-churn-analysis Public

    Identified 83% revenue concentration in top accounts and ₹82K revenue at risk by analyzing churn and engagement patterns in a SaaS business using SQL, Python, and Power BI.

    Jupyter Notebook