BussinessIntelligenceInFootball is repository for final, thesis, project for faculty.
It is based on data from Kaggle European Soccer data set.
Full name of final work is "Business intelligence in football: Modelling, Analysis and Reporting "
For now work is written just in Bosnian language, but soon it will be translated into English
European Soccer data set is in NoSql database, for the purpose of project it is extracted in excel, transformed and imported into SQL relational database.
Data warehouse is designed to analyze success of teams based on result of matches in star schema with 5 dimensions and fact table Golovi.
Integration of data from database to data warehouse using Microsoft Integration Service.
For further analyze, based on data warehouse, tabular model is created with messures and KPI's.
Reporting is done in PowerBI
- Import database to your local SQL server using script.
- Create data warehouse using script set up.
- Open Microsoft Integration Project with Visual Studio and run packages for loading data.
- Open Tabular model with Visual Studio and change source of data to connect to your local data warehouse
- Open PowerBI project and preview reports.
Flow of data
NOTE! In data set there are 3 pairs of clubs which have same long name of club, for purpose of analysis their long and short club name is connected into new club name to have all clubs with unique name
Querries for sources
Flow of data
Querries for soruces
Inside PowerBI project you can check several types of reports:
- League standings (every league has unique report with logo of the league)
- Scored and conceded goals over months
- Comparison of clubs on scored and conceded goals over months
- Map
- Comparison of clubs on tactial setup