Overview This blog post explores the insights derived from a comprehensive Tableau dashboard created using the US Coast Guard’s Boating Accident Report Database (BARD) data. The BARD dataset, spanning from 2009 to 2023, offers an in-depth look into national recreational boating accidents. This post will guide you through the key findings, explore the dashboard components, and provide context on how data was utilized to generate insights on boating accident.
Task at Hand The primary objective of this task was to analyze the BARD data to uncover significant trends and visual insights regarding boating accidents. The dataset included multiple tables with details about accidents, vessels involved, injuries, and deaths. This project required synthesizing information into a clear and accessible Tableau dashboard.
Data Preparation for Boating Accident Insights Data preparation is a critical step in transforming raw data into a clean and usable format for analysis. Here’s an overview of how the BARD data was structured and prepared for the Tableau dashboard:
Data Sources The dataset consisted of several CSV files:
- Accidents.csv: This file contained the core data of boating accidents, including details like date, location, cause, number of deaths, injuries, and total damage.
- Deaths.csv: Included specific information about the fatalities resulting from each accident, such as demographic details of the deceased and cause of death.
- Injuries.csv: Detailed the injuries sustained in each incident, covering demographics and the severity of the injuries.
- Vessels.csv: Focused on the characteristics of vessels involved in accidents, including operator information, vessel type, and the conditions during the incident.
The image illustrates the relationship between these datasets, with accidents.csv serving as the primary dataset linked to the other files through unique identifiers BARDID
Data Integration The core of the analysis required merging datasets:
- Accidents data was connected to the Deaths and Injuries data using the
BARDID(the unique identifier for each accident). - The Vessels dataset also linked to accidents via the same
BARDID, allowing the study of vessel-specific information like operator education and vessel type in relation to accident outcomes.
Boating Accident Insights Dashboard
- Overview of Accidents
- Displays the total accidents (58,430), deaths (8,935), injuries (36,773), and the total damage cost ($661.02M), highlighting the overall impact of boating incidents.
- Accident Trends Over Time
- A line graph showing fluctuations in yearly accident numbers, with a noticeable peak around 2020, potentially due to increased recreational boating during the pandemic.
- Geographical Distribution
- A map visualization indicating accident hotspots across the United States. Florida, in particular, has a high concentration of incidents due to its coastal activities.
- Top Causes and Manufacturers
- Operator Inattention is the leading cause of accidents, followed by improper lookout and operator inexperience.
- Yamaha boats have the highest involvement in accidents, indicating potential safety concerns or their popularity among boaters.
- Operator Characteristics
- A breakdown of accidents based on operator education shows that those without formal education are most frequently involved in incidents.
- Accidents are also segmented by operator age, with the highest occurrence in the 20-50 age group, suggesting a target demographic for safety campaigns.
For a deeper, interactive exploration of these insights, visit the full Boating Accident Insights Dashboard on Tableau Public https://public.tableau.com/app/profile/uzair.khan5588/viz/BoatingAccidentInsights/BoatingAccidentInsights
