| Industry focus | - Geology | |
| Description | - The project consists of an interactive dashboard that is simple to use and easy to understand, guiding the user to locate any volcano by country, showing its name, its location on a global map and giving us its tectonic configurations. | |
| Objective | - The objective is to create an interactive board with information about the active volcanoes in the world by country, showing their location on a map, characteristics of the technical plate and last recorded eruption. | |
| Tools used | - MySQL - Microsoft Power BI | |
| Deliverables | - An informational dashboard describing your findings and recommendations | |
| Dataset list | - The data was extracted from Kaggel https://www.kaggle.com/datasets/jessemostipak/volcano-eruptions/versions/1 | |
| Important indicators | - Name of the Volcano - Country - Configuration of the Tectonic Plate - Number of Volcanoes |
Data was taken from Kaggel profiles with data available for use, in csv files, Power Bi and Power Query were used for data cleaning
Uncleaned Data:
Clean Data:
Last Eruptions Query using CASE:
If you want to see all the SQL Queries, click **[HERE](https://github.com/antomagu/ActiveVolcanoes/blob/main/Queries.sql)**:
Dashboard
You can see the final dashboard clicking **[HERE](https://app.powerbi.com/groups/me/reports/d83d4bc9-b4ad-4408-96c9-8f61b6418f02?ctid=48fe72ba-f2bf-4b24-a90b-0f8762e3215a&pbi_source=linkShare
)**