Ascending with Data

“Turning raw data into decisions that matter.”

Ilkkan Yavuz | Data Analyst Portfolio

Business Intelligence

Data Analyst | Data Storyteller | Transforming Numbers into Insights

Master's Degree in Data Analytics. Specializing in Python, SQL, Power BI, and SPSS.

About Me

Background & Expertise

I'm a data analyst with a Master's degree in Measurement and Data Analytics, based in Istanbul, Turkey. My background combines education research with business intelligence, giving me a unique perspective on how data drives meaningful organizational change.

I specialize in end-to-end analytics projects: from database design and complex SQL queries to visualization and stakeholder communication. My sweet spot is customer behavior analysis and product performance metrics.

What I Bring

  • Technical Depth: SQL optimization, Python data manipulation, statistical modeling
  • Visualization: Power BI dashboards that tell stories, not just report numbers
  • Strategic Thinking: Questions first, data second. Always aligned with business goals
  • Communication: Bridge gap between technical teams and business stakeholders

Skills

Technical Skills

PythonSQLExcelSPSS

Visualization

Power BIData StorytellingDashboards

Competencies

Customer BehaviorProduct PerformanceDigital AnalyticsExperimental Design

Tools & Platforms

GitHubJupyter NotebookSQL ServerGoogle Analytics

Core Competencies

Strategic Insight

I'm particularly interested in customer behavior, product performance, and digital analytics—areas where rigorous analysis can directly influence growth, retention, and user satisfaction.

Communication

I bridge the gap between data and decision-makers by communicating insights in a concise, structured, and actionable way.

Customer Segmentation with RFM Analysis

Projects

European Soccer Performance Analysis

2025

Applied advanced SQL to evaluate team and league performance and surface actionable competitive insights.

Key Findings: Identified performance patterns influencing league standings and competitive dynamics

SQLData AnalysisStatistical Modeling
View Code

Customer Segmentation with RFM

2025

Built an end-to-end RFM workflow in Power BI to identify high‑value customer segments and inform targeted marketing and retention strategies.

Key Impact: Segmented customers into actionable groups to optimize marketing spend and improve retention by 15%+

Power BIMarketing AnalyticsRFM Analysis
View Code

Online Reading Platforms & Learning Outcomes

2025

Led a master's thesis study on an online reading platform's impact on English reading skills, analyzing pre/post data from 78 students and demonstrating significant gains in reading comprehension.

Key Result: Statistical significance confirmed (p < 0.05) showing 23% improvement in reading comprehension scores

StatisticsEducation DataHypothesis Testing
View Article

Social Media Network Trends

2025

Visualized how demographic factors relate to social media platform choices, revealing distinct behavior patterns across user groups.

Key Insight: Identified demographic-platform affinities enabling targeted audience analysis and strategy optimization

VisualizationSocial Media AnalyticsNetwork Analysis
View Study

My Goal

To become a Lead Data Analyst who owns end‑to‑end analytics projects, from robust data models to clear, actionable insights for stakeholders. I want to specialize in data storytelling and experiment design so organizations can test ideas, measure impact, and continuously improve their products and customer experiences.

Get In Touch

Feel free to reach out for collaborations or opportunities.