In this video, Billy Decker of StatSlice Systems shows you how to start data mining in 5 minutes with the Microsoft Excel data mining add-in*. In this example, we will create a forecasting model that will predict the trend of bikes sales in different regions.
For the example, we will be using a tutorial spreadsheet that can be found on Codeplex at:
https://dataminingaddins.codeplex.com/releases/view/87029
*This tutorial assumes that you have already installed the data mining add-in for Excel and configured the add-in to be pointed at an instance of SQL Server to which you have access rights.
Video Rating: / 5
Video Rating: / 5
I have one doubt…
any possible to add varchar and char column in time series algoritham
The Analysis Tool Pack is only available in the professional version of MS Office/Excel. These sophisticated tool are not available in the Home Edition.
For this exercise I wanted to exclude any variable with a P > .15