Data Warehousing for Formula One (Racing) Popularity Rating Using Pentaho Tools

The Data Warehouse is specifically design & created to collectively form a cluster of the Popularity Rating of Formula One Racing at a single place. So, the further development of sport in terms of Data Analysis & complete resource usage can move forward. In this paper we present the complete Popularity Data from both Online & Offline modes in a single distribution place. The diversity of external data agents during the decision-making & analysis process does not gets easier. MySQL relational database management system is used for data schema design & storage of data. Pentaho Server, MySQL workbench, & Integration tools are used for data integration and transformation into a particular form. Multi-dimensional database modelling approach also known as Star Schema approach using the dimension tables and a fact table in the middle is used. Further, we intend to propose a data centre for supporting the decision-makers in Formula One Racing i.e. FIA & CEO of F1. The data for the data warehouse is generated by the help of stakeholders like Formula One itself, Liberty Media (the current owners of F1) and various other part-takers like teams & venues. The collected information is cleaned & transformed at the F1 data warehouse. Pentaho Schema's workbench is used to make a Mondrian outline with one block that comprises a separate truth table and a couple of measurements, each with a different order consisting of a bunch of levels. Pentaho Server is used for querying the cube using the MDX query for transforming the data to tabular and chart representation. Based upon the data transformed & descriptions, the decision-maker or stakeholders can decide for upcoming Strategies in Marketing & Publicising.