Abstract

Data warehouse technology in the world of informatics can be applied in television editors to predict events in the future. The results of implementing a data warehouse in television editors since the Covid-19 pandemic shows that in the future, television coverage will still be dominated by health news 80.64 percent and economic news 65.61 percent. In Indonesia, legal and criminal news reports have also become a news trend as a result of these health and economic problems. The television editorial data warehouse was designed using Kimball's Nine-Step method and implementation using Microsoft SQL Server and Tableau. And to predict the news in the future analyzed using the Markov model. Apart from analyzing television news, this data warehouse is also capable know the performance of the television editorial team, namely the performance of news producers, reporters, and cameramen. The results of this data warehouse can be used by television management and chief editors to make informed strategic decisions.

Highlights

  • Data warehouse technology is used to manage large amounts of data collection to assist management in creating data warehouse strategy decisions [1]

  • This paper raises the application of data warehouse technology in the field of mass communication, especially in television reporting

  • The results of the completed data warehouse can show the news trend in television editors where health news in particular the problem of the coronavirus or covid-19 occupies the highest position in the news, followed by economic and legal news which is if traced further still in the unity with health news

Read more

Summary

Introduction

Data warehouse technology is used to manage large amounts of data collection to assist management in creating data warehouse strategy decisions [1]. There is no instrument built to manage the news that has been broadcast This television editorial data warehouse can be used to help decision-making in television editors. The data warehouse produced this time knows what news is the top issue and who the editorial team is most productive work on coverage and work on television news programs. The output of this data warehouse will be can be used to support the decisions of television editors in terms of determining newsworthy of broadcast and worthy of coverage, as well as to determine career advancement and promotion of the television editorial team. To observe the accumulation of an event, as news collection, and employee performance, here using the Markov Process Model mathematical model that can predict events things to come [21], [22]

Literature Study
Field Study
Results and discussion
Conclusion
Full Text
Published version (Free)

Talk to us

Join us for a 30 min session where you can share your feedback and ask us any queries you have

Schedule a call