GfK Entertainment was created in 2003 as a result of the merger between media control and GfK. The joint venture is now a world-leading provider of comprehensive market information in the entertainment sector. More than 6,000 customers from over 30 countries regularly use products and solutions from media control GfK International so as to obtain official chart listings and extensive market research data from one source. At peak times 35,000 searches are carried out daily.
The initial situation
The B2B market-research applications are accessed around 1 million times every month. Every year, GfK Entertainment processes 500,000,000 sales reports and in the music sector alone more than 500 GB of raw data are processed. This has been accompanied by an enormous growth in data that stands at 100 percent a year. At the end of 2010 the database solution reached its limits when processing large amounts of data.
In mid-2011, the company decided to use the database management system EXASOL to analyse the “video” sector. The datasets from the books and games divisions were transferred into individual data marts in spring 2012. EXASOL was chosen as a business intelligence platform because it guarantees fast data availability, a high level of reliability, ease of operation and reporting scalability.