Many governments are moving towards the use of information and communication technologies (ICT) to allow citizens to easily access information and services. Electronic governance (e-Governance) deals with all regulations and policies to manage and control public service delivery, information dissemination, and citizens' participation in government decision processes through ICT. With iterative data capability and capacity build that goes with digitalization in the public sector, data can come from many disparate and siloed sources. A systematic application of data collection, data storage, database design and management, and information systems management need to be considered. This course introduces you e-governance, possible source systems, the databases that are necessary, and how to store, access, process, and manage them, in preparation for reporting, analytics, and modeling.
What You Will Learn
Upon completion of this course, the learners are expected to:
- understand the concept of e-government and e-governance, and the associated benefits and drawbacks;
- understand how a relational database differs from a flat database, including the function and construction of a joining table;
- understand the different popular ETL frameworks and how they can be used on e-governance data; and
- understand the advantages and disadvantages of using different types of storage and database solutions.
You will need a computer or laptop with Microsoft Excel installed. Computer or laptop requirements are:
- For Windows: Core i3 or better, 4GB RAM or better, MS Excel 2007 or better
- For MacBook: ideally MS Excel 2013 or newer should be installed (some functions require this version on the Mac). If the version of MS Excel is 2011, download and install StatPlus.