Table of contents
Project Overview
Context
As part of this project, we were contacted by the DSI organization to analyze earthquakes over a one-month period in 2022. This client is looking to expand operations and is looking for areas to consider expansion into. Building costs and maintenance can be higher in those areas where earthquakes are prevalent. Our client asked for us to provide the following analysis: geographical analysis containing the location of the earthquake, the ten largest earthquakes by location, the percentage of earthquakes that occurred based on the broad location of the earthquake, frequency by location, average magnitude by location, and maximum magnitude by location.
Requirements
For this deliverable, we provided a Tableau dashboard with visuals representing the key requirements. Those requirements were:
- Provide geographical analysis of all earthquakes
- Provide analysis on the top 10 largest earthquakes
- Provide analysis on the percentage of earthquakes based on the broad location identified
- Provide analysis for the frequency based on location
- Provide analysis for the average magnitude based on location
- Provide analysis for the maximum magnitude based on location
Results & Discussion
Based on our observations, we can provide the following insights into the frequency of earthquakes based on broad geographical location:
- North America(Highest): 58% rate of earthquakes
- Central America(Lowest): 3% rate of earthquakes
We can provide the following insights for maximum magnitude of earthquakes based on geographical location:
- Vanuatu(Highest): 88 magnitude based on 2 events
- Michigan(Lowest): 8 magnitude based on 1 event
We can provide the following insights for the 10 largest earthquakes based on geographical location:
- Vanuatu experienced the top 2 largest earthquakes based on 2 events during this time period
- Tonga experienced the 3rd and 4th largest earthquakes based on 4 events
Data Overview & Preparation
The client provided us with the necessary file and minimal manipulation was needed. There was some data cleansing that was required which included a clean up of inconsistent formatting of column values.