This demo filled session will step through some predictive modeling functionality built into SQL Server Analysis Services (SSAS). We will start by review the data modeling and data cleansing needed before any predictive model design and implementation. SQL Server provides this with Integration Services, T-SQL and Data Quality Services.

After the data is formatted adequately for predictive modeling, we can start modeling and finding the best fit for examining forecasts and what if scenarios. SSAS provides models for clustering, neural networks, logistic and linear regression, decision tress and Naïve Bayes classifiers. We will not have time for all models, but be stepping through 2 or 3, you will leave with your brain firing on all cylinders about predicting data for your company or consulting firm.