Power BI reports using your IPL auction dataset

Power BI Research Questions for IPL Auction Dataset

Below is a step-by-step guide for generating Power BI reports using your IPL auction dataset with columns: Open Dataset

• Players
• Nationality
• Type (Batsman, Bowler, All-rounder, etc.)
• Price Paid
• Team

---

 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.