Skip to content
sauryayanPublic

About

No description, website, or topics provided.

Resources

Stars

0 stars

Watchers

0 watching

Forks

Latest commit

 

History

18 Commits

Folders and files

NameName
Last commit message
Last commit date
 
 

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

0 stars

Watchers

0 watching

Forks

Releases

Packages

Contributors