Scribd
Upload
19 views5 pages

Exp9 Ros Final

The experiment focuses on learning data visualization using Power BI with IPL datasets, analyzing player performance metrics such as Man of the Match awards, wickets taken, extra runs, total runs per season, and dot balls faced. Various measures and summary tables are created to visualize these metrics through bar graphs and column charts. The experiment is conducted by a group of students from the AI & DS branch.

Uploaded by

sinhaarsenic07
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as PDF, TXT or read online on Scribd
19 views5 pages

Exp9 Ros Final

The experiment focuses on learning data visualization using Power BI with IPL datasets, analyzing player performance metrics such as Man of the Match awards, wickets taken, extra runs, total runs per season, and dot balls faced. Various measures and summary tables are created to visualize these metrics through bar graphs and column charts. The experiment is conducted by a group of students from the AI & DS branch.

Uploaded by

sinhaarsenic07
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as PDF, TXT or read online on Scribd
You are on page 1/ 5

Experiment – 09

Aim of the Experiment: Learning Data Visualization using Big Data Analysis
tools (Power Bi).
Performing data analysis using IPL datasets in which there are two CSV files named
‘deliveries.csv’ and ‘matches.csv’.

1) Top 10 players with highest number of Man of the Match awards.


• Creating a New Table to calculate the number of Man of the Match awards for
each player.
ManOfTheMatchCount = SUMMARIZE(matches, matches[Player_of_Match],
"Awards", COUNT(matches[Player_of_Match]))
• Sort the table in descending order using Award column.

• Creating a Bar graph for highest number of Man of the Match awards.
2) Visualize the highest wicket takers in each season from 2008 to 2024.
• Create a New Measure for wickets in the deliveries table.
TotalWickets = COUNTAX(FILTER(deliveries, deliveries[dismissal_kind] <>
BLANK() && deliveries[dismissal_kind] <> "run out"),
deliveries[dismissal_kind])
• Create a Summary Table for wickets per season.
WicketsPerSeason = SUMMARIZE(deliveries, matches[season],
deliveries[bowler], "Wickets", [TotalWickets])

• Using a Stacked Column Chart to represent wickets taken by the top bowlers for each
season from 2008 to 2024.
3) Calculate and visualize the bowlers who have given highest number of
extra run (Top 10).
• Create a New Measure for extra runs in the deliveries table.
ExtraRunsByBowler = SUM(deliveries[extra_runs])
• Create a New Table to sum extra runs by bowler.
ExtraRunsSummary = SUMMARIZE(deliveries, deliveries[bowler],
"TotalExtraRuns", [ExtraRunsByBowler])

• Using a bar chart to visualize the bowlers who have given highest number of
extra run.

4) Visualize the highest total run score in each season from 2008 to 2024.
• Create a New Measure for total runs.
TotalRunsPerSeason = SUM(deliveries[total_runs])
• Create a New Table for total runs per season.
RunsBySeason = SUMMARIZE(deliveries, matches[season],
"SeasonTotalRuns", [TotalRunsPerSeason])
• Using a column chart to visualize the highest total run score in each season.

5) Visualize the batsmen who has faced highest number of dot balls.
• Create a New Measure for dot balls.
DotBalls = COUNTAX(FILTER(deliveries, deliveries[total_runs] = 0), deliveries[ball])
• Create a New Table to summarize batsman.
DotBallsByBatsman = SUMMARIZE(deliveries, deliveries[batter], "TotalDotBalls", [DotBalls])
• Using a Bar Chart to visualize the batsmen who has faced highest number of
dot balls.

Submitted By:
Name: Roshan kumar Das
Name: Suraj Kumar Subudhi
Regd no:
Name2101020113
: ADITYA SINHA
Reg No. - 2101020065
Group:Group
2 :1
Branch: AI & DS
Group: 6

You might also like