Skip to content
View bergerache's full-sized avatar
1 follower · 0 following

Highlights

  • Pro

Block or report bergerache

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.

Maximum 250 characters. Please don't include any personal information such as legal names or email addresses. Markdown supported. This note will be visible to only you.
Report abuse

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

Report abuse
bergerache/README.md

👋 Data Analyst - Customer Analytics | Power BI • SQL • Python

Turning customer data into retention strategies and revenue insights

🎯 Specialisation

Customer lifetime value analysis, retention modelling, credit risk assessment, and cohort analytics for financial services.

🛠️ Core Stack

Analytics Engineering Domain
Power BI (DAX) SQL (Window Functions, CTEs) Credit Risk
Tableau dbt + BigQuery Customer Analytics
Looker Studio Python (pandas, scikit-learn) Churn Prediction

📌 Featured Projects

💳 Credit Payment Analytics

dbt + BigQuery — 5-tier customer scoring system for credit risk assessment, identifying profitable customers using payment behaviour analysis.

📊 Customer Loyalty Analytics

Power BI + DAX — CLV analysis, retention cohorts, and promotional effectiveness with £8,047 vs £7,435 CLV comparison and time-bias correction methodology.

🗃️ SQL Operations Analytics

MySQL — Window functions, CTEs, cumulative calculations, and trend analysis demonstrating financial services SQL patterns.

📉 Churn Prediction Model

Python + Scikit-learn — 79% F1-score Gradient Boosting model with direct applications to deposit account and credit card attrition.

🛒 E-Commerce BI Platform

dbt + BigQuery + Looker Studio — £8.66M revenue analysis with RFM segmentation across 4,293 customers.

🔍 Currently Seeking

Mid-level Data Analyst roles in UK banking and fintech where I can apply customer analytics expertise to drive commercial decisions.

📫 Let's Connect

LinkedIn Email

Pinned Loading

  1. powerbi-customer-loyalty-analytics powerbi-customer-loyalty-analytics Public

    Power BI dashboard analysing customer lifetime value and promotional cohort effectiveness for an airline loyalty program.

  2. credit-payment-analytics credit-payment-analytics Public

    dbt analytics pipeline for credit risk assessment, identifying profitable customers using payment behaviour analysis

    Jupyter Notebook

  3. sql-baseball-operations-analytics sql-baseball-operations-analytics Public

    Advanced SQL analytics demonstrating window functions, CTEs, and cumulative calculations — techniques directly applicable to financial services reporting.

  4. Telecom_churn_predictor Telecom_churn_predictor Public

    Churn prediction for Telecom company

    Jupyter Notebook 2

  5. ecommerce-analytics ecommerce-analytics Public

    Production-grade dbt analytics platform with customer segmentation

    4