The box office (BO) income had significantly declined up to 80% in 2020, as the COVID-19 pandemic emerged. To minimize further financial risks, multiplex (multiple cinema complexes) owners need to analyze their potential income for each movie, each week. Therefore, we developed a proper data mining strategy that allows multiplex owners to analyze and discover insights on how successfully produced movies could be. The methodology comprises (1) data loading and exploration, (2) data cleaning, (3) data selection, integration, and transformation using Pentaho, (4) data mining in which the results were stored in the MySQL database, and (5) pattern evaluation and presentation using Qlik Sense as the Business Intelligence (BI) dashboard. Based on our data mining methodology, we revealed that drama, comedy, action, and thriller are favorite genres. We also found that DreamWorks Animation and Pixar Animation Studios are both the most popular production houses, even Apatow Productions and Escape Artists still have the biggest revenue on average.
Read full abstract