201|POWERBI – Shark Attack

BYU Student Author: @Jacob_Dutton
Reviewers: @Jimmy_Han, @Dallin_Gardner
Estimated Time to Solve: 20 Minutes

We provide the solution to this challenge using:

  • Power BI

Need a program? Click here.

Overview
Congratulations! You have been hired as a data analyst, you have an intriguing challenge ahead. You need to analyze shark attacks along Southern California beaches and their rescue response times. Your tasks are to:

  • Calculate the average time taken for rescue operations at different beaches.
  • Calculate the number of shark attacks at each beach.
  • Effectively visualize your findings for easy comprehension.

Instructions
Leverage your Power BI skills to compute and graphically represent key metrics related to shark attacks. Your objective is to create a clear, informative report that illuminates the patterns of shark attacks and the efficiency of rescue operations at various beaches. Your visualizations should facilitate straightforward interpretation and assist in decision-making for enhancing safety and response strategies.Your final report should be succinct, fitting on a single page, and must include:

  • Average Rescue Time and Count of Shark Attacks by Beach (Attack Data):
    • Create a DAX measure to calculate the average rescue time for each beach.
    • Create a DAX measure to count the number of shark attacks per beach.
    • Design a scatter chart with “BeachName” in the values field, “Average Rescue Time” on the X-axis, and “Count of Shark Attacks” in the Y-axis.
  • Data Table (Beach Details):
    • Add a data table providing additional information about each beach.
    • Include columns like “BeachName”, “Location”, “WaterClarity”, “SharkNetPresence”, and a column using your shark attack count measure.
    • This table will offer a comprehensive view of each beach, coupled with the shark attack data.
    • If a user clicks on a dot from the scatter chart, the data table will automatically filter to show that beach’s info.

Data Files

Suggestions and Hints

After uploading both CSV’s into PowerBI, make sure that there is a 1 to many relationship between them. PowerBI usually detects this automatically, but if not, create one manually.

Solution