Hi all
I managed to pull live Test Match data from the Cricinfo website using the web-file connector in Qlik Sense.
I have compiled an analysis on the following disciplines:
- Team
- Batting
- Bowling
- Fielding
- All-Rounders
If you would like access to the app on my Qlik Sense Cloud account, please send me your email address. Please note that i only have 3 invites left, so first come first serve. Your feedback will be greatly appreciated!
Notes:
The main challenge i encountered with the data, was the fact that each web page only gave me 50 rows of results. I then had to use "For Loops" in my back-end scripting to fetch the results on the other pages. Here is an example of what the web page looks like on the site:
Once i pulled the the data for all the teams and players, i proceeded to do some analysis in Qlik Sense. Here are some screenshots of the types of analysis i did:
Regards,
Christopher.
