Data Visualization and Forecasting Domestic Component Level (TKDN) Indonesian Ministry of Industry Using Power Business Intelligence

Abstract

The government is optimizing the Domestic Component Level (TKDN) for strategic projects funded by the State. Domestic products that must be used must have a TKDN value of at least 25%. According to the Head of LKPP, the target for procurement of government goods/services for domestic products (PDN) in 2023 is 90%. Ironically, products that have TKDN certificates are not comparable to the needs of government agencies. This is of particular concern, whether the targets declared in 2023 will be met or not. Therefore, a touch of technology is needed to be able to analyze TKDN data quickly and precisely. Power Business Intelligent is one of the tools that can be used to analyze data easily understood. Data is taken on the official website of TKDN Kemenperin which has a Microsoft excel file extension. The indicators observed are the trend of TKDN certificates per year, the trend of certificates per month, the trend of goods categories, regional demographic trends in Indonesia and forecasting TKDN certificates for the next 5 years. The overall results of TKDN certified products in 2019-2022 were 33,554. The average number of TKDN products is 49.15% with the highest content of 99.99%. On average, the Ministry of Industry issues TKDN certificates every day as many as 43 products. The number of products certified TKDN with the LKPP e-catalog website is not comparable. The results of the analysis showed that the number of new TKDN certified products was 34.6% and 65.94% had not been certified.