Ahmad Faik Setiawan

About Me

Get to know my background, education, and the skills I bring to every project.

Data Scientist & Analyst

I’m a Data Analyst focused on transforming FMCG, marketplace, and social media data into actionable business insights. With experience in data analysis, market and competitor analysis, reporting, dashboard development, and machine learning-based forecasting, I use Python, SQL (Google BigQuery), Excel, Tableau, and Looker Studio to solve business problems and support data-driven decisions.

Data Analyst with hands-on experience analyzing FMCG, e-commerce, and social media data to generate actionable business insights. Proficient in Python, SQL (Google BigQuery), and Excel for data processing and data analysis, with expertise in visualization using Google Looker Studio and Tableau to communicate insights effectively to stakeholders. Experienced in leveraging AI agents to streamline reporting workflows and improve efficiency. Currently developing machine learning–based forecasting models to support FMCG market outlook and strategic planning.

EDUCATION

Data Science & Machine Learning

Purwadhika Digital Technology School

Mar 2025 – Jul 2025

Bachelor of Islamic Law

Al-Azhar University · Cairo, Egypt

Sep 2019 – Aug 2023

SKILLS

Data Wrangling Data Cleaning Exploratory Data Analysis Social Media Analysis Data Visualization Data Storytelling AI Agents Claude Code Orca Python Machine Learning Statistics SQL Google BigQuery Microsoft Excel Google Spreadsheets Google Colab Jupyter Notebook n8n Google Looker Studio Tableau Microsoft Power BI Canva Google Slide Microsoft PowerPoint Time Series Analysis Analytical Thinking Problem Solving Attention to Detail Stakeholder Communication Team Collaboration Strategic Project Management

CERTIFICATIONS

Data Science & Machine Learning

Purwadhika Digital Technology School

July 2025

View Certificate

Excel for Data Analytics

Microsoft

March 2026

View Certificate

Fundamentals of Database SQL

Coding Studio

January 2025

View Certificate

Python for Data Analytics

Coding Studio

January 2025

View Certificate

Microsoft Excel

Coding Studio

August 2025

View Certificate

Mini Course: Data Analytics

RevoU

March 2026

View Certificate

SQL Intermediate

HackerRank

October 2026

View Certificate

Best Student in Data Science Program

Purwadhika Digital Technology School

April 2026

View Certificate

Work Experience

My professional journey and the companies I've worked with.

Data Analyst

June 2025 - Present

Compas.co.id

Jakarta, Indonesia

Executed end-to-end data analytics projects for 30+ FMCG clients using SQL (Google BigQuery) and Excel, including social media data analysis across 5+ brands to support market research and business strategy.
Produced and delivered 70+ analytical reports and dashboards using Google Looker Studio and Google Slides, translating FMCG data into actionable insights for data-driven decision-making.
Optimized recurring reporting workflows using AI agents, reducing manual processing time by 50% and improving output consistency.
Built machine learning–based forecasting models with 85–95% accuracy to support FMCG market outlook and strategic planning

My Projects

Here are my recent data analytics, data science, and machine learning projects. Each project demonstrates different aspects of my technical and analytical capabilities.

E-Commerce Customer Churn Prediction

A smart customer retention tool that analyzes behavioral patterns and predicts churn risk in real time, empowering e-commerce teams to proactively save high-value customers.

Python Streamlit Machine Learning LightGBM

Code Report

Stock Management CLI

A command-line application for efficient stock data management with full CRUD functionality, built using Python and SQL for robust data handling.

Python SQL CLI CRUD

Code Report

Hotel Cancellation Prediction

This project aims to build a machine learning model to predict hotel booking cancellations. By analyzing historical booking data, the model assists hotels in optimizing overbooking strategies and improving revenue management.

Python Machine Learning XGBoost

Code Report

Unilever Stock Forecasting

Advanced time series analysis using Prophet to forecast UNVR stock prices. Includes trend analysis, seasonality detection, and investment decision-making insights with interactive visualizations.

Python Plotly Prophet Time Series Analysis Forecasting

Code Report

NYC Green Taxi Analysis

Comprehensive analysis of NYC green taxi trip data to optimize operational efficiency and revenue generation. Includes geospatial analysis, demand forecasting, and data-driven recommendations for taxi operations.

Python GeoJSON Tableau Geospatial Analysis Operational Efficiency

Code Report

E-Commerce Retention Analysis

Customer retention analysis for e-commerce platform identifying key loyalty drivers and strategies to boost retention. Includes cohort analysis, RFM segmentation, and actionable business recommendations.

Python Plotly Google Looker Studio Cohort Analysis RFM Analysis Churn Analysis Customer Segmentation

Code Report

Hello, It's Me

Ahmad Faik Setiawan

And I'm a Data Analyst

Transforming FMCG & E-Commerce Data Into Actionable Business Insights

About Me