Master Index & Curriculum Overview

Comprehensive syllabus, formula cheat sheet, and learning objectives

Master Index: Introduction to Data Analytics (CE KMITL)

Welcome to the comprehensive study guide series for Introduction to Data Analytics, Department of Computer Engineering, Faculty of Engineering, King Mongkut’s Institute of Technology Ladkrabang (CE KMITL).

This repository provides rigorous, token-efficient Markdown lecture notes synthesized directly from the course slide curriculum (materials/). All progressive animation sequences have been deduplicated into unified reference tables and worked examples, mathematical expressions are standardized in KaTeX/LaTeX, and process lifecycles are visualized with Mermaid diagrams.


1. Important Note: Dedicated Personal Study Note

In addition to the official lecture curriculum, review the standalone foundational note on model validation:

πŸ“˜ K-Fold Cross-Validation
A dedicated personal guide covering the mathematical mechanics, fold partitioning logic, and variance reduction properties of KK-fold cross-validation.


2. Master Curriculum Table

The course curriculum systematically covers the complete end-to-end data analytics lifecycle across 7 primary lecture modules:

Lecture # Module Title & Study Guide Link Core Topics & Key Algorithms Source Material Reference
01 01. Introduction to Data Analytics β€’ DIKW Hierarchy (Data, Information, Knowledge, Wisdom)
β€’ 4 Analytics Types: Descriptive, Diagnostic, Predictive, Prescriptive
β€’ CRISP-DM Lifecycle (Business Understanding to Deployment)
β€’ Data Roles, Tools (Python, SQL, BI), and Ethics
materials/DA01 - Introduction.pdf
02 02. Data Processing & Cleansing β€’ Data Quality Issues (Missing values, Noise, Redundancy)
β€’ Outlier Detection via Interquartile Range (IQR) Fences
β€’ Data Transformation: Min-Max Normalization, Z-Score Standardization
β€’ Feature Encoding: One-Hot Encoding, Label Encoding, Discretization
materials/DA04 - Data Processing.pdf
03 03. Data Exploration & Visualization β€’ 5-Number Summary: Min, Q1Q_1, Median (Q2Q_2), Q3Q_3, Max
β€’ Distribution Analysis: Histograms, Box Plots, Density Plots
β€’ Bivariate Relationships: Scatter Plots, Pearson Correlation Heatmaps
β€’ Matplotlib & Seaborn Visualization Workflows
materials/DA05 - Data Exploration.pdf
04 04. AI & Machine Learning Foundations β€’ AI vs. Machine Learning vs. Deep Learning Taxonomy
β€’ Supervised vs. Unsupervised vs. Reinforcement Paradigms
β€’ Simple & Multiple Linear Regression: y=wTx+by = \mathbf{w}^T \mathbf{x} + b
β€’ Loss Functions: MAE, MSE, RMSE, R2R^2 Score
β€’ Optimization via Gradient Descent: w:=wβˆ’Ξ±βˆ‚Jβˆ‚ww := w - \alpha \frac{\partial J}{\partial w}
materials/DA06-07 AI-ML-Intro.pdf
05 05. Decision Tree Classification β€’ Classification Concept & Tree Anatomy (Root, Decision, Leaf Nodes)
β€’ Shannon Entropy: H(S)=βˆ’βˆ‘pilog⁑2(pi)H(S) = -\sum p_i \log_2(p_i)
β€’ Conditional Entropy: H(S∣A)H(S \mid A) & Information Gain: IG(S,A)IG(S, A)
β€’ Complete 7-Sample Medical Diagnosis (Flu) Calculation Walkthrough
β€’ Splitting Criteria & Overfitting Prevention (Pruning)
materials/DA07.1 Decision Tree.pdf
06 06. Cluster Analysis (Unsupervised Learning) β€’ Unsupervised Clustering: Intra-cluster vs. Inter-cluster Distances
β€’ Distance Metrics: Euclidean (L2L_2) and Manhattan (L1L_1) Norms
β€’ K-Means Algorithm (Lloyd’s), Objective SSE, 1D 3-Round Iteration Table
β€’ Determining KK: The Elbow Method and Silhouette Coefficient (s(i)s(i))
β€’ DBSCAN: Density parameters (Ξ΅,MinPts\varepsilon, \text{MinPts}), Core/Border/Noise
β€’ Dimensionality Reduction: SVD and Principal Component Analysis (PCA)
materials/DA08 - Clustering.pdf
07 07. Classification Evaluation & Performance Metrics β€’ Train-Test Split & Validation Strategy
β€’ 2Γ—22 \times 2 Confusion Matrix: TP,TN,FP,FNTP, TN, FP, FN & 8-Scenario Evaluation Drill
β€’ Class Imbalance Paradox & The β€œWe Need FISH” Intuition
β€’ Performance Metrics: Accuracy, Precision, Recall/TPR, Specificity/TNR, F1F_1-Score
β€’ Consolidated 5-Exercise Evaluation Table
β€’ Receiver Operating Characteristic (ROC Curve) & Area Under Curve (AUC)
β€’ Multi-Class Evaluation: Macro, Micro, and Weighted Averaging
materials/AI-Classification-Evaluation.pdf

3. Course Concept Flow & Knowledge Graph

The diagram below illustrates the hierarchical dependencies and sequential learning path through the curriculum:

flowchart TD subgraph Phase1["Phase 1: Analytics Foundations & Preprocessing"] DA01["01. Introduction to Data Analytics\n(DIKW, 4 Analytics Types, CRISP-DM)"] DA04["02. Data Processing & Cleansing\n(Missing Values, IQR Outliers, Scaling)"] DA05["03. Data Exploration & Visualization\n(5-Number Summary, Boxplots, Heatmaps)"] DA01 --> DA04 --> DA05 end subgraph Phase2["Phase 2: Supervised Learning & Predictive Modeling"] DA06["04. AI & Machine Learning Foundations\n(Linear Regression, Cost Functions, Gradient Descent)"] DA07["05. Decision Tree Classification\n(Entropy, Information Gain, ID3 Flu Walkthrough)"] DA05 --> DA06 DA06 --> DA07 end subgraph Phase3["Phase 3: Unsupervised Pattern Discovery"] DA08["06. Cluster Analysis\n(K-Means SSE, DBSCAN Density, PCA)"] DA05 --> DA08 end subgraph Phase4["Phase 4: Model Evaluation & Validation"] EVAL["07. Classification Evaluation\n(Confusion Matrix, F1-Score, ROC/AUC)"] KFOLD["Dedicated Personal Note:\nK-Fold Cross-Validation\n(/notes/k-fold-cross-validation)"] DA06 --> EVAL DA07 --> EVAL EVAL -.->|Validation Methodology| KFOLD end DA08 -.->|Unsupervised Validation| EVAL

4. Course-Wide Quick Formula Reference Cheat Sheet

For fast exam review and implementation reference, key mathematical equations across all modules are indexed below:

Domain Equation Name Standard LaTeX Formula Primary Module
Data Cleaning IQR & Outlier Bounds IQR=Q3βˆ’Q1\text{IQR} = Q_3 - Q_1
Fences=[Q1βˆ’1.5β‹…IQR,β€…β€ŠQ3+1.5β‹…IQR]\text{Fences} = [Q_1 - 1.5 \cdot \text{IQR}, \; Q_3 + 1.5 \cdot \text{IQR}]
Lecture 02
Data Scaling Min-Max Scaling xscaled=xβˆ’xmin⁑xmaxβ‘βˆ’xmin⁑x_{\text{scaled}} = \frac{x - x_{\min}}{x_{\max} - x_{\min}} Lecture 02
Data Scaling Z-Score Standardization z=xβˆ’ΞΌΟƒz = \frac{x - \mu}{\sigma} Lecture 02
Regression Loss Mean Absolute Error (MAE) MAE=1nβˆ‘i=1n∣yiβˆ’y^i∣\text{MAE} = \frac{1}{n} \sum_{i=1}^n |y_i - \hat{y}_i| Lecture 04
Regression Loss Mean Squared Error (MSE) MSE=1nβˆ‘i=1n(yiβˆ’y^i)2\text{MSE} = \frac{1}{n} \sum_{i=1}^n (y_i - \hat{y}_i)^2 Lecture 04
Regression Loss Root Mean Squared Error RMSE=1nβˆ‘i=1n(yiβˆ’y^i)2\text{RMSE} = \sqrt{\frac{1}{n} \sum_{i=1}^n (y_i - \hat{y}_i)^2} Lecture 04
Optimization Gradient Descent Update wj:=wjβˆ’Ξ±βˆ‚J(w)βˆ‚wjw_j := w_j - \alpha \frac{\partial J(\mathbf{w})}{\partial w_j} Lecture 04
Information Theory Shannon Entropy H(S)=βˆ’βˆ‘i=1cpilog⁑2(pi)H(S) = - \sum_{i=1}^c p_i \log_2(p_i) Lecture 05
Information Theory Conditional Entropy H(S∣A)=βˆ‘v∈Values(A)∣Sv∣∣S∣H(Sv)H(S \mid A) = \sum_{v \in \text{Values}(A)} \frac{|S_v|}{|S|} H(S_v) Lecture 05
Information Theory Information Gain (IG) IG(S,A)=H(S)βˆ’H(S∣A)\text{IG}(S, A) = H(S) - H(S \mid A) Lecture 05
Distance Metric Euclidean Distance (L2L_2) d(x,y)=βˆ‘i=1d(xiβˆ’yi)2d(\mathbf{x}, \mathbf{y}) = \sqrt{\sum_{i=1}^d (x_i - y_i)^2} Lecture 06
Distance Metric Manhattan Distance (L1L_1) d(x,y)=βˆ‘i=1d∣xiβˆ’yi∣d(\mathbf{x}, \mathbf{y}) = \sum_{i=1}^d |x_i - y_i| Lecture 06
Clustering Cost Sum of Squared Errors (SSE) SSE=βˆ‘i=1Kβˆ‘x∈Ci∣xβˆ’ci∣22\text{SSE} = \sum_{i=1}^K \sum_{\mathbf{x} \in C_i} |\mathbf{x} - \mathbf{c}_i|_2^2 Lecture 06
Cluster Validation Silhouette Coefficient s(i)=b(i)βˆ’a(i)max⁑(a(i),b(i)),s(i)∈[βˆ’1,+1]s(i) = \frac{b(i) - a(i)}{\max(a(i), b(i))}, \quad s(i) \in [-1, +1] Lecture 06
Evaluation Accuracy Accuracy=TP+TNTP+TN+FP+FN\text{Accuracy} = \frac{TP + TN}{TP + TN + FP + FN} Lecture 07
Evaluation Precision (PPV) Precision=TPTP+FP\text{Precision} = \frac{TP}{TP + FP} Lecture 07
Evaluation Recall / Sensitivity / TPR Recall=TPTP+FN\text{Recall} = \frac{TP}{TP + FN} Lecture 07
Evaluation Specificity / TNR Specificity=TNTN+FP\text{Specificity} = \frac{TN}{TN + FP} Lecture 07
Evaluation False Positive Rate (FPR) FPR=FPFP+TN=1βˆ’Specificity\text{FPR} = \frac{FP}{FP + TN} = 1 - \text{Specificity} Lecture 07
Evaluation F1F_1-Score (FF-Measure) F1=2β‹…Precisionβ‹…RecallPrecision+Recall=2TP2TP+FP+FNF_1 = 2 \cdot \frac{\text{Precision} \cdot \text{Recall}}{\text{Precision} + \text{Recall}} = \frac{2 TP}{2 TP + FP + FN} Lecture 07

5. Verification and Integrity Assurance

Deliverable integrity across this study suite is verified automatically by running the project verification harness:

# Execute the comprehensive automated test suite from the repository root:
python3 validate_notes.py

The test runner validates:

  1. Check A: Presence and substantive content volume (β‰₯2000\ge 2000 bytes, β‰₯60\ge 60 lines) across all 7 lecture notes.
  2. Check B: Strict immutability lock on ./notes/k-fold-cross-validation.md (604 bytes, SHA-256 verified).
  3. Check C: Complete elimination of garbled font glyphs (#$%!, CambriaMath shifts, Unicode math italics, PUA artifacts).
  4. Check D: Valid LaTeX delimiters, balanced braces, and markdown table pipe escaping via \mid or \|.
  5. Check E: Syntactically valid Mermaid flowchart and diagram declarations.
  6. Check F: Master Index link resolution across all referenced paths.