Skip to content

sauryayan/sauryayan

Folders and files

NameName
Last commit message
Last commit date

Latest commit

Β 

History

18 Commits
Β 
Β 

Repository files navigation

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!

About

No description, website, or topics provided.

Resources

Stars

Watchers

Forks

Releases

No releases published

Packages

 
 
 

Contributors