-
1
Prerequisite: Mysql Installation (00:00)
-
MySQL Installation on Windows
-
MySQL Installation on Linux
-
MySQL Installation on Mac OS
-
-
2
DB Preparation (00:00)
-
Preparation
-
SQL Dummy Data - Preparation
-
Cara Import SQL FILE (Workbench)
-
-
3
Hari Pertama (00:00)
-
Sesi 1A - Introduction to Data Analysis
-
Sesi 2 - 2.1:Basic Database Terminology
-
Sesi 2 - 2.2:Database Design
-
Sesi 2 - 2.3 : Introduction Mysql & Workbench Overview
-
Sesi 2 - 2.4 : Overview MySQL Command & Data Types
-
Sesi 2 - 2.5 : DDL (Data Definition Language)
-
Sesi 2 - 2.6 : Basic DML & TCL
-
Sesi 2 - 2.7 : Mysql Select Commands
-
Sesi 2 - 2.8 : Mysql Operators & Function
-
Sesi 2 - 2.9 : MySQL JOIN Queries
-
Sesi 2 - 2.10 : Aggregate Functions
-
Sesi 2 - 2.11 : Database Indexing
-
Sesi 2 - 2.12 : Database Backup & Restore
-
MySQL ASSIGNMENT
-
-
4
Hari Kedua (00:00)
-
Sesi 3 - 3A Data Cleaning Techniques & Text Cleaning
-
Sesi 3 - 3B : Transforming Data into a Usable Format
-
Sesi 3 - 3C : Overview of Data Visualization
-
Sesi 3 - 3D : Overview of Looker Studio
-
Sesi 4 - 4A : Data Visualization using Looker Studio
-
Sesi 4 - 4B : Build Interactive Dashboards
-
-
5
Hari Ketiga (00:00)
-
Sesi 5 - 5a Persiapan Akun ChatGPT
-
Sesi 5 - 5b Pengenalan Generative AI
-
Sesi 5 - 5c Prompt yang efektif untuk Data Analisis dan Reporting
-
Sesi 5 - 5d Langkah Data Analysis dan Reporting dengan ChatGPT
-
Sesi 5 - 5e Assignment Pembuatan Laporan Analisa Data
-