Power BI reports based on your World Crime Index dataset

Below is a detailed step-by-step guide on how to generate Power BI reports based on your World Crime Index dataset. Open Dataset

---

Question 1: Which countries have the highest and lowest crime index?

Steps:

1. Load Data:

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

2. Transform Data (if needed):

   • Click on Transform Data → Ensure columns are properly formatted.

3. Create a Bar Chart:

   • Go to Report View → Click Bar Chart from Visualizations.
   • Drag Country to the X-axis.
   • Drag Crime Index to the Y-axis.
   • Sort in descending order.

4. Customize the Chart:

   • Change Data Labels → Turn it ON.
   • Change Title to "Top & Bottom Countries by Crime Index".

---

Question 2: What is the global trend of the crime index?

Steps:

1. Insert a Line Chart:

   • Click on Line Chart in Visualizations.
   • Drag City to the X-axis.
   • Drag Crime Index to the Y-axis.

2. Format the Chart:

   • Sort the data to see trends clearly.
   • Add Data Labels for better visibility.

---

Question 3: Which city has the highest and lowest safety index?

Steps:

1. Create a Table or Bar Chart:

   • Drag City into the table visual.
   • Drag Safety Index next to it.

2. Sort the Table:

   • Click on Safety Index → Sort from highest to lowest.

3. Highlight the lowest safety city:

   • Use Conditional Formatting → Set lowest values in red.

---

Question 4: Is there a correlation between Crime Index and Safety Index?

Steps:

1. Insert a Scatter Chart:

   • Drag Crime Index to the X-axis.
   • Drag Safety Index to the Y-axis.
   • Drag City to the Detail section.

2. Analyze the Trend:

   • Check if there is an inverse relationship (higher crime → lower safety).

---

Question 5: Which regions have the most dangerous cities?

Steps:

1. Insert a Map Visual:

   • Click on Map in Visualizations.
   • Drag City to Location.
   • Drag Crime Index to Size.

2. Customize the Map:

   • Use different color schemes for crime index severity.
   • Adjust zoom levels for better clarity.

---

Question 6: How does crime index vary by rank?

Steps:

1. Create a Bar Chart:

   • Drag Rank to the X-axis.
   • Drag Crime Index to the Y-axis.

2. Sort in Ascending Order:

   • Click on Rank → Sort.

---

Question 7: Which country has the most cities in the top 10 highest crime index?

Steps:

1. Filter Top 10 Cities:

   • Click on Filters Pane → Add Crime Index → Select Top 10.

2. Create a Column Chart:

   • Drag Country to the X-axis.
   • Drag City Count (or individual cities) to the Y-axis.

---

Question 8: What is the safety perception in major cities?

Steps:

1. Filter for Major Cities:

   • Use Filters Pane to select cities like New York, London, Tokyo, etc..

2. Create a Comparison Bar Chart:

   • Drag City to the X-axis.
   • Drag Safety Index to the Y-axis.

---

Question 9: Which cities have unexpected crime/safety index ratios?

Steps:

1. Insert a Box Plot:

   • Drag City to the Category.
   • Drag Crime Index and Safety Index to Values.

2. Identify Outliers:

   • Look for extreme variations.

---

Question 10: How does crime index differ between developed and developing nations?

Steps:

1. Add a Column for Development Status:

   • Click on Transform Data → Add a Custom Column
   • Define rules (e.g., USA, UK = "Developed", India, Brazil = "Developing").

2. Create a Pie Chart:

   • Drag Development Status to Values.
   • Drag Crime Index as Measure.

---

🔹 Final Tips for Power BI Dashboard

• Use Slicers for interactive filtering (e.g., by country, rank).
• Add Titles & Legends for clarity.
• Use Drill-through for detailed insights on a specific city or country.