We use Excel to Crunch 206,000 English League Football Results.
This is an example of the new powerful and flexible tools available in Power Excel.
Excel crunches 206,000 English League football results, showing the output via a Power BI report.
Power query was used to clean and join the tens of thousands of results . We used the new DAX language to create over 20 measures to help us analyse all the results.
Page 1 shows 1 to 1 performance for every team who has ever played in the English leagues since 1888.
The report on page 2 gives every teams’ performance against every other team , with accumulative goals scored for and against , draws, % of wins, draws etc. How has your team done over the decades .We hope you enjoy it.