Our Mentor

• Javas Alfreda - Senior Product Data Analyst - Link Aja
• Gerald Plakasa - Data Analyst - Pertamina
• Lingga Aji - Business Intelligence Analyst - Telkomsel
• Anugrah Akbar - AI Engineer - AlloBank

Kurikulum 

Modul 1 Overview of Data Analysis, Career, and Salary

• Overview of Data Analyst Career and Salary Part 1
• Overview of Data Analyst Career and Salary Part 2
• Overview of Data Analyst Career and Salary Part 3
• QnA

Modul 2 Boost Your Skills with Advanced Excel

• Overview
• Finding Insight: Sort & Filter (Part 1–2)
• Join Functions: VLOOKUP, XLOOKUP, INDEX MATCH, Pivot Table (Part 1–2)
• Statistics for Data Analyst & Conditional Formatting

Modul 3 Advanced Excel Skills for Data Analysts

• Overview
• Data Cleaning in Excel
• Data Validation
• Dashboard with Excel

Modul 4 Exploring the World of Statistics & Insight Analysis

• Overview
• Introduction to Statistics (Part 1–2)
• Descriptive vs Inferential Statistics
• Hypothesis Testing
• Statistical Tests
• Latihan Soal
• QnA

Modul 5 Ultimate Data-Driven Decisions

• Overview
• Understanding A/B Testing (Part 1–2)
• Mastering Correlation
• Regression Analysis for Predictive Modeling (Part 1–2)

Modul 6 Understanding Business Challenges (Part 1)

• OverviewIntroduction to Business Problems
• Business Frameworks
• Prioritizing Action to Improve Productivity
• Developing Hypotheses and Proving Them
• Identifying Root Causes
• QnA

Modul 7 Understanding Business Challenges (Part 2)

• Overview
• How Business Problems Relate to Analytics
• Business Goals & Metrics
• Determining a Good Metric (Part 1–2)
• Dashboard & Performance Monitoring
• Funnel Analysis

Modul 8 Foundation for Data Mastery with SQL

• Overview
• Databases & Data Types
• SQL Basics: What, Why, How
• SQL Fundamentals: SELECT, FROM, WHERE, LIMIT
• Hands-On (Part 1–3)

Modul 9 Boost Your SQL Skills

• Overview
• Ordering & Alias
• Aggregate Functions
• String & Character Functions
• DDL & DML
• Hands-On

Modul 10 Advanced SQL Mastery

• The SQL Mind Map
• Overview
• Advanced Aggregate Functions
• Advanced Text & Date Manipulation
• QnA
• Hands-On (Part 1–5)

Modul 11 SQL for Real-World Analysis

• Overview
• Join Concept
• Join Hands-On (Part 1–3)
• Cross Join
• UNION
• CASE WHEN

Modul 12 Ultimate SQL Techniques

• Overview
• Subqueries
• CTE (Common Table Expression)
• Window Functions
• Hands-On (Part 1–3)

Modul 13 Python for Absolute Beginners

• Overview
• Understanding Python
• Variables, Data Types & Operators (Part 1–3)
• Python Data Structures (Part 1–2)
• Latihan Soal

Modul 14 Python Essentials for Data Analysts

• Overview
• Conditional Statements & Loops (Part 1–2)
• Built-In & User-Defined Functions
• Error Handling (Try-Except)
• NumPy Essentials
• QnA

Modul 15 Unlock the Power of Python for Data Analysis

• Tableau Basics
• Intro to Pandas
• Data Manipulation with Pandas (Part 1–5)
• Data Analysis & Statistics
• QnA

Modul 16 Mastering Data Cleaning with Python

• Overview
• Advanced Processing & Merging Data
• Cleaning & Transformation (Part 1–3)
• Efficient Storage with Python Pickle

Modul 17 Exploratory Data Analysis (EDA) & Visualization

• Overview
• EDA Fundamentals (Part 1–3)
• Matplotlib Basics
• Hands-On (Part 1–2)

Modul 18 Handling Big Data Like a Pro

• Overview
• RFM Segmentation
• K-Means Clustering (Part 1–2)
• Running A/B Test
• QnA

Modul 19 Advanced Python Hacks

• Overview
• Logistic Regression Introduction
• Propensity Score Model
• Logistic Regression Modeling
• Evaluating Model Performance
• QnA

Modul 20 Mastering Propensity Models for Business Insights

• Overview
• Deep Dive Logistic Regression
• Evaluation Metrics (Part 1–2)
• Hands-On (Part 1–2)
• QnA

Modul 21 Tableau for Beginners: Tell Stories with Data

• Understanding the Fundamentals
• Creating Insight (Part 1–2)
• Getting Started with Tableau
• Study Case

Modul 22 Data Preparation in Tableau (Beginner → Advanced)

• Overview
• Tableau Data Types
• Discrete vs Continuous
• Working with Date & Hierarchy
• Grouping Data
• Sets & Bins (Part 1–2)
• Using Parameters
• QnA

Modul 23 Creating Impactful Dashboards in Tableau

• Overview
• Calculation Fields (Part 1–3)
• Exploratory Data Analysis (Part 1–2)
• Designing Dashboard

Modul 24 — Advanced Visualizations & Mapping

• Overview
• Storytelling Maps
• Interactive Maps
• Advanced Maps (Part 1–2 & 4)

Modul 25 Advanced Tableau for Data Insights

• Overview
• Advanced Charts
• Visualization Tools (Part 1–3)

Modul 26 The Art of Data Storytelling

• Overview
• Data Storytelling Concepts
• Preparation
• Choosing the Right Visualization
• Crafting Great Narratives
• Additional Techniques

Modul 27 Ultimate Guide to Machine Learning

• Overview
• Definition & Scope
• Machine Learning Types
• Intro to Supervised Learning (Part 1–2)
• QnA

Modul 28 Find Insights with Advanced Machine Learning

• Overview
• Choosing Best Model (Part 1–2)
• Overfitting vs Underfitting
• Cross Validation
• Hyperparameter Tuning
• End-to-End ML Project
• QnA

Modul 29 Machine Learning Optimization & Deployment

• Overview
• Evaluating Model
• Unsupervised Learning
• Recommendation System