2 Replies Latest reply: Oct 17, 2017 8:35 AM by Christopher Clayford RSS

    Cricinfo Statsguru meets Qlik Sense

    Christopher Clayford

      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:

      cricinfo web page.PNG

      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:

      1.PNG

      2.PNG

      3.PNG

      4.PNG

      5.PNG

      6.PNG

      Regards,

      Christopher.