Business Intelligence for Employment Classification in Jakarta Government Data

As an open data which are provided by government, public can access and assist government to analyze and look for solution to social problems among communities. Jakarta Open Data shares employment data that is able to be starting point into analysis or recommendation by building data warehouse. OLTP data suggested for the data warehouse is the existing employment type based transactions, which will be used to analyze employment and unemployment rate in each region. The proposed method to design the data warehouse is using 9-steps from Kimball. The selected process for the data warehouse is calculating number of employment type, with dimensions of region, education type, sex and employment type. Region has 3 level area in sub-district and village. The result of process and analysis will be provided into certain reports and dashboard. Dashboard will be very helpful directly to provide high level data for all stakeholder or decision maker.