Snowfall-Prediction-using-Machine-Learning

In this research, Machine learning algorithms like Long-Short Term Model (LSTM), Decision tree, Random Forest and XG Boost were used as a classifier to improve the accuracy of Snowfall prediction for the region of Boston. The geographical parameters like Humidity, Temperature, Wind-speed, Precipitation, Sea-level, Dew-point and Visibility were used as independent variables. Before the modeling phase, Data lagging was performed for 2 step followed by Exploratory Data Analysis was using techniques like Multiple Linear Regression, Correlation Plot and variable importance plot. Feature Selection was also executed using Logistic Regression and Boruta algorithm. Experimental evaluations resulted in the highest accuracy shown by LSTM with an accuracy of 89.98%. In terms of sensitivity, Random Forest outperformed other classifier models. Whereas, Decision tree and XG Boost resulted well in the overall performance of prediction with respect to other evaluation metrics. The results of this research added to the contribution of the knowledge in weather prediction in the domain of Snowfall for the machine learning industry.

Data-warehouse-and-Business-Intelligence-project-on-Tuberculosis-WHO-

Implemented Data Warehouse and Business Intelligence project using different structured and unstructured data sources of various Incidents and Mortality rates of Tuberculosis for 197 countries around the world. The aim was to analyze the trends in mortality and incidence rates in countries around the world for tuberculosis. Data was web scrapped, cleansed and loaded using ETL designed star schema and deployed OLAP cube. Non-trivial BI queries were generated. First of all the data was extracted, cleaned and transformed using R language and further injected and loaded into SSMS where dimension tables were created using Insert query task. Kimbell's bottom-up approach was used to design the star schema in SSIS. Finally the cube was deployed in SSAS. Tableau was used for visual analytics to create dashboards. Technologies used: MS SQL, SQL Server Integration Services, SQL Server Analysis Services, Tableau. Video link of execution with explanation is available.