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.



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

×

Love our blog? You should see our emails. Sign up for our newsletter!