Applying dashboards for manufacturing by comparing programs used between Google Data Studio and Microsoft Power BI

Abstract

The purposes of this research were 1) to apply the dashboard to solve various problems, 2) to manage database systems that can be used in Power BI programs and Google Data Studio. The industrial model factory is a brake pad factory. The researcher analyzed the problems from all 3 departments, the planning department, the production department and the quality control department. The researcher analyzed problems, databases and selected indicators to use. The databases are managed before being used in Microsoft Power BI to analyze, examine, identify trends in problems and expected to happen. The researcher has applied indicators and control charts for display. Information is collected and managed by normalization. From the analysis of problems from 3 departments, it was found that the planning department found problems in delivery on time because the status of production is unknown. The production department encountered the problem of delayed surveillance because the problem is not summarized from the database. The quality control department encountered the tendency problem of the product's test results. This affects the product's performance because the test hardness (hardness) and specific gravity (specific gravity) tend to be low, but the test results are within the specified criteria. Making it not vigilant about the trend of the test results. After dashboard creation compares Microsoft Power BI and Google Data Studio. The research results found that the result of using the dashboard to detect problems that arise can be. The planning department can solve the problem of overdue deliveries. The production department can help reduce production problems in terms of productivity and waste monitoring. Quality control department to control problems arising from test values, see trends in product properties to monitor problems that arise can analyze waste to track problems. Compare the usage of Microsoft Power BI and Google Data Studio. Google Data Studio is appropriate to start operations because it is easy-to-use report that can be forwarded. Signing up is not difficult because it is a public email and importing data is not complicated. Microsoft Power BI can be further developed. Easy-to-manage data source. No duplicate preparing data is required.