Today at the PASS Business Analytics conference we announced the availability of new forecasting capabilities for Power View in Office 365. In Power View, you can now apply predictive forecasting, and hindcasting, when visualizing and exploring your data. Forecasting in Power View utilizes built-in predictive forecasting models using exponential smoothing to automatically detect seasonality in the data to provide forecast results from a series of data. Explore forecast results by adjusting the desired confidence interval or by adjusting outlier data to see how they affect results. You can also hindcast to see how Power View would have predicted the present and recent past based on older data.
The best data for forecasting is time series data or uniformly increasing whole numbers. The line chart has to have only one line. Multiple-line charts won’t work, even if all but one line is filtered out. See more things to keep in mind about forecasting.
You can evaluate how accurate a prediction is by combining these techniques:
The forecasting in Power View performs advanced statistical analysis of your data to generate forecasts that incorporate trends and seasonal factors. Learn more about these methods and how to customize your forecasts to get the best results.
Try the new forecasting capabilities of Power View today on your own data or with the sample report available as part of the Power BI report samples. To view your own data, upload a workbook with a Power View time series line chart to Power BI for Office 365.
Open the file in Power BI and switch to Power View in HTML 5 (choose Try the HTML5 version of Power View in the lower-right corner).
Then click the forecast arrow or drag the forecast dot in the line chart, and you’ll see the forecasting options appear in the Analysis pane to the right of your report, as seen in the following image.
Hindcasting shows how the forecast would've predicted the recent past, from the vantage point of the past.
To undo forecasting, click the arrow to the left of the forecast dot
The following capabilities are available to help you adjust your forecast:
Power View automatically detects what appears to be the seasonality of the data – in other words, a complete cycle of peaks and dips. For example, if you have high summer sales and low winter sales year over year, and you have daily data points, then the seasonality may be 365 - 365 data points in the one-year data cycle. You can override automatic seasonality detection.
Tip : Seasonality works best if the chart has at least four times more values than the data cycle. For example, if you set the seasonality to 52, you’d want to have at least 4 times 52, or 208, values in the time series axis of your chart.
The confidence interval shows visually how reliable the forecast is. Standard deviation is the setting for the confidence interval of forecast results.
Line chart with one standard deviation.
When you change data points in a line chart, the forecast changes based on the new values. You’re not changing the underlying data in the workbook or data source.
Note : What-if analysis currently works only in Power View HTML5 with forecasting, and not in the Power BI app.
Drag the dot up or down.
The line chart after dragging the dot down.
To undo the change, double-click the data point dot.
Forecast is available for line charts only.
Sometimes data has gaps in it—maybe a value is missing in a row, or maybe a whole row is missing. Power View fills in missing values before forecasting. Power View can add new values up to 100% of the existing values, so up to half the values in the line chart could be invented. If the chart has more missing values than that, Power View can’t forecast.
A line chart contains all the values in the fields on the x and y axes. To limit those values, filter the line chart or filter the whole sheet. More about filtering in Power View. But filtering historical data may reduce the forecast quality.
Filtering may also result in a chart with more than 50% of the values completed by Power View. If so, Power View can no longer create a forecast for that line chart.
You can print the HTML5 version of Power View sheets, but the prediction and analysis doesn't print.
Undo (Ctrl-Z) doesn't work. See Remove predictions for undo tips.
If you want to try the new forecasting capabilities right away, you can interact with the following report right here:
Forcast .. WoW, WoW, WoW.
Embedded Intaractive Forcast Power Pivot .. WoW
Will this be available ONLY for Office 365? What about the regular office?
Looks like you guys have done a very good job of folding in the existing Data Mining options and made them more accessible at the same time. Not impossible to replicate in on-premises, but sure isn't going to be easy.
Your product looks like it is packed with lot of capabilities. However, I cannot seem to find any support on this product. I called Microsoft and was on the call for 40 minutes being transferred from one department to the next. Do you have somebody who can help me determine requirements to use this product?
Our team was at PASS and can't wait to get into PowerBI. As a current non-profit E3 customer we've found we can't currently purchase or test powerBI. When will PowerBI be available to non-profit customers?
When oh when will Power BI ever be available in Australia?
Thanks for your feedback. You are welcomed to ask related questions and post comments on the PowerView TechNet forum: social.technet.microsoft.com/.../home
This is incredible! Cannot wait to have a go on it!
When will it be available in Australia???
Is this feature available in excel 2013 powerview as well?
Has this functionality now disapeared? Can't seem to find it anymore - has been quite embarrasing when demoing. Can anyone help?
Hi there, I was also trying to see the forecasting for an upcoming demo, and now I cannot see it any more.
If someone can please advise.
Will this be enabled again for Power BI or Power View?
Comments in this blog are open and monitored for each post for a period of one week after the posting date. If you have a specific question about a blog post that is older than one week, please submit your question via our Twitter handle @MSPowerBI