Explore time series forecasting techniques in this comprehensive conference talk from PASS Data Community Summit. Learn how to leverage SQL Server Analysis Services' Microsoft Time Series algorithm for accurate predictions based on historical data. Discover the process of preparing data, creating and querying time series data mining models, and interpreting results. Gain insights into various demonstration models using Visual Studio and Excel data mining add-ins for self-service scenarios. Delve into topics such as the history of forecasting, data mining processes, ARIMA algorithm, model definition, data characteristics, querying techniques, prediction accuracy, algorithm parameters, and real-world business applications. Equip yourself with valuable skills to predict future trends and make data-driven decisions in various fields, including stock market analysis.
Overview
Syllabus
Intro
Presenter Introduction
Session Outline
The History of Forecasting
Describing the Data Mining Process
SQL Server 2014 Analysis Services
Microsoft Time Series Algorithm ARIMA Algorithm
Time Series Model Definition
Time Series Data
Characteristics of Time Series Models
Time Series Model Querying
Determining Prediction Accuracy (Continued)
Algorithm Parameters
Business Scenarios
Summary
Taught by
PASS Data Community Summit
