HumachLearn Learning Hub

Reference the entire data-to-decision workflow.

Use this as an encyclopedia: start with foundations, then follow the workflow through collection, ingestion, EDA, cleaning, feature engineering, validation, modelling, evaluation, interpretation, reporting and monitoring. Every leaf lesson includes explanation, visuals, practical guidance and code.

Browse by workflow stage or search a concept.
01Foundations10 topics · 68 lessonsWorkflow stage
Analytics, Data Science & AI LandscapeUnderstand how data analytics, business intelligence, data science, artificial intelligence, machine learning, deep learning, data engineering and MLOps overlap and differ. In this8
Common Data Science & ML TasksConnect business questions to common analytical task types such as classification, regression, clustering, anomaly detection, dimensionality reduction and forecasting. In this topi6
Learning ParadigmsLearn the major ways models receive supervision or feedback: supervised, unsupervised, semi-supervised, self-supervised, reinforcement and generative learning. In this topic is exp6
Mathematical & Statistical FoundationsReview the mathematical ideas that appear repeatedly in analytics and machine learning: probability, statistics, linear algebra, optimisation, loss functions and generalisation. In5
Types of AnalyticsTypes of Analytics groups the core ideas a learner needs at the foundations stage. Work through the lessons in order when new to the area, or use them independently as a reference 5
Data Types, Measurement & VariablesData Types, Measurement & Variables groups the core ideas a learner needs at the foundations stage. Work through the lessons in order when new to the area, or use them independentl6
Python, Notebooks & Reproducible AnalysisPython, Notebooks & Reproducible Analysis groups the core ideas a learner needs at the foundations stage. Work through the lessons in order when new to the area, or use them indepe6
SQL & Relational Data BasicsSQL & Relational Data Basics groups the core ideas a learner needs at the foundations stage. Work through the lessons in order when new to the area, or use them independently as a 6
Visualisation FoundationsVisualisation Foundations groups the core ideas a learner needs at the foundations stage. Work through the lessons in order when new to the area, or use them independently as a ref6
Excel & Spreadsheet AnalyticsUse spreadsheets as auditable analytical tools: structure data as tables, write transparent formulas, perform lookups and conditional aggregation, build PivotTables, create readabl14
Open topic overview →
Workbook, worksheet and table anatomyUnderstand workbooks, worksheets, ranges, rows, columns and Excel Tables before writing formulas.Cell references: relative, absolute and mixedLearn how A1, $A$1, A$1 and $A1 behave when formulas are copied.Core arithmetic and aggregation formulasUse SUM, AVERAGE, MIN, MAX and COUNT to build transparent summaries.Logical formulas with IF, IFS, AND and ORTranslate business rules into readable spreadsheet logic.Conditional aggregation with SUMIFS, COUNTIFS and AVERAGEIFSCalculate metrics for selected segments without manual filtering.Lookup analysis with XLOOKUPRetrieve attributes from a reference table using an exact key match.INDEX and MATCH for flexible lookupsUnderstand a composable lookup pattern and why key uniqueness matters.Text cleaning with TRIM, CLEAN, TEXTSPLIT and SUBSTITUTEStandardise messy text before grouping or joining.Date and time analysis in ExcelBuild month, quarter and elapsed-time fields from real Excel dates.Excel Tables and structured referencesUse table names and structured formulas so analysis expands safely with new rows.PivotTables for grouped analysisSummarise a table by dimensions and measures, then verify totals against source data.Charts in Excel: choose, label and auditCreate readable charts from a clean analytical table and avoid misleading axes.Power Query fundamentalsImport, clean and reshape data with a reproducible query instead of repeated manual edits.Spreadsheet error handling and auditingUse IFERROR carefully, trace precedents and build reconciliation checks.
021 · Problem Framing & Data Collection6 topics · 34 lessonsWorkflow stage
Data Collection, Sampling & SourcesAcquire data that represent the target population and deployment process, with known provenance, sampling logic and measurement quality. In this topic is expanded into smaller less5
Data Governance, Privacy & EthicsUse data lawfully, proportionately and transparently while protecting privacy, security and affected populations. In this topic is expanded into smaller lessons so that definitions5
Problem Framing & Analytical DesignTranslate an organisational or scientific question into a precise analytical problem with a target, unit of analysis, decision context and success criterion. In this topic is expan5
Business & Research Problem FramingBusiness & Research Problem Framing groups the core ideas a learner needs at the 1 · problem framing & data collection stage. Work through the lessons in order when new to the area6
Data Acquisition MethodsData Acquisition Methods groups the core ideas a learner needs at the 1 · problem framing & data collection stage. Work through the lessons in order when new to the area, or use th6
Sampling & Study DesignSampling & Study Design groups the core ideas a learner needs at the 1 · problem framing & data collection stage. Work through the lessons in order when new to the area, or use the7
032 · Data Ingestion, Storage & Integration3 topics · 19 lessonsWorkflow stage
Files, Formats & Data IngestionFiles, Formats & Data Ingestion groups the core ideas a learner needs at the 2 · data ingestion, storage & integration stage. Work through the lessons in order when new to the area6
Relational Data & JoinsRelational Data & Joins groups the core ideas a learner needs at the 2 · data ingestion, storage & integration stage. Work through the lessons in order when new to the area, or use7
Warehouses, Lakes & PipelinesWarehouses, Lakes & Pipelines groups the core ideas a learner needs at the 2 · data ingestion, storage & integration stage. Work through the lessons in order when new to the area, 6
043 · Data Understanding & EDA4 topics · 24 lessonsWorkflow stage
Data Understanding & Exploratory AnalysisInspect structure, distributions, relationships, missingness and anomalies before choosing transformations or models. In this topic is expanded into smaller lessons so that definit5
Univariate ExplorationUnivariate Exploration groups the core ideas a learner needs at the 3 · data understanding & eda stage. Work through the lessons in order when new to the area, or use them independ6
Bivariate & Multivariate ExplorationBivariate & Multivariate Exploration groups the core ideas a learner needs at the 3 · data understanding & eda stage. Work through the lessons in order when new to the area, or use6
Data Quality ProfilingData Quality Profiling groups the core ideas a learner needs at the 3 · data understanding & eda stage. Work through the lessons in order when new to the area, or use them independ7
054 · Data Cleaning & Missing Data10 topics · 65 lessonsWorkflow stage
Data Cleaning & Quality ControlCorrect or flag duplicate, inconsistent, impossible and noisy records while preserving an auditable trail from raw to cleaned data. In this topic is expanded into smaller lessons s5
Data PreprocessingPreprocessing converts raw variables into a representation that models can learn from without accidentally exposing validation/test information. In this topic is expanded into smal5
Imbalanced LearningImbalanced learning addresses rare classes through evaluation, sampling, weighting, thresholding and suitable objectives rather than simply maximising overall accuracy. In this top5
Missing Data: Concepts & DiagnosisMissing Data: Concepts & Diagnosis groups the core ideas a learner needs at the 4 · data cleaning & missing data stage. Work through the lessons in order when new to the area, or u7
Missing Data: Deletion & Simple ImputationMissing Data: Deletion & Simple Imputation groups the core ideas a learner needs at the 4 · data cleaning & missing data stage. Work through the lessons in order when new to the ar7
Missing Data: Advanced ImputationMissing Data: Advanced Imputation groups the core ideas a learner needs at the 4 · data cleaning & missing data stage. Work through the lessons in order when new to the area, or us7
Missing Data: Time Series & DiagnosticsMissing Data: Time Series & Diagnostics groups the core ideas a learner needs at the 4 · data cleaning & missing data stage. Work through the lessons in order when new to the area,7
Duplicates, Entities & ConsistencyDuplicates, Entities & Consistency groups the core ideas a learner needs at the 4 · data cleaning & missing data stage. Work through the lessons in order when new to the area, or u7
Outliers & Anomalous ValuesOutliers & Anomalous Values groups the core ideas a learner needs at the 4 · data cleaning & missing data stage. Work through the lessons in order when new to the area, or use them8
Text, Date & Category CleaningText, Date & Category Cleaning groups the core ideas a learner needs at the 4 · data cleaning & missing data stage. Work through the lessons in order when new to the area, or use t7
065 · Data Preprocessing & Feature Engineering10 topics · 68 lessonsWorkflow stage
Feature Engineering & SelectionFeature engineering creates informative representations; feature selection removes redundant, noisy or costly variables. Both should be evaluated inside the validation process. In 5
Numeric PreprocessingNumeric Preprocessing groups the core ideas a learner needs at the 5 · data preprocessing & feature engineering stage. Work through the lessons in order when new to the area, or us8
Categorical PreprocessingCategorical Preprocessing groups the core ideas a learner needs at the 5 · data preprocessing & feature engineering stage. Work through the lessons in order when new to the area, o7
Datetime & Time-Series FeaturesDatetime & Time-Series Features groups the core ideas a learner needs at the 5 · data preprocessing & feature engineering stage. Work through the lessons in order when new to the a7
Text Feature PreparationText Feature Preparation groups the core ideas a learner needs at the 5 · data preprocessing & feature engineering stage. Work through the lessons in order when new to the area, or7
Image & Signal PreparationImage & Signal Preparation groups the core ideas a learner needs at the 5 · data preprocessing & feature engineering stage. Work through the lessons in order when new to the area, 6
Feature ConstructionFeature Construction groups the core ideas a learner needs at the 5 · data preprocessing & feature engineering stage. Work through the lessons in order when new to the area, or use7
Feature SelectionFeature Selection groups the core ideas a learner needs at the 5 · data preprocessing & feature engineering stage. Work through the lessons in order when new to the area, or use th7
Dimensionality ReductionDimensionality Reduction groups the core ideas a learner needs at the 5 · data preprocessing & feature engineering stage. Work through the lessons in order when new to the area, or7
Composite PipelinesComposite Pipelines groups the core ideas a learner needs at the 5 · data preprocessing & feature engineering stage. Work through the lessons in order when new to the area, or use 7
076 · Splitting, Validation & Experiment Design6 topics · 40 lessonsWorkflow stage
Cross-Validation & Data SplittingValidation estimates how a model will behave on unseen data. The split strategy must mirror the real independence structure of samples, subjects, groups and time. In this topic is 5
Data Leakage & Experimental IntegrityData leakage occurs when information unavailable at real prediction time influences training, feature construction, selection, tuning or evaluation. In this topic is expanded into 5
Train / Validation / Test DesignTrain / Validation / Test Design groups the core ideas a learner needs at the 6 · splitting, validation & experiment design stage. Work through the lessons in order when new to the7
Cross-Validation MethodsCross-Validation Methods groups the core ideas a learner needs at the 6 · splitting, validation & experiment design stage. Work through the lessons in order when new to the area, o9
Resampling & Statistical ComparisonResampling & Statistical Comparison groups the core ideas a learner needs at the 6 · splitting, validation & experiment design stage. Work through the lessons in order when new to 6
Leakage PreventionLeakage Prevention groups the core ideas a learner needs at the 6 · splitting, validation & experiment design stage. Work through the lessons in order when new to the area, or use 8
087 · Modelling & Training8 topics · 50 lessonsWorkflow stage
Ensemble LearningEnsembles combine multiple learners to improve robustness or accuracy by exploiting diversity among their errors. In this topic is expanded into smaller lessons so that definitions5
Graph ML FoundationsGraph machine learning represents entities as nodes and relationships as edges. GNNs learn by propagating, weighting and transforming information over this connectivity. In this to5
Regularisation & Early StoppingRegularisation controls effective model complexity so a learner captures reproducible structure instead of memorising noise. In this topic is expanded into smaller lessons so that 5
Baseline ModelsBaseline Models groups the core ideas a learner needs at the 7 · modelling & training stage. Work through the lessons in order when new to the area, or use them independently as a 5
Supervised Model FamiliesSupervised Model Families groups the core ideas a learner needs at the 7 · modelling & training stage. Work through the lessons in order when new to the area, or use them independe8
Unsupervised Model FamiliesUnsupervised Model Families groups the core ideas a learner needs at the 7 · modelling & training stage. Work through the lessons in order when new to the area, or use them indepen6
Training DynamicsTraining Dynamics groups the core ideas a learner needs at the 7 · modelling & training stage. Work through the lessons in order when new to the area, or use them independently as 8
Class Imbalance StrategiesClass Imbalance Strategies groups the core ideas a learner needs at the 7 · modelling & training stage. Work through the lessons in order when new to the area, or use them independ8
098 · Hyperparameter Optimisation & Model Selection6 topics · 36 lessonsWorkflow stage
Hyperparameter OptimisationHyperparameter optimisation searches configuration space for choices such as learning rate, tree depth, regularisation, kernel parameters and architecture size. In this topic is ex5
Learning Curves, Bias & VarianceLearning curves and complexity curves help diagnose underfitting, overfitting and whether additional data are likely to help. In this topic is expanded into smaller lessons so that5
Model Selection & ComparisonModel comparison asks whether performance differences are stable, meaningful and worth the complexity rather than simply selecting the highest single score. In this topic is expand5
Search Spaces & BudgetsSearch Spaces & Budgets groups the core ideas a learner needs at the 8 · hyperparameter optimisation & model selection stage. Work through the lessons in order when new to the area7
Optimisation AlgorithmsOptimisation Algorithms groups the core ideas a learner needs at the 8 · hyperparameter optimisation & model selection stage. Work through the lessons in order when new to the area7
Model Selection PracticeModel Selection Practice groups the core ideas a learner needs at the 8 · hyperparameter optimisation & model selection stage. Work through the lessons in order when new to the are7
109 · Evaluation, Metrics & Diagnostics13 topics · 85 lessonsWorkflow stage
Calibration & Decision ThresholdsCalibration concerns whether predicted probabilities match observed frequencies; thresholding converts scores/probabilities into operational decisions. In this topic is expanded in5
Classification MetricsClassification metrics answer different questions: how often predictions are correct, how well minority positives are found, how reliable probabilities are, and how ranking quality5
Clustering Validation MetricsClustering evaluation measures compactness, separation or agreement with known labels while recognising that no single score defines a scientifically meaningful cluster. In this to5
Predictive UncertaintyUncertainty estimation distinguishes what the model predicts from how confident it should be, including noise intrinsic to data and uncertainty due to limited model knowledge. In t5
Regression Metrics & ResidualsRegression metrics quantify prediction error in different units and with different sensitivity to large mistakes. Residual diagnostics reveal patterns that aggregate metrics hide. 5
Classification Metrics: CoreClassification Metrics: Core groups the core ideas a learner needs at the 9 · evaluation, metrics & diagnostics stage. Work through the lessons in order when new to the area, or us8
Classification Metrics: Ranking & ProbabilityClassification Metrics: Ranking & Probability groups the core ideas a learner needs at the 9 · evaluation, metrics & diagnostics stage. Work through the lessons in order when new t8
Regression MetricsRegression Metrics groups the core ideas a learner needs at the 9 · evaluation, metrics & diagnostics stage. Work through the lessons in order when new to the area, or use them ind10
Open topic overview →
MAEMAE is a practical concept within Regression Metrics. It helps turn the broader workflow stage “9 · Evaluation, Metrics & Diagnostics” into MSEMSE is a practical concept within Regression Metrics. It helps turn the broader workflow stage “9 · Evaluation, Metrics & Diagnostics” into RMSERMSE is a practical concept within Regression Metrics. It helps turn the broader workflow stage “9 · Evaluation, Metrics & Diagnostics” intoR-squaredR-squared is a practical concept within Regression Metrics. It helps turn the broader workflow stage “9 · Evaluation, Metrics & Diagnostics”Adjusted R-squaredAdjusted R-squared is a practical concept within Regression Metrics. It helps turn the broader workflow stage “9 · Evaluation, Metrics & DiaMAPEMAPE is a practical concept within Regression Metrics. It helps turn the broader workflow stage “9 · Evaluation, Metrics & Diagnostics” intosMAPEsMAPE is a practical concept within Regression Metrics. It helps turn the broader workflow stage “9 · Evaluation, Metrics & Diagnostics” intMSLE and RMSLEMSLE and RMSLE is a practical concept within Regression Metrics. It helps turn the broader workflow stage “9 · Evaluation, Metrics & DiagnosMedian absolute errorMedian absolute error is a practical concept within Regression Metrics. It helps turn the broader workflow stage “9 · Evaluation, Metrics & Huber lossHuber loss is an evaluation quantity that compresses a particular aspect of predictive behaviour into a number. Its usefulness depends on wh
Regression DiagnosticsRegression Diagnostics groups the core ideas a learner needs at the 9 · evaluation, metrics & diagnostics stage. Work through the lessons in order when new to the area, or use them7
Clustering MetricsClustering Metrics groups the core ideas a learner needs at the 9 · evaluation, metrics & diagnostics stage. Work through the lessons in order when new to the area, or use them ind6
Forecasting MetricsForecasting Metrics groups the core ideas a learner needs at the 9 · evaluation, metrics & diagnostics stage. Work through the lessons in order when new to the area, or use them in6
Calibration, Thresholds & Decision CostsCalibration, Thresholds & Decision Costs groups the core ideas a learner needs at the 9 · evaluation, metrics & diagnostics stage. Work through the lessons in order when new to the8
Uncertainty & IntervalsUncertainty & Intervals groups the core ideas a learner needs at the 9 · evaluation, metrics & diagnostics stage. Work through the lessons in order when new to the area, or use the7
1110 · Interpretation & Explainability4 topics · 23 lessonsWorkflow stage
Explainability & Model InterpretationExplainability techniques describe global model behaviour or why a specific prediction changed, but explanations are approximations whose assumptions must be understood. In this to5
Interpretable ModelsInterpretable Models groups the core ideas a learner needs at the 10 · interpretation & explainability stage. Work through the lessons in order when new to the area, or use them in5
Model-Agnostic ExplainabilityModel-Agnostic Explainability groups the core ideas a learner needs at the 10 · interpretation & explainability stage. Work through the lessons in order when new to the area, or us7
Deep Learning ExplainabilityDeep Learning Explainability groups the core ideas a learner needs at the 10 · interpretation & explainability stage. Work through the lessons in order when new to the area, or use6
1211 · Post-processing, Reporting & Communication4 topics · 24 lessonsWorkflow stage
Prediction Post-ProcessingPost-processing transforms raw model outputs into final usable predictions while respecting domain constraints, calibration and operational decisions. In this topic is expanded int5
Results, Reporting & Decision CommunicationTranslate analysis and model outputs into clear evidence, uncertainty, limitations and actionable decisions for technical and non-technical audiences. In this topic is expanded int5
Reporting & Visual StorytellingReporting & Visual Storytelling groups the core ideas a learner needs at the 11 · post-processing, reporting & communication stage. Work through the lessons in order when new to th7
Reproducibility & DocumentationReproducibility & Documentation groups the core ideas a learner needs at the 11 · post-processing, reporting & communication stage. Work through the lessons in order when new to th7
1312 · Deployment, Monitoring & Improvement4 topics · 27 lessonsWorkflow stage
Deployment, Drift & MonitoringMonitoring checks whether data, predictions, performance and operational assumptions remain valid after deployment. In this topic is expanded into smaller lessons so that definitio5
Deployment PatternsDeployment Patterns groups the core ideas a learner needs at the 12 · deployment, monitoring & improvement stage. Work through the lessons in order when new to the area, or use the7
Production MonitoringProduction Monitoring groups the core ideas a learner needs at the 12 · deployment, monitoring & improvement stage. Work through the lessons in order when new to the area, or use t8
Lifecycle & RetrainingLifecycle & Retraining groups the core ideas a learner needs at the 12 · deployment, monitoring & improvement stage. Work through the lessons in order when new to the area, or use 7