Brian
Naufal

Data Analyst turning operational data into actionable insights for FMCG and marketplace industries.

Python SQL Excel Tableau Power BI Looker Studio PowerPoint Machine Learning
Brian Naufal
Available for work

Projects

Explore business insights, predictive models, interactive dashboards, and practical AI applications.

View GitHub ↗

Showing all 12 projects

Top Projects

Four selected projects across analytics, data science, dashboards, and applied AI.

Illustration of the AI Meeting-to-Action workflow: n8n and Python turn audio and transcripts into Word, PowerPoint and Excel
Applied AISoftware & Automation

AI Meeting-to-Action

Built a locally hosted Python and n8n workflow that turns recordings or transcripts into readable dialogue, Word summaries, and optional editable presentations and Excel action plans.

Key Design Decision: Source-linked evidence, visible review flags, resumable stages and cost controls keep generated outputs reviewable.
Adidas Sales Performance & Revenue Optimization
Data Analytics

Adidas Sales Performance & Revenue Optimization

Built an end-to-end MySQL sales analytics case study to evaluate revenue, profitability, product, regional, retailer, and sales-method performance — from raw-data validation through executive reporting.

Key Insight: Revenue increased 294.2% in 2021, while the West region led revenue but had the lowest regional margin. Men's Street Footwear was the largest product contributor, and an evidence-based screen flagged 8 product-region combinations for further investigation.
Makan Bergizi Gratis (MBG): YouTube Sentiment Analysis, Text Mining & Discussion Pattern Analysis
Data Science

Makan Bergizi Gratis (MBG): YouTube Sentiment Analysis, Text Mining & Discussion Pattern Analysis

Analyzed 12,000 Indonesian YouTube comments related to MBG through data-quality control, duplicate-leakage prevention, sentiment classification, model benchmarking, explainability, and conservative coordination-pattern screening.

Key Insight: TF-IDF + Logistic Regression achieved validation Macro F1 of 0.758 and test Macro F1 of 0.724, while the coordination extension retained 4 repeated-text patterns for descriptive review and 0 strict multi-signal commenter candidates.
Indonesia EV Market & Value Analysis
Data AnalyticsDashboards

Indonesia EV Market & Value Analysis

Built an interactive Power BI dashboard comparing electric vehicle models sold in Indonesia across price, driving range, battery capacity, motor power, and charging time — with an interactive budget-fit simulation.

Key Insight: A value-for-money metric surfaces which EVs offer the strongest range per rupiah, while the budget simulation page lets users instantly filter eligible models under a chosen price ceiling — turning fragmented specs into a single decision-support view.

More Projects

More work in data exploration, machine learning, and software automation.

AI Job Market Copilot dashboard thumbnail
Data AnalyticsApplied AIDashboards

AI Job Market Copilot

Built a local-first career intelligence prototype that explores 1,658 ranked job postings, presents rule-based fit and skill-gap signals, and generates contextual career insights with Ollama and Qwen3 4B.

Key Design Decision: The official fit score remains separate from LLM-generated suggestions. Missing or heuristic requirements are surfaced for verification rather than treated as confirmed eligibility.
Airbnb Bangkok
Data AnalyticsDashboards

Airbnb Bangkok — Listing & Pricing Analysis

Analyzed 15,000+ Bangkok listings to identify pricing drivers, high-demand neighborhoods, and occupancy patterns. Delivered a Tableau dashboard enabling hosts to benchmark performance and optimize pricing strategy.

Key Insight: Review count is the strongest occupancy predictor — listings with more reviews show lower availability (higher occupancy). Pathum Wan & Nong Chok emerged as premium areas with the highest median prices, while Entire Home/Apartment demonstrated the most stable price and occupancy performance.
Hotel Booking
Data Science

Hotel Booking Cancellation Prediction

Built an XGBoost classification model to predict booking cancellations, enabling proactive revenue management and inventory planning for hospitality teams.

Key Insight: Bookings with Non-Refund Deposit are significantly less likely to be cancelled, while customers with a high cancellation history carry the greatest risk of cancelling again. More special requests correlate with lower cancellation likelihood. Model optimized for Recall & F1-Score — top features: Deposit Type, Previous Cancellations, Market Segment.
Telemarketing Term Deposit
Data AnalyticsData ScienceDashboards

Optimizing Telemarketing for Term Deposit Subscriptions

Analyzed a bank's telemarketing campaign dataset to predict which customers are most likely to subscribe to a term deposit. Combined EDA, Logistic Regression, and a live Streamlit app — enabling sales teams to prioritize high-conversion leads and reduce wasted call volume.

Key Insight: Previous campaign outcome (poutcome) is the strongest conversion predictor — customers with a positive history have a significantly higher subscription probability. Contact timing & channel also have substantial impact, while demographic factors play a smaller role. The model helps telemarketing teams prioritize high-value prospects and reduce campaign costs.
Streaming Platform Analytics Dashboard
Data AnalyticsDashboards

Streaming Platform Analytics Dashboard

Designed a Power BI dashboard turning streaming-activity data into insight on user engagement, content performance, package tiers, and regional behavior — from a national overview down to province-level drill-down.

Key Insight: A dedicated province drill-down page lets stakeholders move from a national overview straight into local content, package, and demographic trends for any selected province, closing the gap between headline KPIs and regional decision-making.
Movie Analytics Dashboard (OMDB API)
Data AnalyticsDashboards

Movie Analytics Dashboard (OMDB API)

Built a fully automated movie analytics pipeline using the OMDB public API — ingesting data into BigQuery and visualizing genre trends, ratings distribution, and box office patterns via a Looker Studio dashboard.

Key Insight: An automated data pipeline was built from OMDB Public API → BigQuery → Looker Studio, demonstrating end-to-end data engineering capability. The executive dashboard surfaces genre trends, IMDb rating distributions, and movie performance by release year.
OLX Used Cars
Data AnalyticsData Science

OLX Used Cars — Market Price Analysis

Scraped 5,000+ used car listings from OLX Indonesia to analyze depreciation curves, brand-specific pricing, and mileage impact on resale value.

Key Insight: Toyota dominates the Jakarta used car market in both listing frequency and model variety, reflecting strong brand trust in Indonesia. Ridge Regression achieved the best performance (Test RMSE: 144M IDR) with optimal generalization, while tree-based models suffered from overfitting on this heterogeneous dataset.
BrINV — FMCG Inventory Management System
Software & Automation

BrINV — FMCG Inventory Management System

Built a Python-based inventory management simulation for FMCG warehouse operations, covering CRUD, product and batch traceability, inventory valuation, low-stock monitoring, and local data persistence.

Key Insight: Maps a simplified warehouse workflow into functional requirements, validation controls, operational KPIs, and inventory actions — bridging software implementation with business-process thinking.

Experience

R&D Packaging Staff Mar 2025 – Sep 2025

Kino Indonesia

  • Analyzed packaging performance data to support R&D decision-making and material selection
  • Conducted packaging trials and generated structured reports on compatibility and quality metrics
  • Coordinated with cross-functional teams to maintain packaging quality standards across product lines
Product Development Intern Feb 2023 – Jan 2024

Kalbe Nutritionals

  • Supported product formulation trials and documented experimental results with structured data analysis
  • Collaborated with R&D team on ingredient optimization — developing structured experimental thinking
  • Applied data interpretation skills to evaluate trial outcomes and present findings to senior researchers

Skills & Expertise

SQL Queries

Database management, complex joins, window functions, ETL pipelines, and query optimization.

PostgreSQL MySQL BigQuery
Tableau & Looker Studio

Building interactive dashboards and BI reports for cross-functional stakeholders.

Tableau Looker Studio Power BI
Python & Pandas

Data wrangling, EDA, automation scripts, and pipeline development using Python ecosystem.

Pandas NumPy Matplotlib Seaborn
Statistics

Hypothesis testing, probability distributions, regression analysis, and experimental design.

A/B Testing Hypothesis Testing Regression
Machine Learning

Hands-on experience with supervised and unsupervised learning — from classical algorithms to ensemble methods and model evaluation at basic-to-intermediate level.

Scikit-learn Logistic Regression Linear Regression Decision Tree Random Forest XGBoost LightGBM KNN SVM K-Means Clustering PCA Cross Validation Hyperparameter Tuning SMOTE Feature Engineering
Microsoft Excel

Data processing, analysis, and reporting using Excel's core and advanced features for business and operational use cases.

Pivot Table VLOOKUP / XLOOKUP IF / IFS Conditional Formatting Data Validation Charts & Graphs Power Query
Microsoft PowerPoint

Creating structured, visually compelling presentations to communicate data insights and project results to both technical and non-technical audiences.

Slide Design Data Storytelling Chart Integration Executive Summary Infographics

Education

🎓

Purwadhika Digital School

Data Science & Machine Learning

Sep 2025 – Dec 2025

Intensive program covering data analysis, machine learning, model evaluation, dimensionality reduction, and responsible AI through hands-on real-world projects.

🏛️

BINUS University

Bachelor of Food Technology

Sep 2020 – Nov 2024

Specialized in product development, food processing, and quality analysis. Strong foundations in laboratory data interpretation, experimental design, and technical reporting.

Let's build something
impactful together.

Open to full-time Data Analyst roles and freelance consultancy in Jakarta & remote.

Phone +62-812-8800-1061
Location Jakarta, Indonesia