Business and technology qualifications, Levels 3-6, in Brussels. Explore qualifications
Portal login
Level 6 Diploma in Information Technology

Data Ingestion and Pipeline Architecture

IT602 · Advanced Data Analytics — Week 3 of 16

CourseIT602
Week3 of 16
SemesterI
TutorOnline in the course chat

This week’s topics

Data Ingestion and Pipeline Architecture

  1. ETL and ELT workflows
  2. Silo extraction and data warehouse staging
  3. Feature engineering and transformation pipelines
  4. What is Data Integration? Unlocking AI with ETL, Streaming & Observability
  5. Feature Engineering in ML
  6. Machine Learning Pipeline
  7. AI and Machine Learning Data Sources
  8. Querying and Exporting Relational Data (SQL)

What you will be able to do

  • 2.1 Evaluate analytical model data preparation processes.

Activity

Start with this week’s 5 videos, then: Seminar, guided reading and a short written task: evaluate analytical model data preparation processes.

Study materials

Videos

  • What is Data Integration? Unlocking AI with ETL, Streaming & Observability · YouTube · IBM Technology · 7 min · for registered students
  • Feature Engineering in ML · YouTube · Neso Academy · 18 min · for registered students
  • Machine Learning Pipeline · YouTube · Neso Academy · 17 min · for registered students
  • AI and Machine Learning Data Sources · YouTube · TU Delft · 20 min · for registered students
  • Querying and Exporting Relational Data (SQL) · YouTube · TU Delft · 19 min · for registered students
  • Stream All Things - Patterns of Modern Data Integration • Gwen Shapira • GOTO 2017 · YouTube · GOTO Conferences · 49 min · for registered students
  • Kafka Connect: Build & Run Data Pipelines • Kate Stanley, Mickael Maison & Danica Fine · YouTube · GOTO Conferences · 50 min · for registered students
  • Observability for Data Pipelines: Monitoring, Alerting & Tracing Lineage • Jiaqi Liu • GOTO 2020 · YouTube · GOTO Conferences · 19 min · for registered students

Further resources

  • Foundations of Information Systems, ch. 8: Data Analytics and Modeling · PDF · OpenStax, textbook chapter; pp. 297–338 · for registered students
Materials marked “for registered students” open in the student portal, which is set up as soon as you receive final acceptance.
Course chat

Admitted students ask questions on this week’s page in the student portal: an AI assistant trained on the course answers first, and during the course’s timetabled classes Connect to your tutor brings your tutor into the chat, who may start a call if needed.

Open this week in the portal
Course plan
  • Week 1: Foundations of Data Analytics
  • Week 2: Evaluation of Analytical Frameworks
  • Week 3: Data Ingestion and Pipeline Architecture
  • Week 4: Data Preprocessing Pitfalls and Data Quality
  • Week 5: Applied Descriptive Analytics
  • Week 6: Predictive Analytics for Trend and Demand Forecasting
  • Week 7: Advanced Predictive Classification Models
  • Midterm: Midterm evaluation
  • Week 9: Prescriptive Analytics and Optimisation Modelling
  • Week 10: Model Output Visualisation and Visual Analytics
  • Week 11: Applied Model Synthesis, Governance, and Visual Interpretat…
  • Week 12: Applying Advanced Data Analytics in practice: case studies
  • Week 13: Assignment workshop: research, planning and referencing
  • Week 14: Assignment workshop: drafting, feedback and improvement
  • Week 15: Review and coursework completion
  • Final: Final assessment and submission
Back to the course
Scroll