Skip to content

This project involves integrating live cricket score APIs into Power BI to enable real-time updates of match data. Data is fetched using Python in Power BI for cleaning and transformation. Within Power BI, DAX measures are created to calculate various cricket statistics like strike rate and economy, enhancing the dashboard's interactivity.

Notifications You must be signed in to change notification settings

Kinjallllll/Ipl-data-analysis

Folders and files

NameName
Last commit message
Last commit date

Latest commit

 

History

1 Commit
 
 
 
 
 
 

Repository files navigation

IPL Data Analysis Project using PowerBi


PowerBi Project involves integrating live cricket score APIs into Power BI which fetches the data from PowerQuery

  • Python code to call the live cricket score APIs and retrieve the data

  • Importing the retrieved data into Power BI using Power Query

  • Cleaning and transform the data as needed to prepare it for visualization.

  • Creating tables or data models within Power BI to organize the data effectively.

  • Creating DAX new measures to obtain Strike Rate, Status, Runs Per Ball, fours, sixers, wides, wickets, economy, and images, etc

  • Creating Tooltips for Batsman and Bowler data

  • Merged different tables to get Team, Batsman and Bowler Logo

    Api Link: https://rapidapi.com/cricketapilive/api/cricbuzz-cricket/

Screenshot 2024-05-15 211637

Screenshot 2024-05-15 211651


Guided by: The-Developer-BI

About

This project involves integrating live cricket score APIs into Power BI to enable real-time updates of match data. Data is fetched using Python in Power BI for cleaning and transformation. Within Power BI, DAX measures are created to calculate various cricket statistics like strike rate and economy, enhancing the dashboard's interactivity.

Topics

Resources

Stars

Watchers

Forks

Releases

No releases published

Packages

No packages published