Skip to content
View sauryayan's full-sized avatar
1 follower · 0 following

Block or report sauryayan

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

banner

Hi 👋, I'm Sauryayan

Data Analyst | SQL • Excel • Power BI • Python

Turning raw data into actionable business insights 🚀

👨‍💻 About Me

  • 📊 Data Analyst with 1–2 years of hands-on experience in analytics & reporting
  • 🔍 Strong in SQL, Excel, Python, and Power BI
  • 🧠 Skilled at data cleaning, EDA, and dashboarding
  • 💡 Background in engineering — experienced in real-world problem solving & decision-making
  • 🎯 Currently seeking Data Analyst opportunities

🛠️ Tech Stack

Languages & Tools
SQL • Python • Microsoft Excel • Power BI

Libraries
Pandas • NumPy

Core Skills
Data Analysis • Data Cleaning • EDA • Dashboarding • ETL • Data Visualization

📊 Featured Projects

📊 Retail Sales & Profitability Analysis Dashboard

  • Analyzed 9,904 retail transactions ($2.29M+ sales) to diagnose revenue performance, profit leakage, and discount impact
  • Discovered a critical 20% discount threshold beyond which profitability deteriorates sharply, with top loss-making products driving nearly 30% of total losses
  • Uncovered actionable insights across customer segments, regional profitability, and category-level performance
  • Built a multi-page interactive Power BI dashboard using DAX, drill-through analytics, and custom tooltips for executive decision-making

🔗 View Project

🏥 Healthcare Clinical & Financial Analytics Pipeline

  • Built an end-to-end ETL pipeline processing 3M+ records
  • Designed star schema & SQL views (CTEs) for clean data modeling
  • Identified 26.3% high-risk readmission cohort
  • Developed Power BI dashboard for clinical & financial KPIs

🔗 View Project

🛒 E-Commerce Customer Behavior Analysis

  • Analyzed transactional data using SQL & Python
  • Performed customer segmentation & revenue trend analysis
  • Built interactive dashboards for business insights

🔗 View Project

📈 What I Bring

  • Ability to translate business problems into data solutions
  • Strong analytical thinking & attention to detail
  • Experience working with real-world datasets
  • Clear communication of data insights to stakeholders

📫 Connect With Me

⭐ If you find my work interesting, feel free to explore my repositories and connect!

Pinned Loading

  1. Healthcare-Clinical-Analytics-PipelineHealthcare-Clinical-Analytics-PipelinePublic

    An enterprise-grade ETL and BI architecture analyzing 3M+ clinical records. Built with Python, MySQL, and Power BI to decode DRG flat-rate billing and visualize 30-day hospital readmission risks.

    Jupyter Notebook

  2. ecommerce-customer-behavior-analysisecommerce-customer-behavior-analysisPublic

    An end-to-end data analytics pipeline analyzing 3,900 e-commerce transactions using Python, PostgreSQL, and Power BI to uncover insights on customer segmentation, discount dependency, and revenue o…

    Jupyter Notebook

  3. diwali-sales-eda-pythondiwali-sales-eda-pythonPublic

    A comprehensive Exploratory Data Analysis (EDA) on holiday sales data using Python to uncover demographic purchasing patterns and actionable business insights.

    Jupyter Notebook 1

  4. regex-data-cleaning-toolkitregex-data-cleaning-toolkitPublic

    To level up my data cleaning skills, I took on a "Regex Gauntlet"—a complex, unstructured dataset where I had to write 30 specific Regular Expression patterns in Python to extract and format the da…

    Jupyter Notebook