Public Broadcasting Service

Business Intelligence

Public Broadcasting Service



CHALLENGE:

Public Broadcasting Service, or PBS, is revered as the nation’s largest classroom. As the United States’ primary public broadcasting entity, PBS can be found on member stations in every corner of the country.

Consistent with their message of education for all, they sought to learn from their data using Tableau. PBS possesses unique data, which they collect from manually filled-out, annual surveys from all of their member stations. In order to work with this data, they needed an effective way to evaluate, format and clean their data for analysis.

SOLUTION:

PBS required a consultant with extensive experience in Tableau and data management on the whole, which is why they chose InterWorks.

InterWorks first created a custom ETL package to bring survey data into their SQL Server database and make it appropriate for reporting in Tableau. Once these processes were put into place, they began organization-wide implementation.

Additional phases were proposed afterwards for data cleaning as well as bringing more data sources into the newly-designed data warehouse.

RESULTS:

Right off the bat, PBS was able to delve into years of trends and details that they’ve never been able to see. Before working with InterWorks, it would’ve taken countless man-hours to dig up such details.

PBS can now instantly look at year-over-year data concerning a number of variables and metrics. Not only that, the speed to data and consistency that PBS now enjoys has opened up numerous new ways for them to analyze their varied survey data.

By re-shaping their data environment, InterWorks gave PBS a cleaner and more efficient way to look at their data than before. This strengthens the connection between PBS and their data, which in turn strengthens their connection to viewers like you.



Subscribe to our newsletter

  • I understand that InterWorks will use the data provided for the purpose of communication and the administration my request. InterWorks will never disclose or sell any personal data except where required to do so by law. Finally, I understand that future communications related topics and events may be sent from InterWorks, but I can opt-out at any time.
  • This field is for validation purposes and should be left unchanged.

InterWorks uses cookies to allow us to better understand how the site is used. By continuing to use this site, you consent to this policy. Review Policy OK

×

Interworks GmbH
Ratinger Straße 9
40213 Düsseldorf
Germany
Geschäftsführer: Mel Stephenson

Kontaktaufnahme: markus@interworks.eu
Telefon: +49 (0)211 5408 5301

Amtsgericht Düsseldorf HRB 79752
UstldNr: DE 313 353 072