Hi, I'm
RAFIQ NAUFAL KASTARA
Data Analyst well versed in Business Intelligence and Machine Learning
Data Analytics Portfolio
ABOUT ME
Call me Rafiq,
I’m passionate about transforming raw information into meaningful insights that support smarter decision-making. With strong critical thinking, attention to detail, and analytical skills, I enjoy uncovering patterns, solving problems, and presenting findings in a clear and actionable way.
Through various data analysis projects, I’ve developed not only technical skills but also experience in project management, and collaboration. I’m driven by curiosity and continuous learning, and I’m committed to expanding my abilities as I grow in the data field..
TECHNICAL SKILLS
Statistics and Excel
Perform EDA, statistical measurements, A/B testing (t-test), and regression analysis.
SQL and Database
Use CTEs and window functions for data processing, and build datamarts for data warehousing.
Machine Learning
Create customer segmentation with K-Means and build order prediction models using XGBoost.
Data Visualization
Create advanced interactive dashboards in data visualization tools like Looker Studio and Tableau.
PROJECT
AI Agent
SmartLook
SmartLook is a generative business intelligence and text-to-SQL agent that analyzes datasets from an e-commerce company, detects trends, and generates accurate SQL queries and visualizations to support business analysis tasks. The system features an intuitive React interface that accelerates insight generation, automates exploratory analysis, and reduces manual effort for analysts.
Statistics & Regression
ABC Company Analysis
Analyzed property listing data from ABC Company (Malaysia) using descriptive statistics and exploratory data analysis (EDA) to uncover key market patterns and business drivers. Built and evaluated a linear regression model to predict property prices and identify high-impact features influencing valuation. Delivered insights and data-driven recommendations aimed at supporting the company’s goal of increasing revenue by 10% within one year.
XGBoost Classification
Customer Conversion Prediction
Built an XGBoost classification model to predict customer conversion and identify key drivers influencing whether users place an order. Conducted exploratory data analysis (EDA) to uncover behavioral and transactional patterns. Performed cohort analysis to measure customer retention over time, identify drop-off points, and understand lifecycle behavior. Delivered insights to improve the restaurant discovery experience and boost overall conversion rates.
Statistics & A/B Testing
Campaign’s Effect on Sales
Conducted exploratory data analysis (EDA) and A/B testing using t-tests to measure the impact of multiple marketing campaigns on the sales performance of a new menu item for a fast-food chain. Built a linear regression model to predict sales and identify key factors driving performance across stores. Provided data-driven recommendations to determine which campaign delivered the strongest lift in sales.
User Segmentation & Churn Prediction
K-Means & Benefit–Cost Analysis
Performed exploratory data analysis (EDA) and applied K-Means clustering to segment users based on investment behavior for an Indonesian investment startup. Built a logistic regression model to predict user churn and evaluated key factors driving user retention. Conducted a benefit–cost analysis to assess the financial impact of each segment and delivered targeted campaign recommendations aligned with user preferences and potential ROI.
User Retention & Product Growth Analysis
TheLook e-commerce Analysis
Executed SQL-based cohort analysis to evaluate user retention patterns and understand long-term customer behavior for TheLook, an e-commerce clothing company. Analyzed product performance trends and applied the BCG Matrix to identify categories with low growth and prioritize strategic actions during the company’s 2023 optimization phase. Delivered insights to guide product focus, retention improvement, and resource allocation.
Data Visualization
Samba E-Commerce Dashboard
Samba E-Commerce is an e-commerce from Brazil that wants to maximize sales by means of data-driven decision making. The objective of this analysis is to Create an interactive executive dashboard for data data-driven decision-making.