Design, implementation and exploitation of a data warehouse about basketball statistics from the main European leagues

Abstract

[Abstract]: Nowadays, data analysis and manipulation is a critical aspect in every working sector of our society. These include many subjects such as medicine, finances, education, industry… The reason behind this enormous growth in interest for data is that it allows companies to make decisions that are backed by statistics that suggest that they are correct. It also allows to check the results from previous decisions. As I mentioned before, data analysis is present in every sector, and sports are no exception. This project will consist on showing how a good use of data could help basketball teams and players to be more successful. In order to do it, we will create a Data Warehouse based on the statistics collected from the main European basketball leagues during the last 5 seasons. Firstly, the tools required for this project will be explained, as well as the strategy that will be used during its development. Then, we will show the entire development of creating the Data Warehouse starting from scratch, doing the ETL process that will allow us to manipulate it and finally exploiting it in order to obtain useful conclusions.

[Resumo]: Hoxe en día, a análise e manipulación de datos é un aspecto crítico en todos os sectores laborais da nosa sociedade. Estes inclúen moitos sectores como a medicina, as finanzas, a educación, a industria… A razón detrás deste enorme crecemento do interese polos datos é que permite ás empresas tomar decisións apoiadas por estatísticas que suxiren que son correctas. Tamén permite comprobar os resultados das anteriores decisións. Como comentei antes, a análise de datos está presente en todos os sectores, e os deportes non son unha excepción. Este proxecto consistirá en mostrar como un bo uso dos datos pode axudar a equipos e xogadores de baloncesto a ser máis exitosos. Para facelo, crearemos un Data Warehouse a partir das estatísticas recollidas das principais ligas europeas de baloncesto durante as últimas 5 tempadas. En primeiro lugar, explicaranse as ferramentas necesarias para este proxecto, así como a estratexia que será utilizada durante o seu desenvolvemento. Despois, mostraremos todo o traballo de creación do Data Warehouse comezando de cero, facendo o proceso ETL que nos permitirá manipulalo e finalmente explotándoo para obter conclusións útiles.