This folder contains a selection of the projects completed for the degree of Data Analyst at Turing College.
= code/data repository
📖 = report
🖥️ = dashboard / web app
NB: web apps and dashboards are hosted on a free-tier web services, therefore they take more time to load than on a dedicated server
Product Analysis
📖
Analysis of time spent on the e-commerce website for purchasing and non-purchasing sessions, segmenting customer base by (1) category of products, (2) new/returning customer, (3) ON SALE / regular price
Marketing Analysis
📖
ROI (return on investment) and impact of different marketing campaigns on conversion rates, session length, revenues for different days of the week in an e-commerce website
Monetization Analysis
📖
Investigation on reducing freight ratio for an e-commerce website - shipping fees being the #1 reason for cart abandonment.
Salespersons' Performance Analysis
,
Investigation of factors which influencing a salesperson's performance (e.g. experience, career, geographical distribution)
Coronary Heart Disease Prediction
Logistic regression showing the predictive value of sex, age, blood pressure, glucose assumption and smoking on the 10-year risk of developing coronary heart disease (Framingham dataset).
Customer Segmentation
🖥️ (better viewed in full screen mode)
Dashboard to inspect Recency, Frequency and Monetization of individual or segment of customers.
Cohort Retention and Churn
Lightweight and clean SQL code to calculate retention number/rate using CTEs and window functions.
A/B testing
📖
Notes on A/B Testing. Link to the actual project in the page.