{"id":129,"date":"2025-10-10T10:12:04","date_gmt":"2025-10-10T10:12:04","guid":{"rendered":"https:\/\/olgamironczuk.pl\/?p=129"},"modified":"2026-06-29T14:51:16","modified_gmt":"2026-06-29T13:51:16","slug":"projekt-wolontariacki-incydenty-z-rekinami-2000-2024","status":"publish","type":"post","link":"https:\/\/olgamironczuk.pl\/en\/projekt-wolontariacki-incydenty-z-rekinami-2000-2024\/","title":{"rendered":"Volunteer project: shark incidents \u2022 2000-2024"},"content":{"rendered":"
\n
\n
\"\"<\/figure>\n<\/div><\/div>\n\n\n\n
\n

Project: <\/strong>Shark incidents \u2022 2000-2024
Tools: <\/strong>Tableau, MySQL (ETL), DBeaver
Description: <\/strong>Independent, pro bono analysis based on the Global Shark Attack File (GSAF) \u2013 from importing and cleaning data (ETL in MySQL) to building an interactive dashboard in Tableau.
Objective:<\/strong> Education and context, not fear \u2013 emphasizing seasonality, human activity and geography (with clear definitions: fatal vs non-fatal and unprovoked).
Data: <\/strong>Global Shark Attack File (GSAF) \u2022 snapshot 2025-09-24 \u2022 incidents 2000-2024.
Repository:<\/strong> \"GitHub\" See on GitHub <\/a>

\"List_referencyjny_GSAF\" View the reference letter from GSAF<\/a><\/strong><\/p>\n<\/div>\n<\/div>\n\n\n\n\n\n\n\n

\n\n\n\n

Introduction<\/h2>\n\n\n\n

Sharks have always sparked strong emotions \u2014 and data helps turn those emotions into understanding. This project was created as part of my volunteer collaboration with the Global Shark Attack File (GSAF). My goal was to tell this story in a calm and responsible way \u2014 showing that most incidents do not result in death, and that risk depends mainly on the time of year, the type of activity, and the location, rather than on \u201cdangerous species.\u201d<\/p>\n\n\n\n

This was not only a data analysis project, but also a process of improving data quality and practicing ethical data visualization. The dashboard was designed to be clear, minimalist, and free from sensationalism.<\/p>\n\n\n\n

Data<\/h2>\n\n\n\n
    \n
  • Source:<\/strong> Global Shark Attack File (GSAF)<\/li>\n\n\n\n
  • Time range:<\/strong>akres lat:<\/strong> 2000-2024 (snapshot)<\/li>\n\n\n\n
  • Po<\/strong>Fields included in the dataset:<\/strong> incident date and location, human activity, shark species (if known), outcome (fatal \/ non-fatal), type (provoked \/ unprovoked), season, and country.<\/li>\n\n\n\n
  • Note<\/strong>:<\/strong> The dataset contains historical records that may vary in level of detail or accuracy depending on how and where incidents were reported. The goal of this project was clarity and structure, not sensationalism.<\/li>\n<\/ul>\n\n\n\n

    Process<\/h2>\n\n\n\n

    1) Data preparation (MySQL)<\/strong><\/p>\n\n\n\n

      \n
    • Importing the source file and creating backups.<\/li>\n\n\n\n
    • Removing duplicates and empty rows, and standardizing text case and formats.<\/li>\n\n\n\n
    • Parsing dates<\/strong> from different formats (YYYY-MMM-DD, DD-MMM-YY, MMM-YYYY); when the day of the month was missing, a default value of 15 was used.<\/li>\n\n\n\n
    • Standardizing country and state names<\/strong> (ISO codes, aliases) and cleaning inconsistent location names.<\/li>\n\n\n\n
    • Creating derived fields such as IsFatal<\/strong>, IsProvoked<\/strong>, ActivityCategory <\/strong>, and SpeciesCategory<\/strong>.<\/li>\n\n\n\n
    • Performing data quality checks to ensure logical ranges and consistent record counts.<\/li>\n<\/ul>\n\n\n\n

      2) Visualization (Tableau)<\/strong><\/p>\n\n\n\n

        \n
      • KPI: total number of incidents, non-fatal incidents<\/strong>, unprovoked incidents <\/strong>and the country with the highest number of cases<\/strong>.<\/li>\n\n\n\n
      • Trend chart for 2000\u20132024 (fatal vs non-fatal vs unknown).<\/li>\n\n\n\n
      • Share of different activities (e.g., board sports, swimming, fishing).<\/li>\n\n\n\n
      • Seasonality by month<\/strong>, with filters for country, activity, and incident type.<\/li>\n\n\n\n
      • Tooltips including definitions and methodology notes.<\/li>\n\n\n\n
      • The color palette and layout are focused on clarity and balance \u2014 without dramatization.<\/li>\n<\/ul>\n\n\n\n

        Technologies and tools:<\/strong> MySQL, DBeaver, Tableau, SQL\/ETL, methodology documentation.<\/p>\n\n\n\n

        Results<\/h2>\n\n\n\n
          \n
        • Most incidents do not result in death.<\/strong><\/li>\n\n\n\n
        • Seasonality:<\/strong> more incidents occur in summer and in areas with high levels of water activity.<\/li>\n\n\n\n
        • Activity matters: <\/strong>board sports, swimming, and fishing are the most frequently reported activities.<\/li>\n\n\n\n
        • The fatality<\/strong>rate did not increase<\/strong> between 2000 and 2024.<\/li>\n\n\n\n
        • The interactive dashboard makes it easy to explore trends over time, by activity, and by geography.<\/li>\n<\/ul>\n\n\n\n

          Reflections<\/h2>\n\n\n\n
            \n
          • Data quality first: <\/strong>The most time-consuming part was standardizing locations. Many reports contained descriptive place names (beaches, bays, reefs, regions) that Tableau couldn\u2019t automatically recognize. I applied regex-based rules<\/strong> (spelling normalization, removing abbreviations\/special characters, and standardizing the format) to harmonize country, state, and location names, which allowed the map to display correctly.<\/li>\n\n\n\n
          • Clear definitions prevent misinterpretation:<\/strong> Distinguishing between provoked and unprovoked incidents, as well as fatal and non-fatal cases, is essential for responsible analysis.<\/li>\n\n\n\n
          • E<\/strong>Ethical visualization: <\/strong>Muted colors, clear labels, and avoiding rankings of the \u201cmost dangerous sharks\u201d ensure the message remains informative rather than alarmist.<\/li>\n\n\n\n
          • Acknowledging limitations:<\/strong> Results depend on how incidents are reported in different regions \u2014 the numbers should always be interpreted in the appropriate context.<\/li>\n<\/ul>\n\n\n\n
            <\/div>\n\n\n\n