Skip to content
View alihantangul's full-sized avatar

Block or report alihantangul

Block user

Prevent this user from interacting with your repositories and sending you notifications. Learn more about blocking users.

You must be logged in to block users.

Content in all repositories owned by your account will be closed.
Maximum 250 characters. Please don’t include any personal information such as legal names or email addresses. Markdown is supported. This note will only be visible to you.
Report abuse

Contact GitHub support about this user’s behavior. Learn more about reporting abuse.

Report abuse
alihantangul/README.md

Hi, I'm Alihan πŸ‘‹

Data Analyst | SQL β€’ BigQuery β€’ Power BI β€’ Looker Studio β€’ Python

I build business-focused data analytics projects using SQL, BigQuery, Power BI, Looker Studio, and Python.

My focus is turning raw data into clear insights, dashboards, and decision-support stories β€” especially in e-commerce analytics, customer analytics, KPI reporting, and business intelligence.


πŸš€ Current Focus

  • Building a practical data analytics portfolio
  • Writing advanced SQL queries with BigQuery
  • Designing interactive dashboards with Power BI and Looker Studio
  • Improving Python skills for data cleaning, EDA, and visualization
  • Learning modern analytics workflows with dbt and ELT concepts

🧰 Tech Stack

πŸ“Š Data Analysis & Business Intelligence

🐍 Programming & Analytics

βš™οΈ Data Workflow & Tools


πŸ“Š Portfolio Projects

πŸ›’ Olist E-Commerce Business Insights

SQL | BigQuery | Business Analysis

End-to-end e-commerce business analysis focused on revenue growth, customer behavior, delivery performance, review scores, and geographic insights.

What I worked on:

  • Analyzed a multi-table e-commerce dataset using SQL and BigQuery
  • Used joins, CTEs, aggregations, and conditional analysis
  • Investigated order patterns, customer behavior, delivery performance, revenue trends, and review scores
  • Prepared a structured business report with insights and recommendations

πŸ”— View Project


πŸ‘₯ TheLook E-Commerce Customer Analytics Dashboard

Power BI | BigQuery | SQL | DAX

Customer analytics dashboard focused on revenue growth, churn, retention, average order value, repeat customer rate, customer segmentation, and product-category performance.

πŸ”— View Project


🏠 Airbnb Market Analytics Dashboard

Looker Studio | Data Visualization | Market Analysis

Market analytics dashboard exploring pricing, availability, room types, listing behavior, and location-based market differences.

πŸ”— View Project


🐍 Python Data Analysis Project

Python | Pandas | EDA | Data Visualization

Python-based data analysis project focused on data cleaning, exploratory data analysis, visualization, and business insight generation.

Coming soon.


🎯 Areas of Interest

  • Business Intelligence
  • E-commerce Analytics
  • Customer Analytics
  • KPI Reporting
  • Dashboard Design
  • Data Storytelling
  • Operational & Business Performance Analysis

πŸ“Œ About Me

I am a Data Analyst focused on transforming raw data into clear, business-oriented insights.

I enjoy working on end-to-end analytics projects: understanding the business question, preparing the data, writing analytical queries, building dashboards, and communicating the results in a simple and useful way.

My background includes hands-on technical and operational problem-solving experience, which helps me approach data projects with a practical, business-focused mindset.


πŸ“« Connect With Me


πŸ’‘ Portfolio Direction

I am currently building a portfolio around SQL, BigQuery, Power BI, Looker Studio, and Python.

Each project focuses on a real business question, clean analytical thinking, and clear communication of insights.


Turning data into business insights, dashboards, and better decisions.

Pinned Loading

  1. GTM GTM Public

    Forked from viteses/GTM

    HTML

  2. olist-ecommerce-business-insights olist-ecommerce-business-insights Public

    Portfolio project: end-to-end e-commerce business analysis using SQL and BigQuery, with data-quality checks, analytical views, business insights, and a PDF report.

  3. weather-etl weather-etl Public

    Python

  4. the-look-power-bi-customer-analytics the-look-power-bi-customer-analytics Public

    Power BI customer analytics dashboard built on The Look e-commerce dataset, analyzing revenue, retention, churn, AOV, repeat purchasing, and customer value segments.

  5. airbnb-looker-studio-host-performance airbnb-looker-studio-host-performance Public

    Airbnb host performance analysis using BigQuery SQL and Looker Studio, focused on occupancy, pricing, response time and estimated revenue.

  6. banking-customer-churn-analytics banking-customer-churn-analytics Public

    Banking customer churn analytics project with SQL/dbt-style data models, Python ML pipeline, risk segmentation, KPI reporting, and a live Streamlit dashboard.

    Python