Portugal Fires - Decision support systems

This is a project to help control and monitore the fires in portugal.

Requirements:

• SqlServer download
• SSMS download
• Visual Studio 2019 download
• SSIS extension on Visual Studio 2019
• Power BI download

Explanation of files/folders:

• DataSets - Folder with datasests used in ETL(Extract, transform, load) process
• pdf file - File with data analysis of datasets
• sql - File to create the database
• ETL process - The ETL process to insert the datasets data in database
• Dashboard - The dashboard to see the data

How to use

1 - First open the SSMS and execute the sql file to create the database

2 - Open The ETL with Visual Studio 2019 and execute to load the data in database

3 - Open the Power BI with dashboard file and explore it!