I
CO1
Data Warehouse
OLTP vs OLAP, ETL and multidimensional modelling. Rotate a live OLAP cube through roll-up, drill-down, slice, dice and pivot, and toggle a star vs snowflake schema.
All five units of the Data Warehousing & Data Mining course — each an animated, hands-on lesson with live demos, concept videos, and a 10-question quiz to test yourself.
OLTP vs OLAP, ETL and multidimensional modelling. Rotate a live OLAP cube through roll-up, drill-down, slice, dice and pivot, and toggle a star vs snowflake schema.
Data-mining functionalities, the KDD process and the major issues — then preprocessing: cleaning, integration, reduction, and a live normalization playground (min-max vs z-score).
Market-basket mining: support, confidence and lift with a live rule calculator, the Apriori principle and algorithm stepped over real transactions, FP-Growth, and maximal/closed itemsets.
Decision trees with a live Gini/entropy impurity calculator, an interactive KNN classifier, plus Naïve Bayes, belief networks, evaluation metrics and ensembles. Three concept videos.
Run k-means step by step to convergence, explore agglomerative vs divisive hierarchical clustering and dendrograms, weigh the trade-offs, and detect outliers. Two concept videos.
DWDM_Unit_*.html files in the same folder as this page so the “Open unit” links work. Each unit is self-contained and runs offline (only fonts and the concept videos load from the web).