Data Service Platform for Social and Community to Drive the Royal Project Foundation

The Royal Project Foundation is an organization in Thailand which works on various non-profit projects since 1969. Social development, such as population structure, drug problem, educational development and community organization, is one of the foundation's focus areas. Thus, the social data has been collected with various data sources and structures. In this paper, the data service platform for the social and community is proposed to maintain the collection of various data sources and structures. The proposed architecture consists of 3 different data stores 1) data lake, 2) data staging data and data warehouse and 3) CKAN. With the proposed hybrid architecture, the various data types are allowed to be stored in the data lake. Then, the data staging area and data warehouse are used for well-defined schema data. The CKAN store the metadata and data dictionaries of the Royal Project Foundation's data. Furthermore, the prototypes of interactive business intelligence dashboards are developed in order to visualize a summary of the population, education, and public health of Royal Project Foundation's data.