- Power BI
- API (Rapid API)
- Figma (For Background Design)
I designed a comprehensive Power BI dashboard to visualize IPL scorecards and points tables. This project leverages real-time data from Rapid API to ensure that the displayed information is always up-to-date, providing an accurate and dynamic view of the ongoing IPL season.
I first discovered this project idea on YouTube, which inspired me to create my own version. I signed up for Rapid API and utilized the Cricbuzz Cricket API to fetch the necessary data.
- API Source: Cricbuzz Cricket API
- Series ID: 7607 for IPL 2024 season
- Data Retrieved:
- All match details
- Team squads
- Venue information
- Player information
- Player images
-
Power BI Blank Query:
- Used the advanced editor to call the API and retrieve the required data.
- Pulled all necessary data including match details, team squads, venue, and player information.
-
Data Cleaning and Transformation:
- Utilized Power Query to clean and prepare the data.
- Renamed columns, merged tables, and created a structured dataset suitable for the dashboard.
- API Link: Cricbuzz Cricket API - The source of real-time cricket data used in this project.
- Schema for This Project: Database Schema - A detailed schema document outlining the tables and relationships used in this project.
- Real-Time Data: Dynamic scorecards and points tables with up-to-date information from the Cricbuzz Cricket API.
- Detailed Insights: Lightbox feature for in-depth match, team, and player details.
- Real-Time Updates: Live scores, run rates, and wickets.
- User Feedback: Testimonial slider showcasing user satisfaction.
- Team Logos: Image slider featuring team and sponsor logos.
- Extra Pages: Includes detailed articles, terms, conditions, and privacy policy.
- Expertise: Demonstrates data integration, cleaning, and visualization skills.
- Created interactive scorecards showing real-time match statistics such as scores, run rates, and wickets.
- Developed a points table to track team standings throughout the IPL season.
- Designed tooltips for bowlers and batters, providing detailed player information when users hover over a player's name.
- Integrated player and team logos, as well as player images, to enhance the visual appeal of the dashboard.
- Wrote multiple measures in Power BI to dynamically display images, scores, run rates, wickets, and other relevant data similar to Cricbuzz scorecards.
- Successfully created a dynamic and interactive dashboard that provides valuable insights into the IPL season.
- Enabled users to track their favorite teams and players in real time.
- Enhanced the decision-making process for cricket analysts and enthusiasts by providing comprehensive and easily accessible data.
- Create a scorecard where users can see all performances and team standings in the points table.
- Add more information such as player stats, venue stats, and records from all seasons.
- Include records of all matches in the dashboard and make it live with real-time scorecards.
- Enhance the dashboard further to make it even more attractive and comprehensive.
The project is currently paused due to the need for a paid API version to access more data. Future updates will focus on expanding the dashboard's capabilities.
Here are some snapshots of the dashboard:
This project showcases my ability to integrate real-time data with advanced visualization tools, demonstrating my skills in data analysis, dashboard design, and API utilization. It provides a valuable resource for IPL fans and analysts, offering deep insights into the ongoing cricket season.
"💪 Every challenge is an opportunity to grow. 🚀 Keep pushing your boundaries."