Summary

The typical TVET College management structure is comprised of 4 pillars or divisions. These are:

  1. Education,
  2. Innovation and Development,
  3. Corporate Services and,
  4. Finance.

Data is generated by the 4 divisions, captured in a central database and in other locations. For the purposes of illustration this report is populated with the findings of an anonymised TVET dataset. The result is a demonstration of the utility of dynamically linked, continuously integrated - continuously deployed reports.

Data

The anonymised data used in this document was provided by a local TVET College. The dataset contains 11365 records.

Preprocessing

The data was fetched, tidied,wrangled and is presented as the visualisations below.

Results

Table showing average balance and average age per campus

campus average_balance average_age
!Gâsab 4079 29
!Gâsas 5259 30
|Khi 8426 28
Abotse 4596 30
Ada 848 36
Gangans 1119 38
Kai aios 2172 34
Toxoba 3039 30

Table indicating top 6 debtors

surname stud_number course_name campus course_code balance gender employer age yr block type
nzmnqx 991102553 tourism l4 !Gâsas ncv4 68244.0 female null 26 3 Y F
gxdx 991201613 tourism l3 !Gâsas ncv3 67419.0 female null 29 2 Y F
jxrx 991103789 marketing l4 !Gâsas ncv4 66268.4 female null 28 3 Y F
nyxmxndx 991201015 tourism l3 !Gâsas ncv3 66039.0 female null 28 2 Y F
mxkxlxlx 991203297 tourism l3 !Gâsas ncv3 65254.0 female null 30 2 Y F
mkhzsxnx 991203699 marketing l3 !Gâsas ncv3 60040.0 female null 27 2 Y F

Chart that indicates student registration distribution by qualification

Chart that shows correlation between age and balance