shakanand's avatar
shakanand
Microsoft Employee
9 years ago

Cricket Score Analysis Using Power BI

Data    

   * Data for this analytics is downloaded from publicly available site :  http://cricsheet.org/ 

 

 

Power BI
    * Includes data from more than 3000 matches since 2005
    * All the calculations are implemented using DAX formulas (aggregated from ball by ball data)
    * Results aggregated from approximately 2 million ball by ball data rows
    * Data parsed using Power Query from YAML format
    * Total Data Size in Power BI : 20 MB
    * Results shown in these analytics may not be accurate due to missing data, calculation logic issue, etc

 

 

 Thanks,

Sha Kanjoor Anandan

 

 

 

Entertainment
Sports

1 Reply

  • Anonymous's avatar
    Anonymous
    Not applicable
    7 years ago

    Nice work! Do you have any tips on how to parse YAML using Power Query? I'm struggling to parse a column with YAML data.