Database design, queries, and reporting pipelines for finance and business insights.
📖 Description
SQL is the backbone of my data analysis and reporting work. With MySQL, I can directly access, structure, and transform raw data into clean, decision-ready insights for finance and business.
From data extraction and transformation to query optimisation and reporting, these projects show how I use SQL to:
- Build and query financial databases
- Perform joins, subqueries, and aggregations for deeper analysis
- Automate reporting and reconciliations
- Support variance, liquidity, and performance analysis
Each project demonstrates both the technical strength of MySQL (ETL pipelines, query efficiency, database design) and the business value it creates — enabling accurate reporting, stronger compliance, and data-driven decision-making.
I focus on writing SQL that is efficient, reliable, and finance-focused, ensuring organisations can trust their data and act on it with confidence.
✨ Featured Projects
🗓️ My SQL Journey: From Fundamentals to Advanced Mastery
This portfolio is a snapshot of my growth in SQL and MySQL, where I showcase how I’ve progressed from simple queries to advanced database management.
You’ll find:
- 🔍 Filtering & Joins – extracting and combining data with precision
- 📊 Aggregations & Subqueries – turning raw data into insights
- 🛠️ Database Management & Integrity – creating structured, reliable systems
- 🐍 Python Integration – using
mysql.connector
+pandas
to bring queries to life
👉 Click to dive into the full portfolio and see how I connect SQL fundamentals with real-world data analysis and automation.
♻️ International Student Wellbeing Analytics: Advanced SQL Portfolio
This project is a snapshot of my SQL-driven research into international student wellbeing, where I analyze how stay duration impacts mental health outcomes.
You’ll find:
- 🔍 Risk Pattern Detection – identifying depression, anxiety, and social adaptation signals
- 📊 Impact Quantification – measuring demographic and duration-based influences
- 🧮 Predictive Insights – SQL scoring systems for proactive interventions
- 🛠️ Monitoring Frameworks – building sustainable wellbeing dashboards
👉 Click to dive into the full portfolio and see how I connect SQL analytics with real-world student mental health research and institutional support strategies.
⚡ Continuous Learning
- I continue to add new projects as I explore advanced techniques in anomaly detection, deep learning, and financial forecasting.
- Connect with me on LinkedIn or explore all repositories on GitHub.
© Teslim Adeyanju 2025. All Rights Reserved.