Past to Future - Self-service Forecasting with Microsoft BI

Explore time series forecasting techniques and tools in Microsoft's Self-Service BI ecosystem. Learn the fundamentals of time series forecasting, discover capabilities in Excel 2007-2013 with SQL Server Data Mining Add-ins, and delve into Self-service Predictive Analytics (SSPA) in Power View for Office 365. Gain insights into producing visually impressive forecasts and hindcasts, understanding seasonality, and utilizing various forecasting tools. Cover topics such as the history of forecasting, Table Analysis Tools, Data Mining Tools, querying results, and the intricacies of self-service forecasting. Discover how to factor in adjusters, group data from months to quarters, and use multiple regression tools. This comprehensive session, presented by Peter Myers, equips information workers and analysts with the knowledge to leverage Microsoft BI for accurate sales predictions and data-driven decision-making.

Introduction
Agenda
History of forecasting
Time series forecasting
Seasonality
Audience
Forecasting Table Analysis Tools
Data Mining Tools
Querying Results
SelfService Forecasting
Details of how it works
Resources
Paul the Octopus
Questions
Multiple regression tools
Group data from months to quarters
Factoring in adjusters