The Thai Government’s Office of Small and Medium Enterprises Promotion (OSMEP) has been supporting Thai SMEs through several promotional plans each year. In order to roll out effective schemes, OSMEP has been turning a vast amount of data from various sources into useful insights. Formerly, the Database and Statistics Division at OSMEP is responsible for collecting, analyzing and distributing relevant data to other strategic divisions. Due to the diverse demands, the hitherto process involved preparing customized data files on a per-request basis. This not only requires large effort from the database team but also caused data discrepancy from time to time.
In July 2015, I worked with a team at Runnables to implement a business intelligence platform for OSMEP. The system integrates data from other agencies such as the Department of Business Development (DBD) and the National Statistical Office (TNSO) to produce relevant reports and visualizations. Personnel from all divisions of OSMEP could customize the filters and dimensions on the reports to their needs and export them as spreadsheet files. All report formats could be flexibly customized further by the Database division. In this project, I used Microsft SQL Server Analysis and Reporting Service to implement vital indicators, reports and visualizations. I also designed the front-end web experience used by data consumers.
Since its deployment in September 2015, the system has experienced over 10,000 report views in 2016 both from OSMEP and other government agencies in Thailand.
The data model in Microsoft SQL Analysis Service