Football database in Excel
Budget: £20 – £250 GBP
I would like a football database built that includes data from the last 3 years (ideally more) of all matches played in the following leagues:
Argentina Superliga
Argentina Primera B Nacional
Australia A-League
Austria Tipico Bundesliga
Austria Erste Liga
Belarus Vysshaya Liga
Belgium Pro League
Belgium First Division B
Bolivia Liga De Futbol Prof
Bosnia and Herzegovina Premier Liga
Brazil Serie A
Brazil Serie B
Brazil Brasileiro U20
Bulgaria Parva Liga
Chile Primera Division
Chile Primera B
Chile Segunda Divisi�n
China PR Super League
China PR League One
Colombia Liga BetPlay
Costa Rica Primera Division
Croatia 1. HNL
Czech Republic Fortuna Liga
Denmark Superliga
Denmark First Division
Ecuador Liga Pro
Egypt Premier League
England Premier League
England Championship
England League One
England League Two
England National League
England Premier League Cup
England Premier League U21
Estonia Meistriliiga
Europe Champions League
Europe Europa League
Finland Veikkausliiga
Finland Ykkonen
France Ligue 1
France Ligue 2
Georgia Crystalbet Erovnuli Liga
Germany Bundesliga
Germany 2. Bundesliga
Germany 3. Liga
Greece Super League
Hungary OTP Bank Liga
Iceland Pepsideild
Iceland 2. Deild
Israel Ligat haAl
Italy Serie A
Italy Serie B
Japan J-League
Japan J2-League
Korea Republic K-League 1
Lithuania A Lyga
Mexico Liga MX
Netherlands Eredivisie
Netherlands Eerste Divisie
Northern Ireland Premiership
Norway Eliteserien
Norway Obos-Ligaen
Panama Lpf
Paraguay Division 1
Peru Primera Division
Peru Segunda Division
Poland Ekstraklasa
Poland 1. Liga
Portugal Primeira Liga
Portugal Segunda Liga
Republic of Ireland Premier Division
Republic of Ireland First Division
Romania Liga 1
Romania Liga 2
Scotland Premiership
Scotland Championship
Serbia Super Liga
Singapore S. League
Slovakia Fortuna Liga
Slovenia 1. SNL
Slovenia 2. SNL
Spain La Liga
Spain La Liga 2
Sweden Allsvenskan
Sweden Superettan
Switzerland Super League
Switzerland Challenge League
Turkey Super Lig
Turkey 1. Lig
USA Major League Soccer
USA USL Championship
Ukraine Premier League
Uruguay Primera Division
Venezuela Primera Division
Wales Premier League
The database needs to contain the following data columns:
League
Home team
Away team
Shots on target 1st half
Goals 1st half
Shots on target 2nd half
Goals 2nd half
Total Shots
Total Goals
I would then like a simple dashboard that allows me to search data and analyse results. An example query would be "for all games where 1st half goals was 0, how many 2nd half goals were scored" - this needs to include any possible combination of the data columns listed above.
Argentina Superliga
Argentina Primera B Nacional
Australia A-League
Austria Tipico Bundesliga
Austria Erste Liga
Belarus Vysshaya Liga
Belgium Pro League
Belgium First Division B
Bolivia Liga De Futbol Prof
Bosnia and Herzegovina Premier Liga
Brazil Serie A
Brazil Serie B
Brazil Brasileiro U20
Bulgaria Parva Liga
Chile Primera Division
Chile Primera B
Chile Segunda Divisi�n
China PR Super League
China PR League One
Colombia Liga BetPlay
Costa Rica Primera Division
Croatia 1. HNL
Czech Republic Fortuna Liga
Denmark Superliga
Denmark First Division
Ecuador Liga Pro
Egypt Premier League
England Premier League
England Championship
England League One
England League Two
England National League
England Premier League Cup
England Premier League U21
Estonia Meistriliiga
Europe Champions League
Europe Europa League
Finland Veikkausliiga
Finland Ykkonen
France Ligue 1
France Ligue 2
Georgia Crystalbet Erovnuli Liga
Germany Bundesliga
Germany 2. Bundesliga
Germany 3. Liga
Greece Super League
Hungary OTP Bank Liga
Iceland Pepsideild
Iceland 2. Deild
Israel Ligat haAl
Italy Serie A
Italy Serie B
Japan J-League
Japan J2-League
Korea Republic K-League 1
Lithuania A Lyga
Mexico Liga MX
Netherlands Eredivisie
Netherlands Eerste Divisie
Northern Ireland Premiership
Norway Eliteserien
Norway Obos-Ligaen
Panama Lpf
Paraguay Division 1
Peru Primera Division
Peru Segunda Division
Poland Ekstraklasa
Poland 1. Liga
Portugal Primeira Liga
Portugal Segunda Liga
Republic of Ireland Premier Division
Republic of Ireland First Division
Romania Liga 1
Romania Liga 2
Scotland Premiership
Scotland Championship
Serbia Super Liga
Singapore S. League
Slovakia Fortuna Liga
Slovenia 1. SNL
Slovenia 2. SNL
Spain La Liga
Spain La Liga 2
Sweden Allsvenskan
Sweden Superettan
Switzerland Super League
Switzerland Challenge League
Turkey Super Lig
Turkey 1. Lig
USA Major League Soccer
USA USL Championship
Ukraine Premier League
Uruguay Primera Division
Venezuela Primera Division
Wales Premier League
The database needs to contain the following data columns:
League
Home team
Away team
Shots on target 1st half
Goals 1st half
Shots on target 2nd half
Goals 2nd half
Total Shots
Total Goals
I would then like a simple dashboard that allows me to search data and analyse results. An example query would be "for all games where 1st half goals was 0, how many 2nd half goals were scored" - this needs to include any possible combination of the data columns listed above.