FI2BEDW05 Data Warehousing

FI2BEDW05 Data Warehousing

  • Course description
    • Course Code
      FI2BEDW05
    • Level of Study
      5.2
    • Program of Study
      Back-End Development 2
    • Credits
      5
    • Study Plan Coordinator
      Frederick Johannes Botha, Joshua Wiggill
Teaching Term(s)
2025 Autumn
2026 Autumn
About the Course

This course teaches candidates the fundamental knowledge, tools and processes associated with implementing and utilising a data warehouse. Candidates are given the skills to consolidate data from various sources into a centralised store, utilising ETL and ELT methods when applicable. Reporting tools are also demonstrated to teach candidates how to generate meaningful reports from the data warehouse. 

Storing large amounts of data from various sources and generating valuable reports is an important skill for backend developers. Competencies from this course will enable candidates to contribute to data warehouse projects and utilise them to create value for future clients. 

Course Learning Outcomes
Knowledge

The candidate: 

  • has knowledge of the concept and purpose of using data warehousing to analyse and report data 
  • has knowledge of theories and main approaches used to build a data warehouse system 
  • has knowledge of industry-relevant reporting tools used in data warehouse systems 
  • has insight into own opportunities for development in the field of data warehousing 
Skills

The candidate: 

  • can find and refer to information relating to data warehousing 
  • can explain vocational choices when choosing an approach to build a data warehouse system 
  • can explain vocation choices when using tools to build reports 
  • can reflect over own data reporting and data warehouse 
General Competence

The candidate: 

  • can plan and carry out tasks aimed at building a data warehouse system alone or as part of a group and in accordance with ethical requirements and principles of data usage 
  • can plan and carry out tasks to generate reports with data extracted from a data warehouse 
  • can contribute to data warehouse system building and data reporting 
Learning Activities

Digital Learning Resources
The learning management system (LMS) is the primary learning platform where students access most of their course materials. The content is presented in various formats, such as text, images, models, videos or podcasts. Each course follows a progression plan, designed to lead students through weekly modules at their own pace. Exercises and assignments (individual or in groups) are embedded throughout the courses to support continuous practice and assessment of the learning outcomes.

Campus Resources
In addition to the digital learning resources, campus students participate in physical learning activities led by teachers as part of the overall delivery.

Guidance
Guidance and feedback from teachers support students' learning journeys, and may be provided synchronously or asynchronously, individually or in groups, via text, video or in-person feedback.

Assessments
Form of assessmentGrading scaleGroupingDuration of assessment
Course Assignment
Pass / Fail
Individual
1 Week(s)
Reading List

Teaching materials, reading lists, and essential resources will be shared in the learning platform and software user manuals where applicable.