Based In

Bayreuth, Germany

Hi, I'm Yugal

Werkstudent Data Analyst @ TenneT

View My Work

About Me

Yugal Jagtap Yugal Jagtap Color

My passion for data started with one question: how can computers and data lead to better outcomes? That curiosity took me from a Bachelor's in IT to a Master's in Computer Science at Universität Bayreuth, where I focus on machine learning, data analysis, and the ethics of AI systems.

I will be joining TenneT in June 2026 as a Working Student in Data Analytics, where I'll be supporting renewable energy monitoring and grid data analysis.

My internships and personal projects have mostly been about making data usable from building pipelines, putting together dashboards, and occasionally building models to answer questions before someone has to ask them manually.

Projects

Olist E-Commerce Analysis Screenshot Olist E-Commerce Analysis Screenshot Color

Olist E-Commerce Analysis

End-to-end SQL analysis of 100,000+ Brazilian e-commerce orders exploring revenue trends, customer distribution, logistics performance, and seller rankings. Migrated from SQLite to Google BigQuery. Interactive Tableau dashboard published on Tableau Public.

SQL Tableau Python SQLite BigQuery Google Cloud
Fairness and Transparency in AI Screenshot Fairness and Transparency in AI Screenshot Color

Fairness and Transparency in AI

Built an interpretable ML system to detect racial bias in COMPAS recidivism scores using a hybrid Logistic Regression + Naive Bayes pipeline, Surrogate Models, and LIME. Includes a bias warning system and model confidence scores.

Python Scikit-learn LIME Flask
China's Rhetoric in the UNSC Poster China's Rhetoric in the UNSC Poster Color

China's Rhetoric in the UNSC

Applied NLP and Structural Topic Modeling (STM) in R to 20 years of UN Security Council speeches, uncovering rhetorical shifts before and after Xi Jinping's ascension to power. Identified 10 key diplomatic topics and compared China–USA speech patterns geographically.

R NLP Text Mining

My Skills

Languages

  • Python (Pandas, NumPy)
  • SQL
  • R

Databases

  • BigQuery
  • MySQL
  • SQLite

BI & Visualization

  • Tableau
  • Power BI
  • Matplotlib / Seaborn

Machine Learning

  • TensorFlow
  • Scikit-learn
  • Keras

Get In Touch

I'm currently open to new opportunities and collaborations. Feel free to reach out!

Say Hello