This Power BI dashboard provides an analysis of the ICC Champions Trophy Cricket tournament from 1998 to 2017, focusing on team performance, match statistics, and individual achievements.

Key Components of the Dashboard:

1. Team Selection Panel (Left Sidebar)
   • A filter allows users to select a team (e.g., Australia, India, England, etc.) to view specific statistics.
2. Summary Metrics (Top Section)
   • Total Matches by Team: Displays the number of matches played by the selected team.
   • Wins as Team: Shows the total number of wins achieved by the selected team.
   • Win Percentage: Calculates the team’s win rate based on matches played.
3. Total Matches and Wins Analysis (Charts)
   • By Ground (Bar Chart):
     • Displays the number of matches played and won by the selected team at different venues.
   • By Match Days (Donut Chart):
     • Compares matches played and won on day vs. day-night matches.
   • By Winning Margin (Bar Chart):
     • Shows how the selected team won matches, categorized by runs or wickets.
4. Player of the Match Analysis (Bottom Section)
   • A bar chart ranks players based on the number of “Player of the Match” awards received.

Dataset : https://www.kaggle.com/datasets/kamalisrani/icc-champions-trophy-cricket-dataset-1998-2017?select=all_champions_trophy_players_list.csv

Usage in Power BI:

• Filters & Slicers: The left sidebar acts as a slicer to filter data based on the selected team.
• KPIs (Key Performance Indicators): The summary metrics (Total Matches, Wins, and Win %) provide quick insights.
• Bar and Donut Charts: Different types of visualizations make it easy to analyze match performance based on location, time, and winning margin.
• Interactivity: The charts dynamically update when a team is selected from the filter panel.

This dashboard is useful for cricket analysts and fans to evaluate team performance across different conditions in the ICC Champions Trophy.

Part 3 DAX Coding

Years Won Table : https://github.com/slidescope/data/blob/master/Year_Won_CT.xlsx

WonasTeam1 = 
VAR SelectedTeam = SELECTEDVALUE('Matches'[Team1]) 
RETURN 
CALCULATE(
    COUNTROWS('year_won'), 
    'year_won'[Team Won] = SelectedTeam
)

CTsAsTeam1 = 
VAR SelectedTeam = SELECTEDVALUE('Matches'[Team1]) 
RETURN 
CALCULATE(
    MAX(Matches[Team1 Total CTs participated]) , 
    'year_won'[Team Won] = SelectedTeam
)

Matches Won Team1 = 
VAR SelectedTeam = SELECTEDVALUE('Matches'[Team1]) 
RETURN 
CALCULATE(
    COUNTROWS('Matches'), 
    'Matches'[Winner] = SelectedTeam
)