Earthquake Analysis using Power BI

Overview

This project aims to perform an in-depth analysis of earthquake data recorded worldwide from 1990 to 2023 using Power BI. The analysis covers various aspects of seismic events, including their frequency, geographical distribution, magnitude, depth, and other relevant factors.

Dataset Information

• Dataset Link: Earthquakes Dataset (1990-2023)
• Dataset Size: 1,048,576 rows and 12 columns
• Number of Columns: 12
• Number of Rows: 1,048,576

Columns Description

Column Name	Description
time	Time of the earthquake in milliseconds
place	Location of the earthquake
status	Status of the earthquake record
tsunami	Boolean value indicating tsunami occurrence
significance	Significance of the earthquake
data_type	Type of magnitude measurement
magnitudo	Magnitude of the earthquake
state	State or region affected
longitude	Longitude of the earthquake epicenter
latitude	Latitude of the earthquake epicenter
depth	Depth of the earthquake epicenter
date	Date of the earthquake

About the Dataset

The Earthquakes Dataset (1990-2023) is a comprehensive collection of data containing detailed information on earthquake events globally. It includes:

• Date and Time: Details of when the earthquake occurred.
• Location: Geographical coordinates (latitude and longitude) of the earthquake's epicenter.
• Magnitude and Depth: Measurements related to the severity and depth of the earthquake.
• Region: Affected region or state.
• Tsunami Indicator: Indicates whether a tsunami was triggered by the earthquake.

Importance and Utility

This dataset is highly valuable for:

1. Earthquake Analysis and Prediction: By analyzing historical earthquake data, scientists can identify patterns and predict future seismic events more accurately.
2. Safety and Prevention: Insights gained from the dataset can help in designing earthquake-resistant structures, enhancing public safety, and implementing effective preventive measures.
3. Seismological Research: It provides a rich resource for seismologists studying tectonic movements and geological faults, offering deeper insights into Earth's crust dynamics.
4. Public Awareness: Accessible earthquake data can inform individuals about seismic activity in their area, promoting awareness and preparedness.

Project Analysis

Using Power BI, this project analyzes various aspects of the dataset, including:

• Magnitude Analysis: Identifying trends in earthquake magnitudes over time.
• Geographical Distribution: Visualizing the locations of earthquakes globally on an interactive map.
• Depth Analysis: Studying the relationship between earthquake depth and magnitude.
• Tsunami Impact: Evaluating the occurrences of tsunamis triggered by earthquakes.

Project Members

Name	Roll Number
Ragav R	22ADR083
Priyanka B	22ADR082
Vishal R S	22ADR121

Mentor

• K. Logeswaran, Assistant Professor

Tools and Technologies

• Power BI: For data visualization and analysis
• Kaggle: For dataset sourcing
• GitHub: For version control and project collaboration

How to Use

1. Clone the Repository:

   git clone https://github.com/username/PowerBI-Earthquake-Analysis.git