Need: DRE has expressed, and others' observations confirm, that the DRE's data analysis processes exhibit characteristis of siloing, duplication, and reliance on manual tools which result in inefficiency and lowered responsiveness.
Purpose: To demonstrate a system that leverages technology to improve the DRE's data analysis and reporting processes.
Developer: Ms. Caitlyn Low, CMU/TCinGC Student Consultant 2020.
Local Counterpart: Edwel Ongrung, Palau MOE TCinGC Project Supervisor.
Project: Demonstration of a system composed of Data Source -> Data Pipeline -> Data Warehouse -> Data Analysis -> Reporting, using concepts of Business Intelligence, Data Analysis Stack, and Extract/Load/Transform.
Status: Successfully completed and turned over to MOE on August 14, 2020.
Next: First DRE should decide if they want to implement what has been demonstrated by the project. If they do, they should realize that there are many components to the effort. And each componet can easily represent several individual projects. At the least, DRE has two options:
The DRE has for a long time sought to improve the efficiency of its data analysis and reporting processes. Two examples are proved below to show the different aspects of the problem.
Example 1: Palau's report to the UNESCO Institute of Statistics (UIS).
External data, unclear work assignments, siloing, time intensive manual data processing and analysis
This is an external report which ends up being assigned to the DRE from time to time. The major issues are: certain categories of data and even certain key data are not MOE data so DRE does not have access to them; the indicators needed by UIS are different from indicators used by MOE so DRE ends up doing additional data collection; no one in the DRE has accountability for the report so it ends up being assigned by the supervisor to someone who has to start it from scratch. The results in a delayed and incomplete report and and a lack of consistency from year to year.
Example 2: MOE Statistics Digest
Informal or non-existent data collection process, siloing, time intensive manual data processing and analysis
This is an internal report using MOE data. It is made available to the public. The report needs data from many sources in the MOE, including school report cards, student registration and residence information, private school data (in terms of data, private schools can be considered internal as they are chartered by MOE), personnel data, curricular data, and others. The biggest issue is that everytime the report needs to be done, DRE has to go out to these data sources to ask for data. Since the the MOE has no formal reporting frameworks that ensure the data is collected, it becomes an imposition on the data sources (eg., schools which are busy with their own work and may view these collections as an imposition). If DRE manages to collect the data, the hard work of data entry (in many cases), cleaning, and verifying needs to take place. Then the manual work of analysing and reporting is assigned to someone to perform. That person does all the work on his laptop, generates the report, and submits it to his boss. The following year, all that has to be repeated even if it is the same person that is assigned. That is, each year is essentially a silo.
There are more examples but it should be obvious that the whole process from data source all the way to the publication of the report needs to be examined.
Even while these issues were apparent, in 2016 the DRE had to take on more data analysis tasks especially to monitor the progress of the new 10 year master plan and by extension, to monitor the progress and effectiveness of the MOE's annual management action plans.
We needed help in setting up a model of the situation so that we can clearly understand the steps in the process, the areas that need attention, and the kind of work needed to attend to those areas. Further, we needed help in exploring potential solutions.
|Ms. Caitlyn Low is the developer for this project. She is a rising junior at Carnegie Mellon University and is working from home in California. Ms. Low's Resume.|
|Mr. Edwel Ongrung is the local counterpart for this project. Mr. Ongrung is the BEA's Administrative Services Manager and also the MOE's TCinGC projects supervisor.|
The two will work on developing a clear model of the DRE's data analysis and reporting process and a demo of a possible solution for the DRE to consider.
Ms. Low successfully completed her projects and submitted her report to MOE management on August 14, 2020. She documented her model and solution demo in writing and on video for the DRE to review at their convenience.
Ms. Low worked with MOE to develop a clear understanding of the context. Then she developed and demonstrated a solution based on Data Pipeline, Data Analysis Stack, Data Visualization, and Business Intelligence concepts. Ms. Low first discussed the importance of the data source -> data pipeline -> data warehouse workflow, then demonstrated the benefits of the data warehouse -> analysis -> reporting using existing DRE data in an MOE database in combination with the Apache Superset business intelligence tool.
Current MOE Reporting Process
A Systemic Approach
With the completion of the demo and its associated documentation, the DRE should have enough information to make a decision whether to pursue a systematic approache or not.
The systematic approach is composed of several individual components. Each component in turn can represent several projects. So take the systematic approach is not a simple undertaking. At the very least, the DRE has to decide on two options.
Looking at the first option, to tackle it piece by piece, here are two example projects.
Please note that other components of the systematic approach will require top management involvement because they involve policy, protocols, job descriptions, etc., and work across units and even different agencies.
Coming soon ...
For now, the project's work website is here: project website.