DATA ANALYST PORTFOLIO
MUHAMMAD
GARDIAN
NOVANDRI
I help people finding insights
through data
About Me
Hello,
I’m Gardi!
Data Analyst and Certified Banking Generalist with a proven track record in various analytical roles, showcasing expertise in end-to-end business processes within the Banking / Financial Industry Proficient in SQL, Python, Google Sheets, Microsoft Excel, Statistics, Tableau, and Google Looker Studio for comprehensive data analysis and visualization. Comfortable with end-to-end data analysis, data processing, dashboard / daily reporting creation, and presenting actionable insights with effective communication and engaging story-telling skills.
Technical Skills
- EDA
- Segmentation / Clustering
- Cohort
- Linear Regression
- Logistic Regression
- Statistic
- A/B Testing
- ANOVA
- (Post-Hoc) T-Test
Education & Experience Background
Notable Projects
01
UBER PRICING OPTIMIZATION
IN NEW YORK CITY
An end-to-end analysis about finding out the best pricing model for uber booking in New York City to increase the revenue by doing Linear Regression to find out the impact of each variables of uber booking, evaluate the existing pricing model (High Fare and Discounted Fare application), do impact analysis and give recommendation of the best uber booking pricing. This analysis resulting a better model of Uber Pricing that is proven to increase 11.5% revenue.
Tools : Python (Google Collab), Tableau
Analysis : EDA, Linear Regression
02
IBM EMPLOYEE ATTRITION
PREDICTION AND STRATEGY 2023
A project focusing on how to decrease employee attrition rate of IBM company by doing Logistic Regression to predict the existing employee attrition, planning strategy to make a better and fair condition of the employee, and find out how much the strategy can affect the decreasing of employee attrition rate. This analysis resulting strategy to decrease employee attrition that is predicted to decrease 3.41% employee attrition.
Tools : Python (Google Collab), Tableau
Analysis : EDA, Logistic Regression
03
FAST FOOD MARKETING CAMPAIGN
A/B TESTING
A project with the main goal of determining the most profitable campaign in a fast food chain by doing A/B Testing. The marketing team runs 3 type of campaigns and the stores area categorized by 3 type of market sizes. ANOVA test is chosen for the statistical and hypothesis test, and Post-Hoc T-test is applied after. This Analysis resulting of the chosen campaign that is significantly profitable than the others.
Tools : Google Sheet / Excel
Analysis : EDA, Statistic, A/B Testing (ANOVA & Post Hoc T-test)
04
E-COMMERCE COHORT ANALYSIS
AND RFM SEGMENTATION
A project to boost the retention rate of an E-Commerce company by doing clustering with RFM Segmentation to strategize the treatments for each segments in order to retain them as our customers and do the Cohort Analysis to find out the maximum range of CLTV, CAC, and CRC to be used by Marketing Team. This analysis resulting treatment strategies to increase the retention rate for each RFM Segments and expected to increase retention rate 5.8% - 23.4%.
Tools : SQL (BigQuery), Python (Google Collab), Google Sheets, Google Looker Studio
Analysis : EDA, RFM Segmentation, Cohort Analysis
Contact Info
Let’s connect and work together!