Introduction to Geographical Time Series Prediction with Crime Data in R, SQL, and Tableau

When reviewing geographical data, it can be difficult to prepare the data for an analysis. This article helps by covering importing data into a SQL Server database; cleansing and grouping data into a map grid; adding time data points to the set of grid data and filling in the gaps where no crimes occurred; importing the data into R; running XGBoost model to determine where crimes will occur on a specific day

Check out the full article at KDNuggets.com website
Introduction to Geographical Time Series Prediction with Crime Data in R, SQL, and Tableau