/Faizs-Data-Portofolio

This documentation is like a quick snapshot of my project in the data field, showing off my skills and know-how in this area.

Faiz's Project Portfolio

Hi there! This documentation is like a quick snapshot of my project in the data field, showing off my skills and know-how in this area.

Table of Contens :



📂 Data Engineering

Project Link Associated Tools Project Description
⚠️ Fraud Detection for Online Transaction Pipeline IYKRA Python, GCP(Google Cloud Storage, BigQuery), Spark, Kafka, Looker Studio Developed and implemented an end-to-end ETL pipeline for processing online payment transaction data. The pipeline integrated batch and streaming processing, transformed raw data using Spark, built a data warehouse applying a fact and dimensional model, provided notifications when fraudulent activity was detected, and created a reporting dashboard with Looker Data Studio.


📂 Python: Data Analysis and Machine Learning

Project Link Associated Area Library Project Description
💰 Predict Loan Default Customers VIX - Home Credit Indonesia: Data Scientist Data Wraggling, EDA, Supervised Learning - Classification pandas, matplotlib, seaborn, scikit-learn, scipy Predicted customer defaults or customer would experience payment difficulties. Conducted data cleansing on raw data and analyzed over 100 features using statistical methods for feature selection. The best model achieved an accuracy of 87% and an AUC of 73% using Logistic Regression. Created a simulation by deploying a web application for loan approval prediction using Streamlit.
☎️ Telco Customer Churn FGA x Binar Academy: Data Science [Team] Data Wraggling, EDA, Supervised Learning - Classification pandas, matplotlib, seaborn, scikit-learn, shap Developed a machine learning model to predict customer churn in a telecom company. The Random Forest model yielded the highest accuracy score, reaching 89%, with the most influential feature being the total day charge. A higher charge indicates a higher potential for customer churn.
📲 Predict Clicked Ads Customer Classification Mini Project by Rakamin Academy Data Wraggling, EDA, Supervised Learning - Classification pandas, matplotlib, seaborn, scikit-learn, shap, etc Developed a machine learning model and experimented with various algorithms, ultimately determining that the Random Forest model achieved the best fit with accuracy of 96% in identifying potential users likely to click on advertisements. Analyzed key influential features with SHAP to enhance targeting for improved conversion rates and cost efficiency.
🙂 Predict Customer Personality to Boost Marketing Campaign Mini Project by Rakamin Academy Data Wraggling, EDA, Unsupervised Learning - Clustering pandas, matplotlib, seaborn, scikit-learn, yellowbrick Analyzed customer characteristics of a e-grocery store by creating a clustering model using K-means. Before to clustering, decomposition was performed, and the best cluster was determined using inertia score or distortion score. This resulted in 4 clusters based on customer behavior, considering factors such as the number of transactions, spending levels, response to campaigns, and website visit frequency.
🏬 Investigate Hotel Business using Data Visualization Mini Project by Rakamin Academy Data Wraggling, EDA, Data Visualization pandas, matplotlib, seaborn Analyzed the performance of City Hotels and Resort Hotels, identifying the frequently visited hotel type and exploring the relationships between booking cancellations, length of stay, and lead time through Python visualization. Identified potential causes for these patterns and provided business recommendations based on the analysis.
🚲 Data Quality Assessment and Customer Segmentation VIX - KPMG Australia: Data Analytic Consulting Data Wraggling, EDA, RFM analysis pandas, matplotlib, seaborn Developed and optimized a bike company market strategy by analyzing their data. Conducted a data quality assessment and identified strategies to mitigate any data quality issues. Performed customer segmentation using a simple RFM (Recency, Frequency, Monetary) analysis to recommend potential new customers for targeted marketing. Visualized insights about the targeted customer demographics on a dashboard.
🛒 Online Shoppers Purchasing Intention Final Project -Rakamin Academy [Team] Data Wraggling, EDA, Supervised Learning - Classification pandas, matplotlib, seaborn, scikit-learn, shap Built a model to predict which website visitors are likely to make a purchase or not. After testing several algorithms, Random Forest Hyperparameter Tuning demonstrated the best performance, achieving a ROC-AUC score of 90%. Through simulation, it was projected that this model could potentially increase the conversion rate by 58%.
✈️ Airline Customer Segmentation Based on LRFMC Model Using K-Means Assignment - Rakamin Academy [Team] Data Wraggling, EDA, Unsupervised Learning - Clustering pandas, matplotlib, seaborn, scikit-learn, yellowbrick Developed a clustering model employing LRFMC scores and the K-Means algorithm, resulting in the identification of 5 customer clusters: New Users, 20% are Loyal Customers, 19% are Potential Loyalists/The Champion, 18% are Need Attention, and 16% are Hibernating.


📂 SQL

Project Link Associated Area Tools Project Description
💳 Credit Card Customer Churn Analysis VIX - BTPN Syariah: Data Engineer Data analysis PosgreeSQL, DBeaver, Tableau for Visualization Created tables, loaded data in the database, and designed a star schema. Subsequently, conducted data exploration to identify customer profiles and characteristics related to churn. This analysis allowed for an examination of customer behavior based on demographic information, their relationship with the bank, and transaction history.
🛍 Maven Fuzzy Factory Advanced SQL: MySQL Data Analysis and Business Intelligence Data analysis MySQL, MySQL Workbench It is a course-based project aimed at analyzing the performance of an e-commerce business, answering various business questions using SQL, covering topics such as traffic, website measurement, product analysis, and user-level analysis. [Documentation is currently in progress.]
📦 Analyzing eCommerce Business Performance Mini Project by Rakamin Academy Data analysis PosgreeSQL, pgAdmin, Excel for Visualization Evaluated the business performance of e-commerce in Brazil by analyzing the growth in annual customer activity, annual product category quality, and annual payment type usage. The analysis utilized datasets containing information about customers, sellers, products, and orders.


📂 Dashboard

Project Link Associated Tools Project Description
👩🏻‍💻 Human Resource Attrition Analysis (EDA, data analysis) Challenge Task - IYKRA Tableau Joined tables within the dataset to conduct an analysis focused on identifying the demographic traits of employees who are more likely to leave the company, as well as an exploration of the factors that influence employee attrition.
🚕 Green Taxy Trip Monthly Report Challenge Task - IYKRA Looker Studio Created a monthly performance report for taxi services. The report provided information about revenue generated from taxi trips and analyzed the busiest zones, days, and hours for passenger activity.
💊 Sales Report Dashboard VIX - PT. Kimia Farma, Tbk: Big Data Analyst Looker Studio Created a data mart, analyzed the provided data, and generated sales reports for the company. Additionally, developed a dashboard that primarily focuses on sales data from a six-month period, including key performance indicatorssuch as total revenue per month, total sales per branch location, total sales by product, and more.
💉Indonesia Covid-19 Dashboard Challenge by Binar Academy [Team] Looker Studio, BingQuery Presented information about the update of COVID cases in Indonesia, such as new active cases, new confirmed cases, new deaths, and recoveries.
👩🏻‍💻Targeted Customer Demographic Dashboard VIX - KPMG Australia: Data Analytic Consulting Tableau This dashboard provides insights into the demographics of new customers to be targeted in marketing efforts after conducting prior customer segmentation analysis.


📂 Complated Course and Certification