Deploying and Performing Business Intelligence with MS SQL Server using AWS Cloud

This project takes into essence, the importance and benefits of deploying Business Intelligence (BI) on Cloud. Cloud computing is the availability of computer system resources through data storage and computing power accessible via the internet.

Performing and deploying BI using SQL Server 2012 on Amazon Web Service (AWS), I created AWS EC2 instance with Windows Server 2012 R2 Operating System. BI on MS platform will be conducted using different tools such as SQL Server Integration Service (SSIS), SQL Server Analysis Service (SSAS) and SQL Server Reporting Service (SSRS) to perform Data Integration, Data Analysis and Reporting Services. In conclusion I applied Data Mining predictive model such as Decision Tree, Naïve Bayes, Clustering and Neural Network to my case study – Fatality Reporting Systems, which I downloaded from National Highway Traffic Administration (NHTSA) to predict what factor influence the rate of fatality on our roads in the United States. This dataset only considers 2018 records of accident.