$ status: open_to_work
Open to Opportunities Β· 2026

Ilkkan Yavuz

Master's in Data Analytics. Transforming raw data into strategic business intelligence. Specialized in customer behavior, product performance, and end-to-end analytics pipelines.

0 Projects
0 Tools
0 Records Analyzed
Ilkkan Yavuz
IY
Watch My Story
Quick intro & overview
0:28
scroll

About Me

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

I specialize in end-to-end analytics: from database design and complex SQL queries to interactive dashboards and stakeholder communication. My sweet spot is customer behavior analysis, product performance metrics, and translating messy data into crisp narratives.

I believe great analysis isn't just technically accurate β€” it's clear, actionable, and aligned with business goals.

πŸŽ“
M.Sc. Measurement & Data Analytics Graduate-level statistical modeling & research methods
πŸ“
Istanbul, Turkey Open to remote & hybrid opportunities worldwide
πŸ’‘
Business Intelligence Focus Customer segmentation Β· Churn prediction Β· Growth analytics
☁️
Cloud Proficient Microsoft Azure Β· Azure Data Factory Β· Blob Storage
0 Projects
0 Databases
0 Years Exp.
Data Analysis & SQL 92%
Power BI / Visualization 90%
Python & Pandas 85%
Statistics & Modeling 80%

Tech Stack & Skills

Full-stack analytics capability from raw data to production dashboards.

Languages & Querying
Python Pandas NumPy Matplotlib SQL PL/SQL
BI & Visualization
Power BI Excel Advanced Pivot Tables SPSS JASP
Databases
SQL Server MySQL PostgreSQL ETL Processes Data Warehousing
Analytics Methods
EDA A/B Testing RFM Segmentation Cohort Analysis Regression Analysis Forecasting
Cloud & Tools
Microsoft Azure Azure Data Factory Azure Blob Storage UCINET NetDraw
Soft Skills
Data Storytelling Stakeholder Communication Problem Solving Strategic Thinking
Skills Radar

Key Projects

End-to-end analytics with measurable business impact.

01
Churn Prediction
Telco Churn Analysis

End-to-end churn prediction model for 7,000+ telecom customers. Identified key churn drivers β€” month-to-month contracts showed 42% higher churn rates. Built an Azure data pipeline for real-time scoring, projected to reduce annual churn from 27% to 21%, saving ~$1.2M in acquisition costs.

85%Model Accuracy
βˆ’22%Churn Reduction
$1.2MCost Saving
Python SQL Power BI Azure ADF
View on GitHub
02
Customer Segmentation
RFM Customer Segmentation

Comprehensive RFM segmentation for an e-commerce platform analyzing 4,500+ transactions. Champions segment generated 45% of total revenue despite being only 11% of the customer base. Segmented email campaigns achieved 52% higher open rates.

8Segments
+35%Marketing ROI
+52%Email Open Rate
Python SQL Excel Power BI
View on GitHub
03
SQL Analysis
European Soccer SQL Analysis

Advanced SQL on 25,000+ match records across 11 European leagues. CTEs, window functions (RANK, LAG, PARTITION BY), and correlated subqueries to surface competitive trends.

75%Query Speed ↑
11Leagues
SQL CTEs Window Fn
GitHub
04
Research & Statistics
Digital Reading Platform Impact

Quantitative study evaluating Bookr Class digital reading platform effectiveness on English reading comprehension for 78 middle school students. Hypothesis testing and paired t-tests achieving p < 0.05.

+18%Comprehension
<0.05p-value
78Students
SPSS Hypothesis Testing Regression
LinkedIn

Experience & Education

2024 β€” Present
Data Analyst
Business Intelligence Β· Istanbul, Turkey
End-to-end analytics projects including customer segmentation, churn modeling, and cloud data pipeline development on Microsoft Azure. Delivering Power BI dashboards to senior stakeholders.
2023 β€” 2025
M.Sc. Measurement & Data Analytics GPA 3.87/4.00
Anadolu University Β· Turkey
Non-thesis program. Relevant coursework: Statistical Analysis, Machine Learning, Database Programming, Quantitative Research Methods, Data Mining, Decision Theory & Analysis, Information Systems Analysis and Design.
2022 β€” 2024
Associate Degree in Computer Programming GPA 3.18/4.00
Istanbul University Β· Turkey
Relevant coursework: Algorithms and Programming, Object-Oriented Programming, Database Design, Software Quality and Testing, Web Programming.
2008 β€” 2012
B.A. in English Language Teaching
Trakya University Β· Turkey
Focus: Cross-cultural Communication, Research Methodology, Content Analysis.

Data Philosophy

Data without context is noise. My approach starts not with the database, but with the business question. I believe the most powerful insights come from relentless curiosity combined with technical rigor β€” asking "why" before asking "how."

I'm driven by the idea that every organization has untapped intelligence hidden in its data. My job is to surface it clearly, honestly, and in a way that moves people to act. Numbers are just the beginning β€” the story they tell is what matters.

πŸ“Š
Customer Analytics Behavior patterns, segmentation, lifetime value
πŸ”¬
Experimentation A/B testing, hypothesis-driven decision making
πŸ—ΊοΈ
Data Storytelling Turning complex findings into clear narratives
☁️
Cloud Pipelines Scalable ETL and data architecture on Azure
🧩
Product Analytics Feature impact, funnel optimization, retention
πŸ“š
Continuous Learning Always exploring new tools and techniques

Let's Work Together

I'm actively looking for my next opportunity in a data-driven team. Whether it's a full-time role, a freelance project, or just a conversation β€” I'd love to hear from you.

Available for opportunities starting immediately.

info@ilkkanyavuz.com