FI2BEDW05 Data Warehousing
FI2BEDW05 Data Warehousing
- Course description
- Course codeFI2BEDW05
- Level of study5.2
- Program of studyBack-End Development 2
- Credits5
- Course coordinatorFrederick Johannes Botha, Joshua Wiggill
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.
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
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
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
In this course, the following teaching and learning methods can be applied, but are not limited to:
- Lecture: Educator-led presentations or activities providing knowledge, skills, or general competencies in the subject area.
- Group work: Collaborative activities where students work together to solve problems or complete tasks.
- Tutoring: One-on-one or small group sessions with an instructor for personalized guidance and support.
- Student presentations: Opportunities for students to demonstrate their understanding of course material by presenting to peers.
- Online lessons: Digital content delivered via an online learning platform.
- Guidance: Individualized advice and direction from instructors to support students in their learning journey.
- Workshops: Practical sessions focused on hands-on application of theoretical concepts or skills.
- Self-study: Independent study where students engage with course material on their own without any teacher support.
Teaching materials, reading lists, and essential resources will be shared in the learning platform and software user manuals where applicable.