INSTRUCTOR-LED · CLASSROOM TRAINING Expert · 180 Days

Data Analytics — Expert Programme

Expert-level practical training in Data Analytics, structured into 24 sequenced modules with hands-on exercises, guided projects and a capstone. Curriculum and course details are drafts pending academic review.

Book a Free Demo →

Course overview

Expert-level practical training in Data Analytics, structured into 24 sequenced modules with hands-on exercises, guided projects and a capstone. Curriculum and course details are drafts pending academic review.

Who can join?

Learners seeking structured, practical skills in Data Analytics; final eligibility and guidance will be confirmed by the training team.

Prerequisites

Basic computer literacy. Module-specific prerequisites are covered in the course roadmap; final entry criteria require trainer review.

Practical projects

Hands-on practical exercises across 24 modules in Data Analytics, followed by an integrated portfolio/capstone project. Final projects, assessment rubrics and industry relevance require trainer approval.

Classroom curriculum

01Computer & Developer Foundations7.5 hrs

Learn computer & developer foundations through structured practical training at IDM Technologies, Vallioor. Cover computing and professional workflow, files, paths and command line, editor and browser developer tools, and documentation and debugging habits. Build a working software feature or technical demonstration, practise evidence-based review, and demonstrate job-relevant skills. This is a draft module outline, subject to trainer approval.

Topics and subtopics

Computing and professional workflow: Operating systems; files and extensions; project naming; safe sample data Files, paths and command line: Absolute/relative paths; cd, dir/ls, mkdir; safe operations Editor and browser developer tools: VS Code workspace; extensions; search; browser inspector; console Documentation and debugging habits: Official docs; version checks; minimal reproduction; error logs Workstation assessment: Folder organization; reproducibility; documentation; submission

Learning outcomes

Explain computing and professional workflow and distinguish correct use from a common misconception. Explain files, paths and command line and distinguish correct use from a common misconception. Explain editor and browser developer tools and distinguish correct use from a common misconception. Explain documentation and debugging habits and distinguish correct use from a common misconception. Explain workstation assessment and distinguish correct use from a common misconception. Apply Computing and professional workflow, Files, paths and command line, Editor and browser developer tools to create a working software feature or technical demonstration with independently checkable evidence. Evaluate the computer & developer foundations deliverable against stated requirements, safety or quality criteria, and document corrections.

Practical activities

Workshop 1 — Computing and professional workflow: Create the developer workspace and three project folders. Submit: source code, tests, setup notes and a short walkthrough. Workshop 2 — Files, paths and command line: Navigate and create nested project directories from the terminal. Submit: source code, tests, setup notes and a short walkthrough. Workshop 3 — Editor and browser developer tools: Configure editor and inspect a sample web page. Submit: source code, tests, setup notes and a short walkthrough. Workshop 4 — Documentation and debugging habits: Reproduce a setup task and record troubleshooting steps. Submit: source code, tests, setup notes and a short walkthrough. Workshop 5 — Workstation assessment: Demonstrate a clean reproducible workspace. Submit: source code, tests, setup notes and a short walkthrough. Independent task 1 — Computing and professional workflow: Draw the initial requirements, user personas and one-page scope for all three portfolio projects. Independent task 2 — Files, paths and command line: Recreate the project directories entirely with commands and capture the command log. Independent task 3 — Editor and browser developer tools: Prepare README files and a development-environment checklist for each portfolio project. Independent task 4 — Documentation and debugging habits: Write user stories and acceptance criteria for one feature in each project. Independent task 5 — Workstation assessment: Submit all three project charters, folder trees and setup notes.

02Excel Foundations for Analytics20 hrs

Learn excel foundations for analytics through structured practical training at IDM Technologies, Vallioor. Cover tables, formulas, references, and data validation. Build a reproducible analysis workbook or query notebook, practise evidence-based review, and demonstrate job-relevant skills. This is a draft module outline, subject to trainer approval.

Topics and subtopics

Tables: Tables: key definitions and purpose; Tables: workflow and applied decisions in data analytics; Tables: demonstration, error review and independent verification Formulas: formulas: key definitions and purpose; formulas: workflow and applied decisions in data analytics; formulas: demonstration, error review and independent verification References: references: key definitions and purpose; references: workflow and applied decisions in data analytics; references: demonstration, error review and independent verification Data validation: data validation: key definitions and purpose; data validation: workflow and applied decisions in data analytics; data validation: demonstration, error review and independent verification

Learning outcomes

Explain tables and distinguish correct use from a common misconception. Explain formulas and distinguish correct use from a common misconception. Explain references and distinguish correct use from a common misconception. Explain data validation and distinguish correct use from a common misconception. Apply Tables, Formulas, References to create a reproducible analysis workbook or query notebook with independently checkable evidence. Evaluate the excel foundations for analytics deliverable against stated requirements, safety or quality criteria, and document corrections.

Practical activities

Workshop 1 — Tables: produce a focused example applying tables to a realistic brief; compare the initial result with a corrected result and record the reasoning. Submit: input dataset, transformation checks, chart or query results and interpretation. Workshop 2 — Formulas: produce a focused example applying formulas to a realistic brief; compare the initial result with a corrected result and record the reasoning. Submit: input dataset, transformation checks, chart or query results and interpretation. Workshop 3 — References: produce a focused example applying references to a realistic brief; compare the initial result with a corrected result and record the reasoning. Submit: input dataset, transformation checks, chart or query results and interpretation. Workshop 4 — Data validation: produce a focused example applying data validation to a realistic brief; compare the initial result with a corrected result and record the reasoning. Submit: input dataset, transformation checks, chart or query results and interpretation. Applied mini-project — Excel Foundations for Analytics: assemble a reproducible analysis workbook or query notebook combining Tables, Formulas, References; document inputs, outputs and constraints. Review and peer demonstration — Excel Foundations for Analytics: identify two likely mistakes, run a validation checklist, and explain improvements with evidence.

03Advanced Excel Formulas22 hrs

Learn advanced excel formulas through structured practical training at IDM Technologies, Vallioor. Cover lookups, dynamic arrays, conditional logic, and audit. Build a reproducible analysis workbook or query notebook, practise evidence-based review, and demonstrate job-relevant skills. This is a draft module outline, subject to trainer approval.

Topics and subtopics

Lookups: Lookups: key definitions and purpose; Lookups: workflow and applied decisions in data analytics; Lookups: demonstration, error review and independent verification Dynamic arrays: dynamic arrays: key definitions and purpose; dynamic arrays: workflow and applied decisions in data analytics; dynamic arrays: demonstration, error review and independent verification Conditional logic: conditional logic: key definitions and purpose; conditional logic: workflow and applied decisions in data analytics; conditional logic: demonstration, error review and independent verification Audit: audit: key definitions and purpose; audit: workflow and applied decisions in data analytics; audit: demonstration, error review and independent verification

Learning outcomes

Explain lookups and distinguish correct use from a common misconception. Explain dynamic arrays and distinguish correct use from a common misconception. Explain conditional logic and distinguish correct use from a common misconception. Explain audit and distinguish correct use from a common misconception. Apply Lookups, Dynamic arrays, Conditional logic to create a reproducible analysis workbook or query notebook with independently checkable evidence. Evaluate the advanced excel formulas deliverable against stated requirements, safety or quality criteria, and document corrections.

Practical activities

Workshop 1 — Lookups: produce a focused example applying lookups to a realistic brief; compare the initial result with a corrected result and record the reasoning. Submit: input dataset, transformation checks, chart or query results and interpretation. Workshop 2 — Dynamic arrays: produce a focused example applying dynamic arrays to a realistic brief; compare the initial result with a corrected result and record the reasoning. Submit: input dataset, transformation checks, chart or query results and interpretation. Workshop 3 — Conditional logic: produce a focused example applying conditional logic to a realistic brief; compare the initial result with a corrected result and record the reasoning. Submit: input dataset, transformation checks, chart or query results and interpretation. Workshop 4 — Audit: produce a focused example applying audit to a realistic brief; compare the initial result with a corrected result and record the reasoning. Submit: input dataset, transformation checks, chart or query results and interpretation. Applied mini-project — Advanced Excel Formulas: assemble a reproducible analysis workbook or query notebook combining Lookups, Dynamic arrays, Conditional logic; document inputs, outputs and constraints. Review and peer demonstration — Advanced Excel Formulas: identify two likely mistakes, run a validation checklist, and explain improvements with evidence.

04PivotTables & Analytical Summaries18 hrs

Learn pivottables & analytical summaries through structured practical training at IDM Technologies, Vallioor. Cover pivots, slicers, aggregations, and dashboards. Build a reproducible analysis workbook or query notebook, practise evidence-based review, and demonstrate job-relevant skills. This is a draft module outline, subject to trainer approval.

Topics and subtopics

Pivots: Pivots: dimensions, measures, aggregation and slicers; Pivots: refresh behavior and source-data integrity; Pivots: build and cross-check a pivot report Slicers: slicers: key definitions and purpose; slicers: workflow and applied decisions in data analytics; slicers: demonstration, error review and independent verification Aggregations: aggregations: key definitions and purpose; aggregations: workflow and applied decisions in data analytics; aggregations: demonstration, error review and independent verification Dashboards: dashboards: key definitions and purpose; dashboards: workflow and applied decisions in data analytics; dashboards: demonstration, error review and independent verification

Learning outcomes

Explain pivots and distinguish correct use from a common misconception. Explain slicers and distinguish correct use from a common misconception. Explain aggregations and distinguish correct use from a common misconception. Explain dashboards and distinguish correct use from a common misconception. Apply Pivots, Slicers, Aggregations to create a reproducible analysis workbook or query notebook with independently checkable evidence. Evaluate the pivottables & analytical summaries deliverable against stated requirements, safety or quality criteria, and document corrections.

Practical activities

Workshop 1 — Pivots: produce a focused example applying pivots to a realistic brief; compare the initial result with a corrected result and record the reasoning. Submit: input dataset, transformation checks, chart or query results and interpretation. Workshop 2 — Slicers: produce a focused example applying slicers to a realistic brief; compare the initial result with a corrected result and record the reasoning. Submit: input dataset, transformation checks, chart or query results and interpretation. Workshop 3 — Aggregations: produce a focused example applying aggregations to a realistic brief; compare the initial result with a corrected result and record the reasoning. Submit: input dataset, transformation checks, chart or query results and interpretation. Workshop 4 — Dashboards: produce a focused example applying dashboards to a realistic brief; compare the initial result with a corrected result and record the reasoning. Submit: input dataset, transformation checks, chart or query results and interpretation. Applied mini-project — PivotTables & Analytical Summaries: assemble a reproducible analysis workbook or query notebook combining Pivots, Slicers, Aggregations; document inputs, outputs and constraints. Review and peer demonstration — PivotTables & Analytical Summaries: identify two likely mistakes, run a validation checklist, and explain improvements with evidence.

05Power Query & Data Transformation22 hrs

Learn power query & data transformation through structured practical training at IDM Technologies, Vallioor. Cover m language, merge, append, and refresh. Build a reproducible analysis workbook or query notebook, practise evidence-based review, and demonstrate job-relevant skills. This is a draft module outline, subject to trainer approval.

Topics and subtopics

M language: M language: key definitions and purpose; M language: workflow and applied decisions in data analytics; M language: demonstration, error review and independent verification Merge: merge: key definitions and purpose; merge: workflow and applied decisions in data analytics; merge: demonstration, error review and independent verification Append: append: key definitions and purpose; append: workflow and applied decisions in data analytics; append: demonstration, error review and independent verification Refresh: refresh: key definitions and purpose; refresh: workflow and applied decisions in data analytics; refresh: demonstration, error review and independent verification Data types: data types: key definitions and purpose; data types: workflow and applied decisions in data analytics; data types: demonstration, error review and independent verification

Learning outcomes

Explain m language and distinguish correct use from a common misconception. Explain merge and distinguish correct use from a common misconception. Explain append and distinguish correct use from a common misconception. Explain refresh and distinguish correct use from a common misconception. Explain data types and distinguish correct use from a common misconception. Apply M language, Merge, Append to create a reproducible analysis workbook or query notebook with independently checkable evidence. Evaluate the power query & data transformation deliverable against stated requirements, safety or quality criteria, and document corrections.

Practical activities

Workshop 1 — M language: produce a focused example applying m language to a realistic brief; compare the initial result with a corrected result and record the reasoning. Submit: input dataset, transformation checks, chart or query results and interpretation. Workshop 2 — Merge: produce a focused example applying merge to a realistic brief; compare the initial result with a corrected result and record the reasoning. Submit: input dataset, transformation checks, chart or query results and interpretation. Workshop 3 — Append: produce a focused example applying append to a realistic brief; compare the initial result with a corrected result and record the reasoning. Submit: input dataset, transformation checks, chart or query results and interpretation. Workshop 4 — Refresh: produce a focused example applying refresh to a realistic brief; compare the initial result with a corrected result and record the reasoning. Submit: input dataset, transformation checks, chart or query results and interpretation. Workshop 5 — Data types: produce a focused example applying data types to a realistic brief; compare the initial result with a corrected result and record the reasoning. Submit: input dataset, transformation checks, chart or query results and interpretation. Applied mini-project — Power Query & Data Transformation: assemble a reproducible analysis workbook or query notebook combining M language, Merge, Append; document inputs, outputs and constraints. Review and peer demonstration — Power Query & Data Transformation: identify two likely mistakes, run a validation checklist, and explain improvements with evidence.

06Power Pivot & Data Modelling20 hrs

Learn power pivot & data modelling through structured practical training at IDM Technologies, Vallioor. Cover relationships, star schema, measures, and filter context. Build a reproducible analysis workbook or query notebook, practise evidence-based review, and demonstrate job-relevant skills. This is a draft module outline, subject to trainer approval.

Topics and subtopics

Relationships: Relationships: key definitions and purpose; Relationships: workflow and applied decisions in data analytics; Relationships: demonstration, error review and independent verification Star schema: star schema: key definitions and purpose; star schema: workflow and applied decisions in data analytics; star schema: demonstration, error review and independent verification Measures: measures: key definitions and purpose; measures: workflow and applied decisions in data analytics; measures: demonstration, error review and independent verification Filter context: filter context: key definitions and purpose; filter context: workflow and applied decisions in data analytics; filter context: demonstration, error review and independent verification

Learning outcomes

Explain relationships and distinguish correct use from a common misconception. Explain star schema and distinguish correct use from a common misconception. Explain measures and distinguish correct use from a common misconception. Explain filter context and distinguish correct use from a common misconception. Apply Relationships, Star schema, Measures to create a reproducible analysis workbook or query notebook with independently checkable evidence. Evaluate the power pivot & data modelling deliverable against stated requirements, safety or quality criteria, and document corrections.

Practical activities

Workshop 1 — Relationships: produce a focused example applying relationships to a realistic brief; compare the initial result with a corrected result and record the reasoning. Submit: input dataset, transformation checks, chart or query results and interpretation. Workshop 2 — Star schema: produce a focused example applying star schema to a realistic brief; compare the initial result with a corrected result and record the reasoning. Submit: input dataset, transformation checks, chart or query results and interpretation. Workshop 3 — Measures: produce a focused example applying measures to a realistic brief; compare the initial result with a corrected result and record the reasoning. Submit: input dataset, transformation checks, chart or query results and interpretation. Workshop 4 — Filter context: produce a focused example applying filter context to a realistic brief; compare the initial result with a corrected result and record the reasoning. Submit: input dataset, transformation checks, chart or query results and interpretation. Applied mini-project — Power Pivot & Data Modelling: assemble a reproducible analysis workbook or query notebook combining Relationships, Star schema, Measures; document inputs, outputs and constraints. Review and peer demonstration — Power Pivot & Data Modelling: identify two likely mistakes, run a validation checklist, and explain improvements with evidence.

07SQL & Relational Database Foundations20 hrs

Learn sql & relational database foundations through structured practical training at IDM Technologies, Vallioor. Cover tables, relationships, joins, and grouping. Build a reproducible analysis workbook or query notebook, practise evidence-based review, and demonstrate job-relevant skills. This is a draft module outline, subject to trainer approval.

Topics and subtopics

Tables: Tables: key definitions and purpose; Tables: workflow and applied decisions in data analytics; Tables: demonstration, error review and independent verification Relationships: relationships: key definitions and purpose; relationships: workflow and applied decisions in data analytics; relationships: demonstration, error review and independent verification Joins: joins: join keys, cardinality and null handling; joins: inner, left and other join behavior; joins: verify row counts before and after a join Grouping: grouping: key definitions and purpose; grouping: workflow and applied decisions in data analytics; grouping: demonstration, error review and independent verification Constraints: constraints: key definitions and purpose; constraints: workflow and applied decisions in data analytics; constraints: demonstration, error review and independent verification

Learning outcomes

Explain tables and distinguish correct use from a common misconception. Explain relationships and distinguish correct use from a common misconception. Explain joins and distinguish correct use from a common misconception. Explain grouping and distinguish correct use from a common misconception. Explain constraints and distinguish correct use from a common misconception. Apply Tables, Relationships, Joins to create a reproducible analysis workbook or query notebook with independently checkable evidence. Evaluate the sql & relational database foundations deliverable against stated requirements, safety or quality criteria, and document corrections.

Practical activities

Workshop 1 — Tables: produce a focused example applying tables to a realistic brief; compare the initial result with a corrected result and record the reasoning. Submit: input dataset, transformation checks, chart or query results and interpretation. Workshop 2 — Relationships: produce a focused example applying relationships to a realistic brief; compare the initial result with a corrected result and record the reasoning. Submit: input dataset, transformation checks, chart or query results and interpretation. Workshop 3 — Joins: produce a focused example applying joins to a realistic brief; compare the initial result with a corrected result and record the reasoning. Submit: input dataset, transformation checks, chart or query results and interpretation. Workshop 4 — Grouping: produce a focused example applying grouping to a realistic brief; compare the initial result with a corrected result and record the reasoning. Submit: input dataset, transformation checks, chart or query results and interpretation. Workshop 5 — Constraints: produce a focused example applying constraints to a realistic brief; compare the initial result with a corrected result and record the reasoning. Submit: input dataset, transformation checks, chart or query results and interpretation. Applied mini-project — SQL & Relational Database Foundations: assemble a reproducible analysis workbook or query notebook combining Tables, Relationships, Joins; document inputs, outputs and constraints. Review and peer demonstration — SQL & Relational Database Foundations: identify two likely mistakes, run a validation checklist, and explain improvements with evidence.

08Intermediate & Advanced SQL24 hrs

Learn intermediate & advanced sql through structured practical training at IDM Technologies, Vallioor. Cover ctes, window functions, subqueries, and query tuning. Build a reproducible analysis workbook or query notebook, practise evidence-based review, and demonstrate job-relevant skills. This is a draft module outline, subject to trainer approval.

Topics and subtopics

CTEs: CTEs: key definitions and purpose; CTEs: workflow and applied decisions in data analytics; CTEs: demonstration, error review and independent verification Window functions: window functions: partitions, ordering and window calculations; window functions: row number, rank and running totals; window functions: validate a ranked analytical report Subqueries: subqueries: key definitions and purpose; subqueries: workflow and applied decisions in data analytics; subqueries: demonstration, error review and independent verification Query tuning: query tuning: key definitions and purpose; query tuning: workflow and applied decisions in data analytics; query tuning: demonstration, error review and independent verification

Learning outcomes

Explain ctes and distinguish correct use from a common misconception. Explain window functions and distinguish correct use from a common misconception. Explain subqueries and distinguish correct use from a common misconception. Explain query tuning and distinguish correct use from a common misconception. Apply CTEs, Window functions, Subqueries to create a reproducible analysis workbook or query notebook with independently checkable evidence. Evaluate the intermediate & advanced sql deliverable against stated requirements, safety or quality criteria, and document corrections.

Practical activities

Workshop 1 — CTEs: produce a focused example applying ctes to a realistic brief; compare the initial result with a corrected result and record the reasoning. Submit: input dataset, transformation checks, chart or query results and interpretation. Workshop 2 — Window functions: produce a focused example applying window functions to a realistic brief; compare the initial result with a corrected result and record the reasoning. Submit: input dataset, transformation checks, chart or query results and interpretation. Workshop 3 — Subqueries: produce a focused example applying subqueries to a realistic brief; compare the initial result with a corrected result and record the reasoning. Submit: input dataset, transformation checks, chart or query results and interpretation. Workshop 4 — Query tuning: produce a focused example applying query tuning to a realistic brief; compare the initial result with a corrected result and record the reasoning. Submit: input dataset, transformation checks, chart or query results and interpretation. Applied mini-project — Intermediate & Advanced SQL: assemble a reproducible analysis workbook or query notebook combining CTEs, Window functions, Subqueries; document inputs, outputs and constraints. Review and peer demonstration — Intermediate & Advanced SQL: identify two likely mistakes, run a validation checklist, and explain improvements with evidence.

09Data Preparation & Quality16 hrs

Learn data preparation & quality through structured practical training at IDM Technologies, Vallioor. Cover data types, profiling, cleansing, and missing data. Build a reproducible analysis workbook or query notebook, practise evidence-based review, and demonstrate job-relevant skills. This is a draft module outline, subject to trainer approval.

Topics and subtopics

Data types: Data types: key definitions and purpose; Data types: workflow and applied decisions in data analytics; Data types: demonstration, error review and independent verification Profiling: profiling: key definitions and purpose; profiling: workflow and applied decisions in data analytics; profiling: demonstration, error review and independent verification Cleansing: cleansing: key definitions and purpose; cleansing: workflow and applied decisions in data analytics; cleansing: demonstration, error review and independent verification Missing data: missing data: key definitions and purpose; missing data: workflow and applied decisions in data analytics; missing data: demonstration, error review and independent verification Validation: validation: key definitions and purpose; validation: workflow and applied decisions in data analytics; validation: demonstration, error review and independent verification

Learning outcomes

Explain data types and distinguish correct use from a common misconception. Explain profiling and distinguish correct use from a common misconception. Explain cleansing and distinguish correct use from a common misconception. Explain missing data and distinguish correct use from a common misconception. Explain validation and distinguish correct use from a common misconception. Apply Data types, Profiling, Cleansing to create a reproducible analysis workbook or query notebook with independently checkable evidence. Evaluate the data preparation & quality deliverable against stated requirements, safety or quality criteria, and document corrections.

Practical activities

Workshop 1 — Data types: produce a focused example applying data types to a realistic brief; compare the initial result with a corrected result and record the reasoning. Submit: input dataset, transformation checks, chart or query results and interpretation. Workshop 2 — Profiling: produce a focused example applying profiling to a realistic brief; compare the initial result with a corrected result and record the reasoning. Submit: input dataset, transformation checks, chart or query results and interpretation. Workshop 3 — Cleansing: produce a focused example applying cleansing to a realistic brief; compare the initial result with a corrected result and record the reasoning. Submit: input dataset, transformation checks, chart or query results and interpretation. Workshop 4 — Missing data: produce a focused example applying missing data to a realistic brief; compare the initial result with a corrected result and record the reasoning. Submit: input dataset, transformation checks, chart or query results and interpretation. Workshop 5 — Validation: produce a focused example applying validation to a realistic brief; compare the initial result with a corrected result and record the reasoning. Submit: input dataset, transformation checks, chart or query results and interpretation. Applied mini-project — Data Preparation & Quality: assemble a reproducible analysis workbook or query notebook combining Data types, Profiling, Cleansing; document inputs, outputs and constraints. Review and peer demonstration — Data Preparation & Quality: identify two likely mistakes, run a validation checklist, and explain improvements with evidence.

10Statistics for Data Work20 hrs

Learn statistics for data work through structured practical training at IDM Technologies, Vallioor. Cover distributions, variation, sampling, and probability. Build a reproducible analysis workbook or query notebook, practise evidence-based review, and demonstrate job-relevant skills. This is a draft module outline, subject to trainer approval.

Topics and subtopics

Distributions: Distributions: key definitions and purpose; Distributions: workflow and applied decisions in data analytics; Distributions: demonstration, error review and independent verification Variation: variation: key definitions and purpose; variation: workflow and applied decisions in data analytics; variation: demonstration, error review and independent verification Sampling: sampling: key definitions and purpose; sampling: workflow and applied decisions in data analytics; sampling: demonstration, error review and independent verification Probability: probability: key definitions and purpose; probability: workflow and applied decisions in data analytics; probability: demonstration, error review and independent verification Hypothesis basics: hypothesis basics: key definitions and purpose; hypothesis basics: workflow and applied decisions in data analytics; hypothesis basics: demonstration, error review and independent verification

Learning outcomes

Explain distributions and distinguish correct use from a common misconception. Explain variation and distinguish correct use from a common misconception. Explain sampling and distinguish correct use from a common misconception. Explain probability and distinguish correct use from a common misconception. Explain hypothesis basics and distinguish correct use from a common misconception. Apply Distributions, Variation, Sampling to create a reproducible analysis workbook or query notebook with independently checkable evidence. Evaluate the statistics for data work deliverable against stated requirements, safety or quality criteria, and document corrections.

Practical activities

Workshop 1 — Distributions: produce a focused example applying distributions to a realistic brief; compare the initial result with a corrected result and record the reasoning. Submit: input dataset, transformation checks, chart or query results and interpretation. Workshop 2 — Variation: produce a focused example applying variation to a realistic brief; compare the initial result with a corrected result and record the reasoning. Submit: input dataset, transformation checks, chart or query results and interpretation. Workshop 3 — Sampling: produce a focused example applying sampling to a realistic brief; compare the initial result with a corrected result and record the reasoning. Submit: input dataset, transformation checks, chart or query results and interpretation. Workshop 4 — Probability: produce a focused example applying probability to a realistic brief; compare the initial result with a corrected result and record the reasoning. Submit: input dataset, transformation checks, chart or query results and interpretation. Workshop 5 — Hypothesis basics: produce a focused example applying hypothesis basics to a realistic brief; compare the initial result with a corrected result and record the reasoning. Submit: input dataset, transformation checks, chart or query results and interpretation. Applied mini-project — Statistics for Data Work: assemble a reproducible analysis workbook or query notebook combining Distributions, Variation, Sampling; document inputs, outputs and constraints. Review and peer demonstration — Statistics for Data Work: identify two likely mistakes, run a validation checklist, and explain improvements with evidence.

11Python Programming Fundamentals7.5 hrs

Learn python programming fundamentals through structured practical training at IDM Technologies, Vallioor. Cover python setup and syntax, operators and branching, loops and patterns, and functions and scope. Build a working software feature or technical demonstration, practise evidence-based review, and demonstrate job-relevant skills. This is a draft module outline, subject to trainer approval.

Topics and subtopics

Python setup and syntax: Interpreter; pip; virtual environment basics; variables; print/input Operators and branching: Comparison; logical operators; if/elif/else Loops and patterns: for/while; range; break/continue; nested loops Functions and scope: Parameters; return; defaults; local scope Python fundamentals assessment: Trace/debug; input safety; edge cases

Learning outcomes

Explain python setup and syntax and distinguish correct use from a common misconception. Explain operators and branching and distinguish correct use from a common misconception. Explain loops and patterns and distinguish correct use from a common misconception. Explain functions and scope and distinguish correct use from a common misconception. Explain python fundamentals assessment and distinguish correct use from a common misconception. Apply Python setup and syntax, Operators and branching, Loops and patterns to create a working software feature or technical demonstration with independently checkable evidence. Evaluate the python programming fundamentals deliverable against stated requirements, safety or quality criteria, and document corrections.

Practical activities

Workshop 1 — Python setup and syntax: Run Python calculations and types demo. Submit: source code, tests, setup notes and a short walkthrough. Workshop 2 — Operators and branching: Implement validation and decision problems. Submit: source code, tests, setup notes and a short walkthrough. Workshop 3 — Loops and patterns: Solve loop exercises with trace tables. Submit: source code, tests, setup notes and a short walkthrough. Workshop 4 — Functions and scope: Refactor procedural scripts to functions. Submit: source code, tests, setup notes and a short walkthrough. Workshop 5 — Python fundamentals assessment: Complete unseen coding problems independently. Submit: source code, tests, setup notes and a short walkthrough. Independent task 1 — Python setup and syntax: Write a simple command-line admission fee calculator. Independent task 2 — Operators and branching: Write job eligibility checks based on sample criteria. Independent task 3 — Loops and patterns: Process a list of booking requests and summarize counts. Independent task 4 — Functions and scope: Create reusable helpers for fee, job and service calculations. Independent task 5 — Python fundamentals assessment: Submit a tested command-line utility with examples and documentation.

12Pandas & NumPy for Analysis22 hrs

Learn pandas & numpy for analysis through structured practical training at IDM Technologies, Vallioor. Cover dataframes, joins, groupby, and vectorization. Build a reproducible analysis workbook or query notebook, practise evidence-based review, and demonstrate job-relevant skills. This is a draft module outline, subject to trainer approval.

Topics and subtopics

DataFrames: DataFrames: key definitions and purpose; DataFrames: workflow and applied decisions in data analytics; DataFrames: demonstration, error review and independent verification Joins: joins: join keys, cardinality and null handling; joins: inner, left and other join behavior; joins: verify row counts before and after a join Groupby: groupby: key definitions and purpose; groupby: workflow and applied decisions in data analytics; groupby: demonstration, error review and independent verification Vectorization: vectorization: key definitions and purpose; vectorization: workflow and applied decisions in data analytics; vectorization: demonstration, error review and independent verification Arrays: arrays: key definitions and purpose; arrays: workflow and applied decisions in data analytics; arrays: demonstration, error review and independent verification

Learning outcomes

Explain dataframes and distinguish correct use from a common misconception. Explain joins and distinguish correct use from a common misconception. Explain groupby and distinguish correct use from a common misconception. Explain vectorization and distinguish correct use from a common misconception. Explain arrays and distinguish correct use from a common misconception. Apply DataFrames, Joins, Groupby to create a reproducible analysis workbook or query notebook with independently checkable evidence. Evaluate the pandas & numpy for analysis deliverable against stated requirements, safety or quality criteria, and document corrections.

Practical activities

Workshop 1 — DataFrames: produce a focused example applying dataframes to a realistic brief; compare the initial result with a corrected result and record the reasoning. Submit: input dataset, transformation checks, chart or query results and interpretation. Workshop 2 — Joins: produce a focused example applying joins to a realistic brief; compare the initial result with a corrected result and record the reasoning. Submit: input dataset, transformation checks, chart or query results and interpretation. Workshop 3 — Groupby: produce a focused example applying groupby to a realistic brief; compare the initial result with a corrected result and record the reasoning. Submit: input dataset, transformation checks, chart or query results and interpretation. Workshop 4 — Vectorization: produce a focused example applying vectorization to a realistic brief; compare the initial result with a corrected result and record the reasoning. Submit: input dataset, transformation checks, chart or query results and interpretation. Workshop 5 — Arrays: produce a focused example applying arrays to a realistic brief; compare the initial result with a corrected result and record the reasoning. Submit: input dataset, transformation checks, chart or query results and interpretation. Applied mini-project — Pandas & NumPy for Analysis: assemble a reproducible analysis workbook or query notebook combining DataFrames, Joins, Groupby; document inputs, outputs and constraints. Review and peer demonstration — Pandas & NumPy for Analysis: identify two likely mistakes, run a validation checklist, and explain improvements with evidence.

13Exploratory Data Analysis20 hrs

Learn exploratory data analysis through structured practical training at IDM Technologies, Vallioor. Cover profiling, visual inspection, anomaly review. Build a reproducible analysis workbook or query notebook, practise evidence-based review, and demonstrate job-relevant skills. This is a draft module outline, subject to trainer approval.

Topics and subtopics

Profiling: Profiling: key definitions and purpose; Profiling: workflow and applied decisions in data analytics; Profiling: demonstration, error review and independent verification Visual inspection: visual inspection: key definitions and purpose; visual inspection: workflow and applied decisions in data analytics; visual inspection: demonstration, error review and independent verification Anomaly review: anomaly review: key definitions and purpose; anomaly review: workflow and applied decisions in data analytics; anomaly review: demonstration, error review and independent verification

Learning outcomes

Explain profiling and distinguish correct use from a common misconception. Explain visual inspection and distinguish correct use from a common misconception. Explain anomaly review and distinguish correct use from a common misconception. Apply Profiling, Visual inspection, Anomaly review to create a reproducible analysis workbook or query notebook with independently checkable evidence. Evaluate the exploratory data analysis deliverable against stated requirements, safety or quality criteria, and document corrections.

Practical activities

Workshop 1 — Profiling: produce a focused example applying profiling to a realistic brief; compare the initial result with a corrected result and record the reasoning. Submit: input dataset, transformation checks, chart or query results and interpretation. Workshop 2 — Visual inspection: produce a focused example applying visual inspection to a realistic brief; compare the initial result with a corrected result and record the reasoning. Submit: input dataset, transformation checks, chart or query results and interpretation. Workshop 3 — Anomaly review: produce a focused example applying anomaly review to a realistic brief; compare the initial result with a corrected result and record the reasoning. Submit: input dataset, transformation checks, chart or query results and interpretation. Applied mini-project — Exploratory Data Analysis: assemble a reproducible analysis workbook or query notebook combining Profiling, Visual inspection, Anomaly review; document inputs, outputs and constraints. Review and peer demonstration — Exploratory Data Analysis: identify two likely mistakes, run a validation checklist, and explain improvements with evidence.

14Data Visualization Principles14 hrs

Learn data visualization principles through structured practical training at IDM Technologies, Vallioor. Cover chart choice, visual encoding, dashboard layout, and storytelling. Build a reproducible analysis workbook or query notebook, practise evidence-based review, and demonstrate job-relevant skills. This is a draft module outline, subject to trainer approval.

Topics and subtopics

Chart choice: Chart choice: key definitions and purpose; Chart choice: workflow and applied decisions in data analytics; Chart choice: demonstration, error review and independent verification Visual encoding: visual encoding: key definitions and purpose; visual encoding: workflow and applied decisions in data analytics; visual encoding: demonstration, error review and independent verification Dashboard layout: dashboard layout: key definitions and purpose; dashboard layout: workflow and applied decisions in data analytics; dashboard layout: demonstration, error review and independent verification Storytelling: storytelling: key definitions and purpose; storytelling: workflow and applied decisions in data analytics; storytelling: demonstration, error review and independent verification

Learning outcomes

Explain chart choice and distinguish correct use from a common misconception. Explain visual encoding and distinguish correct use from a common misconception. Explain dashboard layout and distinguish correct use from a common misconception. Explain storytelling and distinguish correct use from a common misconception. Apply Chart choice, Visual encoding, Dashboard layout to create a reproducible analysis workbook or query notebook with independently checkable evidence. Evaluate the data visualization principles deliverable against stated requirements, safety or quality criteria, and document corrections.

Practical activities

Workshop 1 — Chart choice: produce a focused example applying chart choice to a realistic brief; compare the initial result with a corrected result and record the reasoning. Submit: input dataset, transformation checks, chart or query results and interpretation. Workshop 2 — Visual encoding: produce a focused example applying visual encoding to a realistic brief; compare the initial result with a corrected result and record the reasoning. Submit: input dataset, transformation checks, chart or query results and interpretation. Workshop 3 — Dashboard layout: produce a focused example applying dashboard layout to a realistic brief; compare the initial result with a corrected result and record the reasoning. Submit: input dataset, transformation checks, chart or query results and interpretation. Workshop 4 — Storytelling: produce a focused example applying storytelling to a realistic brief; compare the initial result with a corrected result and record the reasoning. Submit: input dataset, transformation checks, chart or query results and interpretation. Applied mini-project — Data Visualization Principles: assemble a reproducible analysis workbook or query notebook combining Chart choice, Visual encoding, Dashboard layout; document inputs, outputs and constraints. Review and peer demonstration — Data Visualization Principles: identify two likely mistakes, run a validation checklist, and explain improvements with evidence.

15Power BI Data Modelling22 hrs

Learn power bi data modelling through structured practical training at IDM Technologies, Vallioor. Cover import, relationships, star schema, and date tables. Build a reproducible analysis workbook or query notebook, practise evidence-based review, and demonstrate job-relevant skills. This is a draft module outline, subject to trainer approval.

Topics and subtopics

Import: Import: key definitions and purpose; Import: workflow and applied decisions in data analytics; Import: demonstration, error review and independent verification Relationships: relationships: key definitions and purpose; relationships: workflow and applied decisions in data analytics; relationships: demonstration, error review and independent verification Star schema: star schema: key definitions and purpose; star schema: workflow and applied decisions in data analytics; star schema: demonstration, error review and independent verification Date tables: date tables: key definitions and purpose; date tables: workflow and applied decisions in data analytics; date tables: demonstration, error review and independent verification

Learning outcomes

Explain import and distinguish correct use from a common misconception. Explain relationships and distinguish correct use from a common misconception. Explain star schema and distinguish correct use from a common misconception. Explain date tables and distinguish correct use from a common misconception. Apply Import, Relationships, Star schema to create a reproducible analysis workbook or query notebook with independently checkable evidence. Evaluate the power bi data modelling deliverable against stated requirements, safety or quality criteria, and document corrections.

Practical activities

Workshop 1 — Import: produce a focused example applying import to a realistic brief; compare the initial result with a corrected result and record the reasoning. Submit: input dataset, transformation checks, chart or query results and interpretation. Workshop 2 — Relationships: produce a focused example applying relationships to a realistic brief; compare the initial result with a corrected result and record the reasoning. Submit: input dataset, transformation checks, chart or query results and interpretation. Workshop 3 — Star schema: produce a focused example applying star schema to a realistic brief; compare the initial result with a corrected result and record the reasoning. Submit: input dataset, transformation checks, chart or query results and interpretation. Workshop 4 — Date tables: produce a focused example applying date tables to a realistic brief; compare the initial result with a corrected result and record the reasoning. Submit: input dataset, transformation checks, chart or query results and interpretation. Applied mini-project — Power BI Data Modelling: assemble a reproducible analysis workbook or query notebook combining Import, Relationships, Star schema; document inputs, outputs and constraints. Review and peer demonstration — Power BI Data Modelling: identify two likely mistakes, run a validation checklist, and explain improvements with evidence.

16DAX Measures & Time Intelligence24 hrs

Learn dax measures & time intelligence through structured practical training at IDM Technologies, Vallioor. Cover calculate, contexts, filter modifiers, and period comparisons. Build a reproducible analysis workbook or query notebook, practise evidence-based review, and demonstrate job-relevant skills. This is a draft module outline, subject to trainer approval.

Topics and subtopics

CALCULATE: CALCULATE: key definitions and purpose; CALCULATE: workflow and applied decisions in data analytics; CALCULATE: demonstration, error review and independent verification Contexts: contexts: key definitions and purpose; contexts: workflow and applied decisions in data analytics; contexts: demonstration, error review and independent verification Filter modifiers: filter modifiers: key definitions and purpose; filter modifiers: workflow and applied decisions in data analytics; filter modifiers: demonstration, error review and independent verification Period comparisons: period comparisons: key definitions and purpose; period comparisons: workflow and applied decisions in data analytics; period comparisons: demonstration, error review and independent verification

Learning outcomes

Explain calculate and distinguish correct use from a common misconception. Explain contexts and distinguish correct use from a common misconception. Explain filter modifiers and distinguish correct use from a common misconception. Explain period comparisons and distinguish correct use from a common misconception. Apply CALCULATE, Contexts, Filter modifiers to create a reproducible analysis workbook or query notebook with independently checkable evidence. Evaluate the dax measures & time intelligence deliverable against stated requirements, safety or quality criteria, and document corrections.

Practical activities

Workshop 1 — CALCULATE: produce a focused example applying calculate to a realistic brief; compare the initial result with a corrected result and record the reasoning. Submit: input dataset, transformation checks, chart or query results and interpretation. Workshop 2 — Contexts: produce a focused example applying contexts to a realistic brief; compare the initial result with a corrected result and record the reasoning. Submit: input dataset, transformation checks, chart or query results and interpretation. Workshop 3 — Filter modifiers: produce a focused example applying filter modifiers to a realistic brief; compare the initial result with a corrected result and record the reasoning. Submit: input dataset, transformation checks, chart or query results and interpretation. Workshop 4 — Period comparisons: produce a focused example applying period comparisons to a realistic brief; compare the initial result with a corrected result and record the reasoning. Submit: input dataset, transformation checks, chart or query results and interpretation. Applied mini-project — DAX Measures & Time Intelligence: assemble a reproducible analysis workbook or query notebook combining CALCULATE, Contexts, Filter modifiers; document inputs, outputs and constraints. Review and peer demonstration — DAX Measures & Time Intelligence: identify two likely mistakes, run a validation checklist, and explain improvements with evidence.

17Power BI Report Design & Publishing20 hrs

Learn power bi report design & publishing through structured practical training at IDM Technologies, Vallioor. Cover interactions, navigation, accessibility, and sharing. Build a reproducible analysis workbook or query notebook, practise evidence-based review, and demonstrate job-relevant skills. This is a draft module outline, subject to trainer approval.

Topics and subtopics

Interactions: Interactions: key definitions and purpose; Interactions: workflow and applied decisions in data analytics; Interactions: demonstration, error review and independent verification Navigation: navigation: key definitions and purpose; navigation: workflow and applied decisions in data analytics; navigation: demonstration, error review and independent verification Accessibility: accessibility: keyboard and screen-reader behavior; accessibility: semantics, focus and contrast checks; accessibility: audit a representative flow and record findings Sharing: sharing: key definitions and purpose; sharing: workflow and applied decisions in data analytics; sharing: demonstration, error review and independent verification

Learning outcomes

Explain interactions and distinguish correct use from a common misconception. Explain navigation and distinguish correct use from a common misconception. Explain accessibility and distinguish correct use from a common misconception. Explain sharing and distinguish correct use from a common misconception. Apply Interactions, Navigation, Accessibility to create a reproducible analysis workbook or query notebook with independently checkable evidence. Evaluate the power bi report design & publishing deliverable against stated requirements, safety or quality criteria, and document corrections.

Practical activities

Workshop 1 — Interactions: produce a focused example applying interactions to a realistic brief; compare the initial result with a corrected result and record the reasoning. Submit: input dataset, transformation checks, chart or query results and interpretation. Workshop 2 — Navigation: produce a focused example applying navigation to a realistic brief; compare the initial result with a corrected result and record the reasoning. Submit: input dataset, transformation checks, chart or query results and interpretation. Workshop 3 — Accessibility: produce a focused example applying accessibility to a realistic brief; compare the initial result with a corrected result and record the reasoning. Submit: input dataset, transformation checks, chart or query results and interpretation. Workshop 4 — Sharing: produce a focused example applying sharing to a realistic brief; compare the initial result with a corrected result and record the reasoning. Submit: input dataset, transformation checks, chart or query results and interpretation. Applied mini-project — Power BI Report Design & Publishing: assemble a reproducible analysis workbook or query notebook combining Interactions, Navigation, Accessibility; document inputs, outputs and constraints. Review and peer demonstration — Power BI Report Design & Publishing: identify two likely mistakes, run a validation checklist, and explain improvements with evidence.

18Python Visualization for Business16 hrs

Learn python visualization for business through structured practical training at IDM Technologies, Vallioor. Cover matplotlib, plots, annotation, and communication. Build a reproducible analysis workbook or query notebook, practise evidence-based review, and demonstrate job-relevant skills. This is a draft module outline, subject to trainer approval.

Topics and subtopics

Matplotlib: Matplotlib: key definitions and purpose; Matplotlib: workflow and applied decisions in data analytics; Matplotlib: demonstration, error review and independent verification Plots: plots: key definitions and purpose; plots: workflow and applied decisions in data analytics; plots: demonstration, error review and independent verification Annotation: annotation: key definitions and purpose; annotation: workflow and applied decisions in data analytics; annotation: demonstration, error review and independent verification Communication: communication: key definitions and purpose; communication: workflow and applied decisions in data analytics; communication: demonstration, error review and independent verification

Learning outcomes

Explain matplotlib and distinguish correct use from a common misconception. Explain plots and distinguish correct use from a common misconception. Explain annotation and distinguish correct use from a common misconception. Explain communication and distinguish correct use from a common misconception. Apply Matplotlib, Plots, Annotation to create a reproducible analysis workbook or query notebook with independently checkable evidence. Evaluate the python visualization for business deliverable against stated requirements, safety or quality criteria, and document corrections.

Practical activities

Workshop 1 — Matplotlib: produce a focused example applying matplotlib to a realistic brief; compare the initial result with a corrected result and record the reasoning. Submit: input dataset, transformation checks, chart or query results and interpretation. Workshop 2 — Plots: produce a focused example applying plots to a realistic brief; compare the initial result with a corrected result and record the reasoning. Submit: input dataset, transformation checks, chart or query results and interpretation. Workshop 3 — Annotation: produce a focused example applying annotation to a realistic brief; compare the initial result with a corrected result and record the reasoning. Submit: input dataset, transformation checks, chart or query results and interpretation. Workshop 4 — Communication: produce a focused example applying communication to a realistic brief; compare the initial result with a corrected result and record the reasoning. Submit: input dataset, transformation checks, chart or query results and interpretation. Applied mini-project — Python Visualization for Business: assemble a reproducible analysis workbook or query notebook combining Matplotlib, Plots, Annotation; document inputs, outputs and constraints. Review and peer demonstration — Python Visualization for Business: identify two likely mistakes, run a validation checklist, and explain improvements with evidence.

19Business KPIs & Analytical Thinking16 hrs

Learn business kpis & analytical thinking through structured practical training at IDM Technologies, Vallioor. Cover metric trees, funnels, cohorts, and segmentation. Build a reproducible analysis workbook or query notebook, practise evidence-based review, and demonstrate job-relevant skills. This is a draft module outline, subject to trainer approval.

Topics and subtopics

Metric trees: Metric trees: key definitions and purpose; Metric trees: workflow and applied decisions in data analytics; Metric trees: demonstration, error review and independent verification Funnels: funnels: key definitions and purpose; funnels: workflow and applied decisions in data analytics; funnels: demonstration, error review and independent verification Cohorts: cohorts: key definitions and purpose; cohorts: workflow and applied decisions in data analytics; cohorts: demonstration, error review and independent verification Segmentation: segmentation: key definitions and purpose; segmentation: workflow and applied decisions in data analytics; segmentation: demonstration, error review and independent verification

Learning outcomes

Explain metric trees and distinguish correct use from a common misconception. Explain funnels and distinguish correct use from a common misconception. Explain cohorts and distinguish correct use from a common misconception. Explain segmentation and distinguish correct use from a common misconception. Apply Metric trees, Funnels, Cohorts to create a reproducible analysis workbook or query notebook with independently checkable evidence. Evaluate the business kpis & analytical thinking deliverable against stated requirements, safety or quality criteria, and document corrections.

Practical activities

Workshop 1 — Metric trees: produce a focused example applying metric trees to a realistic brief; compare the initial result with a corrected result and record the reasoning. Submit: input dataset, transformation checks, chart or query results and interpretation. Workshop 2 — Funnels: produce a focused example applying funnels to a realistic brief; compare the initial result with a corrected result and record the reasoning. Submit: input dataset, transformation checks, chart or query results and interpretation. Workshop 3 — Cohorts: produce a focused example applying cohorts to a realistic brief; compare the initial result with a corrected result and record the reasoning. Submit: input dataset, transformation checks, chart or query results and interpretation. Workshop 4 — Segmentation: produce a focused example applying segmentation to a realistic brief; compare the initial result with a corrected result and record the reasoning. Submit: input dataset, transformation checks, chart or query results and interpretation. Applied mini-project — Business KPIs & Analytical Thinking: assemble a reproducible analysis workbook or query notebook combining Metric trees, Funnels, Cohorts; document inputs, outputs and constraints. Review and peer demonstration — Business KPIs & Analytical Thinking: identify two likely mistakes, run a validation checklist, and explain improvements with evidence.

20Forecasting & Introductory Predictive Analysis18 hrs

Learn forecasting & introductory predictive analysis through structured practical training at IDM Technologies, Vallioor. Cover trends, baselines, validation, and uncertainty. Build a reproducible analysis workbook or query notebook, practise evidence-based review, and demonstrate job-relevant skills. This is a draft module outline, subject to trainer approval.

Topics and subtopics

Trends: Trends: key definitions and purpose; Trends: workflow and applied decisions in data analytics; Trends: demonstration, error review and independent verification Baselines: baselines: key definitions and purpose; baselines: workflow and applied decisions in data analytics; baselines: demonstration, error review and independent verification Validation: validation: key definitions and purpose; validation: workflow and applied decisions in data analytics; validation: demonstration, error review and independent verification Uncertainty: uncertainty: key definitions and purpose; uncertainty: workflow and applied decisions in data analytics; uncertainty: demonstration, error review and independent verification

Learning outcomes

Explain trends and distinguish correct use from a common misconception. Explain baselines and distinguish correct use from a common misconception. Explain validation and distinguish correct use from a common misconception. Explain uncertainty and distinguish correct use from a common misconception. Apply Trends, Baselines, Validation to create a reproducible analysis workbook or query notebook with independently checkable evidence. Evaluate the forecasting & introductory predictive analysis deliverable against stated requirements, safety or quality criteria, and document corrections.

Practical activities

Workshop 1 — Trends: produce a focused example applying trends to a realistic brief; compare the initial result with a corrected result and record the reasoning. Submit: input dataset, transformation checks, chart or query results and interpretation. Workshop 2 — Baselines: produce a focused example applying baselines to a realistic brief; compare the initial result with a corrected result and record the reasoning. Submit: input dataset, transformation checks, chart or query results and interpretation. Workshop 3 — Validation: produce a focused example applying validation to a realistic brief; compare the initial result with a corrected result and record the reasoning. Submit: input dataset, transformation checks, chart or query results and interpretation. Workshop 4 — Uncertainty: produce a focused example applying uncertainty to a realistic brief; compare the initial result with a corrected result and record the reasoning. Submit: input dataset, transformation checks, chart or query results and interpretation. Applied mini-project — Forecasting & Introductory Predictive Analysis: assemble a reproducible analysis workbook or query notebook combining Trends, Baselines, Validation; document inputs, outputs and constraints. Review and peer demonstration — Forecasting & Introductory Predictive Analysis: identify two likely mistakes, run a validation checklist, and explain improvements with evidence.

21Security, Privacy & Responsible Practice12 hrs

Learn security, privacy & responsible practice through structured practical training at IDM Technologies, Vallioor. Cover least privilege, secrets, privacy, and safe handling. Build a working software feature or technical demonstration, practise evidence-based review, and demonstrate job-relevant skills. This is a draft module outline, subject to trainer approval.

Topics and subtopics

Least privilege: Least privilege: key definitions and purpose; Least privilege: workflow and applied decisions in software development; Least privilege: demonstration, error review and independent verification Secrets: secrets: key definitions and purpose; secrets: workflow and applied decisions in software development; secrets: demonstration, error review and independent verification Privacy: privacy: key definitions and purpose; privacy: workflow and applied decisions in software development; privacy: demonstration, error review and independent verification Safe handling: safe handling: key definitions and purpose; safe handling: workflow and applied decisions in software development; safe handling: demonstration, error review and independent verification Risk basics: risk basics: key definitions and purpose; risk basics: workflow and applied decisions in software development; risk basics: demonstration, error review and independent verification

Learning outcomes

Explain least privilege and distinguish correct use from a common misconception. Explain secrets and distinguish correct use from a common misconception. Explain privacy and distinguish correct use from a common misconception. Explain safe handling and distinguish correct use from a common misconception. Explain risk basics and distinguish correct use from a common misconception. Apply Least privilege, Secrets, Privacy to create a working software feature or technical demonstration with independently checkable evidence. Evaluate the security, privacy & responsible practice deliverable against stated requirements, safety or quality criteria, and document corrections.

Practical activities

Workshop 1 — Least privilege: produce a focused example applying least privilege to a realistic brief; compare the initial result with a corrected result and record the reasoning. Submit: source code, tests, setup notes and a short walkthrough. Workshop 2 — Secrets: produce a focused example applying secrets to a realistic brief; compare the initial result with a corrected result and record the reasoning. Submit: source code, tests, setup notes and a short walkthrough. Workshop 3 — Privacy: produce a focused example applying privacy to a realistic brief; compare the initial result with a corrected result and record the reasoning. Submit: source code, tests, setup notes and a short walkthrough. Workshop 4 — Safe handling: produce a focused example applying safe handling to a realistic brief; compare the initial result with a corrected result and record the reasoning. Submit: source code, tests, setup notes and a short walkthrough. Workshop 5 — Risk basics: produce a focused example applying risk basics to a realistic brief; compare the initial result with a corrected result and record the reasoning. Submit: source code, tests, setup notes and a short walkthrough. Applied mini-project — Security, Privacy & Responsible Practice: assemble a working software feature or technical demonstration combining Least privilege, Secrets, Privacy; document inputs, outputs and constraints. Review and peer demonstration — Security, Privacy & Responsible Practice: identify two likely mistakes, run a validation checklist, and explain improvements with evidence.

22Data Storytelling & Stakeholder Reports16 hrs

Learn data storytelling & stakeholder reports through structured practical training at IDM Technologies, Vallioor. Cover recommendations, narrative, limitations, and presentation. Build a reproducible analysis workbook or query notebook, practise evidence-based review, and demonstrate job-relevant skills. This is a draft module outline, subject to trainer approval.

Topics and subtopics

Recommendations: Recommendations: key definitions and purpose; Recommendations: workflow and applied decisions in data analytics; Recommendations: demonstration, error review and independent verification Narrative: narrative: key definitions and purpose; narrative: workflow and applied decisions in data analytics; narrative: demonstration, error review and independent verification Limitations: limitations: key definitions and purpose; limitations: workflow and applied decisions in data analytics; limitations: demonstration, error review and independent verification Presentation: presentation: key definitions and purpose; presentation: workflow and applied decisions in data analytics; presentation: demonstration, error review and independent verification

Learning outcomes

Explain recommendations and distinguish correct use from a common misconception. Explain narrative and distinguish correct use from a common misconception. Explain limitations and distinguish correct use from a common misconception. Explain presentation and distinguish correct use from a common misconception. Apply Recommendations, Narrative, Limitations to create a reproducible analysis workbook or query notebook with independently checkable evidence. Evaluate the data storytelling & stakeholder reports deliverable against stated requirements, safety or quality criteria, and document corrections.

Practical activities

Workshop 1 — Recommendations: produce a focused example applying recommendations to a realistic brief; compare the initial result with a corrected result and record the reasoning. Submit: input dataset, transformation checks, chart or query results and interpretation. Workshop 2 — Narrative: produce a focused example applying narrative to a realistic brief; compare the initial result with a corrected result and record the reasoning. Submit: input dataset, transformation checks, chart or query results and interpretation. Workshop 3 — Limitations: produce a focused example applying limitations to a realistic brief; compare the initial result with a corrected result and record the reasoning. Submit: input dataset, transformation checks, chart or query results and interpretation. Workshop 4 — Presentation: produce a focused example applying presentation to a realistic brief; compare the initial result with a corrected result and record the reasoning. Submit: input dataset, transformation checks, chart or query results and interpretation. Applied mini-project — Data Storytelling & Stakeholder Reports: assemble a reproducible analysis workbook or query notebook combining Recommendations, Narrative, Limitations; document inputs, outputs and constraints. Review and peer demonstration — Data Storytelling & Stakeholder Reports: identify two likely mistakes, run a validation checklist, and explain improvements with evidence.

23End-to-End Analytics Capstone36 hrs

Learn end-to-end analytics capstone through structured practical training at IDM Technologies, Vallioor. Cover data source, etl, model, and dashboard. Build a reproducible analysis workbook or query notebook, practise evidence-based review, and demonstrate job-relevant skills. This is a draft module outline, subject to trainer approval.

Topics and subtopics

Data source: Data source: key definitions and purpose; Data source: workflow and applied decisions in data analytics; Data source: demonstration, error review and independent verification ETL: ETL: key definitions and purpose; ETL: workflow and applied decisions in data analytics; ETL: demonstration, error review and independent verification Model: model: inputs, assumptions and baseline selection; model: evaluation, errors and leakage risks; model: record a reproducible comparison experiment Dashboard: dashboard: key definitions and purpose; dashboard: workflow and applied decisions in data analytics; dashboard: demonstration, error review and independent verification Conclusions: conclusions: key definitions and purpose; conclusions: workflow and applied decisions in data analytics; conclusions: demonstration, error review and independent verification

Learning outcomes

Explain data source and distinguish correct use from a common misconception. Explain etl and distinguish correct use from a common misconception. Explain model and distinguish correct use from a common misconception. Explain dashboard and distinguish correct use from a common misconception. Explain conclusions and distinguish correct use from a common misconception. Apply Data source, ETL, Model to create a reproducible analysis workbook or query notebook with independently checkable evidence. Evaluate the end-to-end analytics capstone deliverable against stated requirements, safety or quality criteria, and document corrections.

Practical activities

Workshop 1 — Data source: produce a focused example applying data source to a realistic brief; compare the initial result with a corrected result and record the reasoning. Submit: input dataset, transformation checks, chart or query results and interpretation. Workshop 2 — ETL: produce a focused example applying etl to a realistic brief; compare the initial result with a corrected result and record the reasoning. Submit: input dataset, transformation checks, chart or query results and interpretation. Workshop 3 — Model: produce a focused example applying model to a realistic brief; compare the initial result with a corrected result and record the reasoning. Submit: input dataset, transformation checks, chart or query results and interpretation. Workshop 4 — Dashboard: produce a focused example applying dashboard to a realistic brief; compare the initial result with a corrected result and record the reasoning. Submit: input dataset, transformation checks, chart or query results and interpretation. Workshop 5 — Conclusions: produce a focused example applying conclusions to a realistic brief; compare the initial result with a corrected result and record the reasoning. Submit: input dataset, transformation checks, chart or query results and interpretation. Applied mini-project — End-to-End Analytics Capstone: assemble a reproducible analysis workbook or query notebook combining Data source, ETL, Model; document inputs, outputs and constraints. Review and peer demonstration — End-to-End Analytics Capstone: identify two likely mistakes, run a validation checklist, and explain improvements with evidence.

24Project Planning, Documentation & Presentation12 hrs

Learn project planning, documentation & presentation through structured practical training at IDM Technologies, Vallioor. Cover requirements, milestones, documentation, and demo. Build a working software feature or technical demonstration, practise evidence-based review, and demonstrate job-relevant skills. This is a draft module outline, subject to trainer approval.

Topics and subtopics

Requirements: Requirements: key definitions and purpose; Requirements: workflow and applied decisions in software development; Requirements: demonstration, error review and independent verification Milestones: milestones: key definitions and purpose; milestones: workflow and applied decisions in software development; milestones: demonstration, error review and independent verification Documentation: documentation: key definitions and purpose; documentation: workflow and applied decisions in software development; documentation: demonstration, error review and independent verification Demo: demo: key definitions and purpose; demo: workflow and applied decisions in software development; demo: demonstration, error review and independent verification Presentation: presentation: key definitions and purpose; presentation: workflow and applied decisions in software development; presentation: demonstration, error review and independent verification

Learning outcomes

Explain requirements and distinguish correct use from a common misconception. Explain milestones and distinguish correct use from a common misconception. Explain documentation and distinguish correct use from a common misconception. Explain demo and distinguish correct use from a common misconception. Explain presentation and distinguish correct use from a common misconception. Apply Requirements, Milestones, Documentation to create a working software feature or technical demonstration with independently checkable evidence. Evaluate the project planning, documentation & presentation deliverable against stated requirements, safety or quality criteria, and document corrections.

Practical activities

Workshop 1 — Requirements: produce a focused example applying requirements to a realistic brief; compare the initial result with a corrected result and record the reasoning. Submit: source code, tests, setup notes and a short walkthrough. Workshop 2 — Milestones: produce a focused example applying milestones to a realistic brief; compare the initial result with a corrected result and record the reasoning. Submit: source code, tests, setup notes and a short walkthrough. Workshop 3 — Documentation: produce a focused example applying documentation to a realistic brief; compare the initial result with a corrected result and record the reasoning. Submit: source code, tests, setup notes and a short walkthrough. Workshop 4 — Demo: produce a focused example applying demo to a realistic brief; compare the initial result with a corrected result and record the reasoning. Submit: source code, tests, setup notes and a short walkthrough. Workshop 5 — Presentation: produce a focused example applying presentation to a realistic brief; compare the initial result with a corrected result and record the reasoning. Submit: source code, tests, setup notes and a short walkthrough. Applied mini-project — Project Planning, Documentation & Presentation: assemble a working software feature or technical demonstration combining Requirements, Milestones, Documentation; document inputs, outputs and constraints. Review and peer demonstration — Project Planning, Documentation & Presentation: identify two likely mistakes, run a validation checklist, and explain improvements with evidence.