Dashboard Andries Bottema Educational Science & Psychology & IT Professor of Business Intelligence, GRC & Analytics Founder of various IT start-ups CINOP projects: College MIS and DHET Datawarehouse Good dashboards have 4 characteristics MEASURE COMPARE ACTIONABLE NORM Example: Dashboard is collec.on of Key Performance Indicators (e.g. drop out rates/reten.on/throughput, employers rela.ons, employability, etc.) To create the right set of KPI’s usually the Balanced Scorecard is used KPI Framework for TVET colleges (int.) Relevancy 1-5 Dashboard reflects if there is contribu.on to strategy: measuring if people and processes do their things right Dashboards come with 3 complexities n Dashboards contain KPI’s that reflect a network of underlying Indicators that MIGHT contribute to the strategy n Dashboards contain data that is captured from different sources, so the data quality and integrity is REALLY important. n Some.mes Dashboards contain pseudo data, and to find real proof, cause and effect, the connec.on to underlying databases has to be defined for further analysis. Lots of KPI’s to put on a dashboard main processes n Teaching n Learning suppor.ng processes n Student Admin n Student Finance n Lecturer HR n Means of Educa.on secondary processes & compliance n Finance n Payroll Who needs what? Principal CFO Teaching Learning Student Admin Student Finance Lecturer HR Means of Educa.on Finance Payroll Campus Parents DHET Manager Relevancy 1-5 Connecting KPI’s to unit level data from colleges Big Data Analy.cs Data Warehouse Reports MIS systems BMS systems Spreadsheets Finance Systems Business Processes HR Systems Remarks on using data in dashboards n Spreadsheets are not reliable as source n Standalone Systems for separate business processes (Finance, HR, Student) might have different versions of the truth n Cleaning and connec.ng data is costly n Gathering reliable KPI data cannot be done without implemented processes and usage of Business Management Systems at colleges: Asking Colleges for reliable data for KPI’s: Review of 4 DHET data capturing excercises going on n Asset System – Consolida.on of Ops. planning (targets, enrolments, CAPEX etc.) spreadsheet into one consolidated report Review of 4 DHET data capturing excercises going on n Asset System – Consolida.on of Ops. planning (targets, enrolments, CAPEX etc.) spreadsheet into one consolidated report n SAICA finance transac.on capturing excercise n Aggrega.on of FETMIS ongoing enrollment and Finance data Review of 4 DHET data capturing excercises going on n Asset System – Consolida.on of Ops. planning (targets, enrolments, CAPEX etc.) spreadsheet into one consolidated report n SAICA finance transac.on capturing excercise n Aggrega.on of FETMIS ongoing enrollment and Finance data n HETMIS Datawarehouse with integra.on to College BMS and MIS systems HETMIS is the long term strategy of DHET Big Data Analy.cs Data Warehouse Reports TVET sector SETA’s QCTA (?) Dashboards § it ain’t nothing without data § it ain’t nothing if colleges do not have their processes supported by IT systems § it ain’t nothing if we cannot look beyond the gauges § it ain’t nothing if we measure what we cannot improve § it ain’t nothing if we do not improve What is beyond dashboards? n Predic.ve Analy.cs n Scenario calcula.ons n What-‐if analysis on bo_lenecks if we want to grow the sector Dashboard
© Copyright 2024 ExpyDoc
