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

Data Processing and Business Intelligence Pipelines

IT604 · Management Information Systems — Week 3 of 16

CourseIT604
Week3 of 16
SemesterII
TutorOnline in the course chat

This week’s topics

Data Processing and Business Intelligence Pipelines

  1. Batch versus stream processing
  2. Extract-transform-load (ETL) workflows
  3. Online analytical processing (OLAP)
  4. Data governance and data quality frameworks
  5. Processing Business Data

What you will be able to do

  • 1.2 Analyse the different ways in which data is stored and processed for use in an organisation.

Activity

Start with this week’s video, then: Seminar, guided reading and a short written task: analyse the different ways in which data is stored and processed for use in an organisation.

Study materials

Videos

  • Processing Business Data · YouTube · Galton College · 20 min · for registered students
  • F2023 #23 - Distributed Data Warehouse OLAP Databases (CMU Intro to Database Systems) · YouTube · CMU Database Group · 83 min · for registered students
  • Processing Streaming Data with KSQL • Tim Berglund • GOTO 2019 · YouTube · GOTO Conferences · 49 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
  • Readings in Database Systems ('Red Book', 5th ed., Bailis, Hellerstein & Stonebraker) · PDF · Other, textbook · for registered students
Materials marked “for registered students” open in the student portal, which is set up as soon as you receive final acceptance.
Week 2Week 4
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: Information Systems Across Functional Areas
  • Week 2: Data Storage Architectures and Database Management
  • Week 3: Data Processing and Business Intelligence Pipelines
  • Week 4: Operational Management and Governance of IS
  • Week 5: Information Systems for Value-Added Organisational Change
  • Week 6: Critical Evaluation of Value-Added Systems
  • Week 7: Auditing and Reviewing Information Systems Performance
  • Midterm: Midterm evaluation
  • Week 9: Strategic Information Systems (SIS) Models
  • Week 10: Strategic IS and Market Competitiveness
  • Week 11: Global Competitive Advantage and International IS Strategy
  • Week 12: Applying Management Information Systems in practice: case s…
  • 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