Data Warehouse Modernisation: Czech Television has streamlined its reporting

monthly

data about broadcasts over more than 65 years.

Modernizing the data warehouse, which took place in 2019, has enabled CT analysts to prepare the required reports flexibly – easily, quickly and consistently.

Dynamic data warehouse and modern reporting for Czech Television

Czech Television (CT) operates a total of six channels (full-format CT1, CT2, and CT24 news, CT Sport, children’s CT:D, and the CT Art culture channel) and three television studios. Every day, it delivers nationwide and regional 24-hour broadcasting (terrestrial, satellite and Internet, including for mobile phones). In addition, CT also provides accompanying services such as HbbTV (hybrid broadcast broadband, which combines television broadcasting with broadband Internet), Teletext CT, Teletext Express, EPG (a program guide), closed captioning, and SSU (system software update).

The public service evaluation is carried out using three methodological approaches. These differ according to the type of indicator determining how the public service has been fulfilled, which are based on:

  1. Measurable public behavior and attitudes
  2. Expert assessment of compliance with the principles defined by the ČT Code
  3. So-called “hard data”, for example, from the database of broadcasts

The original system that furnished the third indicator, based on “hard data”, had to be upgraded due to higher demands on reporting. Realizing that storing data about broadcasts from all the channels, consolidating them, and preparing for regular reporting was a challenging undertaking, ČT required a replacement for the original system that would be open, dynamic, and modern.

New data warehouse from Adastra: Automated updates and 20 regular reports per month

As well as the original data, the data warehouse will also store additional data needed for other ČT departments, which use them for various agendas.

The data warehouse is updated automatically and allows the required reports to be generated easily. There are 20 regular reports every month. Further reports, based on historical data about broadcasts, are created according to incoming requests. The time necessary for preparing the data and for the reporting itself has been significantly reduced.

“With the data from our new data warehouse, we can prepare reports about broadcasts quickly and easily. We are now working in an environment that we are able to customize. We work with the solution ourselves, without needing the IT department to intervene.”
Renata Týmová, Head of Research and Analysis at Czech Television

Czech Television: Minimizing report preparation time and managing 35 GB of data

Czech Television (CT) operates a total of six channels (full-format CT1, CT2, and CT24 news, CT Sport, children’s CT:D, and the CT Art culture channel) and three television studios. Every day, it delivers nationwide and regional 24-hour broadcasting (terrestrial, satellite and Internet, including for mobile phones). In addition, CT also provides accompanying services such as HbbTV (hybrid broadcast broadband, which combines television broadcasting with broadband Internet), Teletext CT, Teletext Express, EPG (a program guide), closed captioning, and SSU (system software update).

In cooperation with Adastra, Czech Television has constructed a new solution for data warehousing and reporting. It is built on Microsoft technology and contains approximately 35GB of data. Every month, the solution provides a set of predefined reports, while also allowing users to create their own reports ad-hoc. The reporting processes “live” data – if the input data are changed, the system automatically propagates the update to the new data warehouse and to all dependent reports. This significantly reduces the time spent on preparing reports.

In addition, the data warehouse automatically alerts users to errors in the data, according to predefined checks, on a daily basis. If an error does occur, a notification is sent to the analysts. CT thus improves the data quality right in the primary systems and, consequently, in all the reports and analyses that depend on it.

During construction of the new DWH and the reporting based on it, it was quite difficult to prepare a set of keywords according to which media literacy across all the channels would also be evaluated.

In addition to current data, the data warehouse also stores historical data, going back to the beginning of CT’s regular broadcasting in 1954. Analysts work with these data on special occasions such as anniversaries, public holidays, or when they need to answer statistical-analytical questions from other media – for example, how many times they have broadcast a particular program at Christmas or how often it has been repeated in a specific time period.

The key reports generated automatically by CT’s new data warehouse include, among others:

  • Aiming the programs at various target groups (seniors, disabled people, religious groups, etc.),
  • A list of CT projects and programs concerning the main national minorities living in the Czech Republic,
  • The structure of genres of broadcast (the share of educational, documentary, religious programs, and so on),
  • The proportion of domestic, European and nonEuropean programs among all the broadcasts organized by individual genre
  • The country of origin of the documentaries
  • The proportion of programs with subtitles for the deaf or hardof-hearing
  • The percentage of CT’s own creations, Czech and foreign productions (in detail, for example, up to the percentage of current European productions)
  • The proportion of each individual artistic movement across all art programs
  • The proportion of each individual sport in CT’s entire sports broadcasting
  • The percentage of representation from each CT studio (Prague, Brno, Ostrava) broadcast on CT as a whole, on CT1 and CT2

The input data are checked according to a set of predefined rules, and the user is automatically notified if the system detects an error. As a result, CT now effectively improves data quality right in the primary system.

Another important benefit of the new solution is that it can be used independently of the IT department and of Adastra as the supplier. CT analysts can prepare, update, and edit the relevant “cube” or report by themselves whenever a change is required in terms of data reporting. They can easily define a different data structure and, thanks to the solution’s high level of flexibility, get the requested results.

Get inspired on our blog

Observability platform vs. observability tools 

Complex information systems fail in unexpected ways. That’s why IT teams need both observability tools and an observability platform. To understand the distinction between...

Read more

What is observability? Not just logs, metrics and traces

As dynamic systems architectures increase in complexity and scale, IT teams face mounting pressure to track and respond to conditions and issues across their...

Read more

Good data management and the gap between IT and business are the most burning issues for large Czech companies 

Large Czech companies consider the biggest challenge they will face in the next three years to be good data management and business’ inability to...

Read more