Categories: Power BI
Tags:

IPL Cricket Data Analysis with Power BI DAX – Part 6 – Season-wise Trends

IPL Cricket Analysis Season-wise Trends

This is part 6 of the IPL Cricket Data Analysis Project with Power BI and DAX where we are doing Season-wise trends analysis.

Dataset used in the Project: Get Here

Questions Covered in this part are:

Player participation trend by season

Their DAX solutions are as follows:
BatterBowlerPlayers = 
VAR Batters =
    SUMMARIZE (
        deliveries,
        deliveries[batter],
        deliveries[Season]
    )
VAR Bowlers =
    SUMMARIZE (
        deliveries,
        deliveries[bowler],
        deliveries[Season]
    )
VAR BothRoles =
    INTERSECT(Batters, Bowlers)
RETURN
    COUNTROWS(BothRoles)


Batters Count = CALCULATE(DISTINCTCOUNT(deliveries[batter]))

Bowlers Count = CALCULATE(DISTINCTCOUNT(deliveries[bowler]))


Match totals vs overs comparison

Strike rate evolution over years

StrikeRate = 
DIVIDE([TotalBatsmanRuns], [BallsFaced], 0) * 100


Bowling economy trends

EconomyRate = 
DIVIDE([RunsConceded], [OversBowled], 0)

Season-level KPI dashboard