Data mining in real time for the entertainment industry’s trend barometer

EXASOL was chosen by GfK Entertainment as a business intelligence platform because it guarantees fast data availability, a high level of reliability, ease of operation and reporting scalability.

  • About GfK

    About GfK Entertainment

    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.

    Industry:Market research
    Application:Marketing: Campaign management & CRM
    Database:EXASOL
    BI tool:SAP Business Objects
  • The initial situation

    The initial situation

    The B2B market-research applications are accessed around one 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.

  • The solution

    The solution

    In mid-2011, the company decided to use the database management system EXASOL to analyze the “video” sector. The data sets 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.