Gohan Sihite
Telkom University

Published : 2 Documents Claim Missing Document
Claim Missing Document
Check
Articles

Found 2 Documents
Search

Data Governance In Traffic Management Based On Average Daily Traffic (ADT) Data Prediction Using Python Gohan Sihite; Naila Syakirotul Rizkiyah
Governance IT Adoption and Technology Advance Vol. 1 No. 2 (2026)
Publisher : Telkom University

Show Abstract | Download Original | Original Source | Check in Google Scholar | DOI: 10.25124/govita.v1i2.11212

Abstract

Data governance is crucial to ensure that traffic data is collected, managed, and used accurately to support quick, precise, and evidence-based decision-making in traffic management. The main challenge faced by many transportation agencies is the lack of an established data governance framework, which means that the utilization of Average Daily Traffic (ADT) data remains descriptive and does not yet support predictive planning. This situation results in traffic management being reactive and less effective in handling vehicle surges during critical periods. This study aims to implement a data governance framework in traffic management by developing comprehensive data management practices, including data acquisition, data quality assurance, and data-driven decision-making through ADT data prediction using the Python programming language. The approach applied is simple linear regression, applied to four years of historical ADT data to create a systematic and accountable prediction model, in accordance with data governance principles: accuracy, affordability, and policy relevance. The data were coded as numerical variables and analyzed to estimate future vehicle volumes clearly and replicably. The study's findings indicate that a Python-based prediction model, when integrated into the data governance structure, can provide more accurate, measurable, and policy-relevant traffic volume projections. This contributes to improving the quality of Data Governance, particularly in providing reliable and relevant information for strategic decisions. By incorporating this prediction system into the data governance framework, the relevant agencies are expected to be able to plan more proactive traffic management strategies, including vehicle flow regulation, road capacity optimization, and effective resource allocation based on structured understanding and strong data governance.
Integration of Data Governance and Development of Business Intelligence Dashboard for Decision-Making in Regional Water Utility Cindy Sinaga; Gohan Sihite
Governance IT Adoption and Technology Advance Vol. 1 No. 2 (2026)
Publisher : Telkom University

Show Abstract | Download Original | Original Source | Check in Google Scholar | DOI: 10.25124/govita.v1i2.11229

Abstract

Public service organizations need effective data management in order to deliver better services and improve decision making. This study analyzes the implementation of Data Governance and Business Intelligence at Perumda Air Minum. Prior to the conduct of this study, customer complaint data was captured manually, and the formats of those inputs were disparate. This resulted in unreliable information. The study took a qualitative descriptive approach using observation, interviews and document analysis. Data Governance was formalised by cleansing, validating, and managing data quality. Google Spreadsheet was used as a staging layer where customer complaint information was ingested through an Application Programming Interface (API) connection. The data was then This data was then visualised with a Business Intelligence dashboard using Looker Studio. Insights were offered for complaint trends, category distributions, branch-level complaint analysis, and operational monitoring tables on the dashboard. The study finds that Data Governance enhanced data consistency, completeness and reliability of reports. The Business Intelligence dashboard helped with operational monitoring and decision making as well. Further, the combination of Data Governance and Business Intelligence enhanced reporting efficiency and organizational transparency.