Power BI Reports using IPL Auction Dataset

Power BI Research Questions for IPL Auction Dataset

Open Dataset

Problem Statement

The Indian Premier League (IPL) franchises often face the challenge of building a balanced team while staying within their budget constraints. Teams must evaluate players based on their roles (Batsman, Bowler, All-Rounder, Wicket Keeper), nationality (Indian vs Overseas), and price paid during the auction to optimize performance.

This dataset provides details of a few players purchased by Chennai Super Kings (CSK), including their name, nationality, type, price, and team. The key problem is to analyze how the composition of players affects the team structure and to explore insights such as:

• Distribution of Indian vs Overseas players.

• Balance of roles (Batsman, All-Rounder, Wicket Keeper, etc.).

• Price allocation strategy across player categories.

• Identifying potential areas of overspending or underspending.

---

 Question 1: Which team spent the most money in the auction?

Steps:

1. Load Data:

   • Open Power BI → Click Home → Get Data → Excel or CSV
   • Select your dataset and click Load.

2. Create a Bar Chart:

   • Drag Team to the X-axis.
   • Drag Price Paid to the Y-axis.
   • Sort in descending order.

3. Customize the Chart:

   • Change Data Labels → Turn it ON.
   • Change Title to "Total Spending by Teams".

---

Question 2: Who is the most expensive player in the auction?

Steps:

1. Create a Table:

   • Drag Players and Price Paid into the Table visual.

2. Sort the Table:

   • Click on Price Paid → Sort Descending.

3. Highlight the highest price:

   • Use Conditional Formatting → Set highest value in green.

---

 Question 3: What is the distribution of players by nationality?

Steps:

1. Insert a Pie Chart:

   • Drag Nationality to Values.
   • Drag Players to the Legend.

2. Customize the Pie Chart:

   • Show Percentage Labels.

---

 Question 4: Which type of players were most in demand?

Steps:

1. Create a Bar Chart:

   • Drag Type (Batsman, Bowler, All-rounder) to the X-axis.
   • Drag Price Paid to the Y-axis.

2. Sort the Chart:

   • Sort by Total Price Paid in descending order.

---

 Question 5: What is the average price paid per player for each team?

Steps:

1. Insert a Matrix Table:

   • Drag Team into Rows.
   • Drag Price Paid into Values.
   • Click on Price Paid → Select Average.

2. Format the Table:

   • Apply Currency Formatting to Price Paid.

---

Question 6: Which team bought the most number of players?

Steps:

1. Create a Bar Chart:

   • Drag Team to X-axis.
   • Drag Players to Y-axis.

2. Sort the Chart:

   • Sort by Total Players Bought in descending order.

---

Question 7: Is there a correlation between player type and price paid?

Steps:

1. Insert a Scatter Plot:

   • Drag Price Paid to X-axis.
   • Drag Type to Y-axis.

2. Analyze the Trend:

   • Check if All-rounders are the most expensive.

---

Question 8: Which team has the most foreign players?

Steps:

1. Filter for Foreign Players:

   • Use Nationality → Exclude "India".

2. Create a Column Chart:

   • Drag Team to the X-axis.
   • Drag Player Count to the Y-axis.

---

Question 9: Which player type has the highest price variation?

Steps:

1. Insert a Box Plot:

   • Drag Type to Categories.
   • Drag Price Paid to Values.

2. Identify Outliers:

   • Look for extreme variations.

---

Question 10: What is the total spending trend across teams?

Steps:

1. Insert a Line Chart:

   • Drag Team to X-axis.
   • Drag Total Price Paid to Y-axis.

2. Check for Spending Patterns.

---

🔹 Final Dashboard Recommendations

• Use Slicers to filter by Team, Type, and Nationality.
• Add Drill-through Pages for player details.
• Use Conditional Formatting to highlight expensive players.