FI2BEDW05 Data Warehousing
FI2BEDW05 Data Warehousing
- Course description
- Course CodeFI2BEDW05
- Level of Study5.2
- Program of StudyBack-End Development 2
- Credits5
- Study Plan 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
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.
Form of assessment | Grading scale | Grouping | Duration of assessment |
---|---|---|---|
Course Assignment | Pass / Fail | Individual | 1 Week(s) |