This is a project to help control and monitore the fires in portugal.
- SqlServer download
- SSMS download
- Visual Studio 2019 download
- SSIS extension on Visual Studio 2019
- Power BI download
- 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
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!