DATA ANALYTICS (Advanced Level)

Durasi : 09.00 – 16.00 WIB

Description Training

Di era AI dan data-driven organization, peran Data Analytics telah berkembang dari sekadar reporting menjadi predictive dan prescriptive decision support. Pelatihan ini dirancang untuk membekali peserta dengan kemampuan tingkat lanjut dalam mengelola data skala besar, melakukan advanced statistical analysis, predictive analytics, machine learning untuk bisnis, data storytelling, serta membangun dashboard dan insight yang mampu mendukung pengambilan keputusan strategis. Materi mengacu pada tren Data Analytics 2026 yang mencakup AI-assisted analytics, predictive modeling, advanced SQL, Python analytics, business intelligence, data governance, dan explainable AI. 

Training Objective

Setelah mengikuti pelatihan ini, peserta akan mampu:

1. Memahami framework modern Data Analytics dan AI Analytics.
2. Mengolah dan membersihkan data kompleks secara efisien.
3. Melakukan Exploratory Data Analysis (EDA) tingkat lanjut.
4. Menggunakan Advanced SQL untuk analytical query.
5. Mengembangkan predictive model untuk kebutuhan bisnis.
6. Melakukan forecasting dan trend analysis.
7. Membuat dashboard executive level yang efektif.
8. Menginterpretasikan hasil machine learning untuk pengambilan keputusan.
9. Mengimplementasikan data governance dan data quality management.
10. Menyusun rekomendasi bisnis berbasis data.

Siapa yang disarankan untuk mengikuti Pelatihan ini ?

Senior Analyst, Business Analyst, Data Analyst, BI Analyst, Data Engineer, Finance Analyst, Marketing Analyst, Operation Analyst, Supervisor, Manager, dan Professional yang telah memiliki pemahaman dasar analytics.

Training Outline

HARI 1 : ADVANCED DATA ANALYTICS FOUNDATION & DATA ENGINEERING 

Session 1 – Modern Analytics Framework 2026

* Evolution of Data Analytics

* Data Analytics vs Data Science vs Business Intelligence

* Analytics Maturity Model

* Descriptive, Diagnostic, Predictive & Prescriptive Analytics

* AI-Powered Analytics Trends

* Building Data-Driven Organization

Session 2 – Data Architecture & Data Engineering for Analytics

* Structured vs Unstructured Data

* Data Warehouse & Data Lake

* ETL vs ELT Architecture

* Data Pipeline Fundamentals

* Data Integration Concepts

* Real-Time Analytics Architecture

Session 3 – Advanced SQL for Analytics

* Analytical SQL Framework

* Common Table Expressions (CTE)

* Window Functions

* Ranking & Partition Analysis

* Cohort Analysis

* Recursive Queries

* Performance Optimization

* Query Tuning

Workshop : Analytical SQL for Customer & Sales Data

HARI 2 : ADVANCED DATA PREPARATION & STATISTICAL ANALYSIS 

Session 4 – Data Cleaning & Data Wrangling

* Missing Value Treatment

* Outlier Detection

* Data Transformation

* Data Standardization

* Feature Engineering

* Data Quality Assessment

Session 5 – Advanced Exploratory Data Analysis (EDA)

* Distribution Analysis

* Correlation Analysis

* Multivariate Analysis

* Pattern Recognition

* Customer Segmentation Analysis

* Anomaly Detection

Session 6 – Advanced Statistics for Analytics

* Probability Distribution

* Confidence Interval

* Hypothesis Testing

* T-Test

* ANOVA

* Chi-Square Test

* Bayesian Thinking

* Statistical Decision Making

Workshop : Business Performance Analysis Using Real Dataset

HARI 3 : PREDICTIVE ANALYTICS & MACHINE LEARNING FOR BUSINESS 

Session 7 – Predictive Analytics Fundamentals

* Predictive Modeling Framework

* Business Problem Formulation

* Model Selection Strategy

* Training & Testing Dataset

* Cross Validation

Session 8 – Machine Learning for Business Analytics

* Regression Models

* Logistic Regression

* Decision Tree

* Random Forest

* Gradient Boosting

* XGBoost Overview

* Model Evaluation Metrics

Session 9 – Customer & Business Intelligence Modeling

* Customer Churn Prediction

* Sales Forecasting

* Customer Lifetime Value Analysis

* Demand Forecasting

* Risk Scoring Model

* Fraud Detection Analytics

Session 10 – Explainable AI (XAI)

* Model Interpretability

* Feature Importance

* SHAP Analysis

* Bias Detection

* Ethical AI

* Responsible Analytics

Workshop : Building Predictive Analytics Model

HARI 4 : BUSINESS INTELLIGENCE, DATA STORYTELLING & CAPSTONE PROJECT

Session 11 – Advanced Data Visualization

* Data Visualization Principles

* Executive Dashboard Design

* KPI Framework

* Interactive Dashboard Development

* Storytelling with Data

* Visual Analytics

Session 12 – Power BI / Tableau Advanced Analytics

* Data Modeling

* Advanced DAX

* Calculated Measures

* Drill Through Analysis

* Forecasting Features

* Dashboard Automation

Session 13 – Data Governance & Analytics Management

* Data Governance Framework

* Data Quality Management

* Master Data Management

* Data Security

* Privacy & Compliance

* Analytics Governance

Session 14 – From Insight to Decision

* Translating Insight into Business Action

* Decision Intelligence

* Executive Presentation Techniques

* Analytics ROI Measurement

* Strategic Recommendation Framework

CAPSTONE PROJECT

Peserta akan mengerjakan studi kasus end-to-end:

Pilihan Studi Kasus

* Sales & Revenue Analytics

* Manufacturing Analytics

* Supply Chain Analytics

* Customer Analytics

* Financial Analytics

* HR Analytics

Output yang dihasilkan:

* Data Cleaning Report

* Exploratory Data Analysis

* Predictive Model

* Interactive Dashboard

* Executive Business Recommendation

TOOLS YANG DIGUNAKAN

• Microsoft Excel Advanced
• Power Query
• Power Pivot
• SQL (MySQL/PostgreSQL)
• Python (Pandas, NumPy)
• Power BI
• Tableau
• ChatGPT / AI Analytics Assistant
• Jupyter Notebook

STUDI KASUS INDUSTRI

• Manufacturing Analytics
• Retail Analytics
• Banking & Financial Analytics
• FMCG Analytics
• Supply Chain Analytics
• Human Capital Analytics
• Marketing Analytics

Metode Pelatihan

Kegiatan pelatihan dirancang agar peserta dapat memahami secara komprehensif materi yang disampaikan, sehingga dapat dimplementasikan secara aplikatif dalam dunia kerja. Adapun metode yang digunakan adalah:

• Pre and Post Test
• Interactive Lecture
• Hands-on Lab
• Case Study
• Group Discussion
• Business Simulation
• Capstone Project
• Evaluasi Training

Trainer : Spectracentre Trainer Team