Forecasting with ARIMA

Predict future values based on historical data using Autoregressive Integrated Moving Avg (ARIMA)

Use forecasting today to optimize for tomorrow! Time series forecasting is the use of a model to predict future values based on previously observed values.

It is one of the prime tools of any buisness analyst used to predict demand and inventory, budgeting, sales quotas, marketing campaigns and procurement. Accurate forecasts lead to better decisions. Current visual implements well known Autoregressive Integrated Moving Average (ARIMA) method for the forecasting. ARIMA models are general class of models for forecasting a time series which can be made to be “stationary”. While exponential smoothing models are based on a description of trend and seasonality in the data, ARIMA models aim to describe the autocorrelations in the data. Both seasonal and non-seasonal modeling is supported. You can control the algorithm parameters and the visual attributes to suit your needs.

Highlighted features:

  • NEW: support for tooltips on hover and selection
  • The underlying algorithm requires the input data to be equally spaced time series
  • Seasonal factor can be found automatically or set by user
  • By default, algorithm will optimize for all the parameters of the model based on certain information criteria
  • Advanced user can control all the inner parameters of the model

R package dependencies(auto-installed): proto, zoo

Supports R versions: R 3.3.1, R 3.3.0, MRO 3.3.1, MRO 3.3.0, MRO 3.2.2

This is an open source visual. Get the code from GitHub: https://github.com/Microsoft/powerbi-visuals-forcastingarima

Add-in capabilities

When this add-in is used, it

  • Can read and make changes to your document
  • Can send data over the Internet
Membership

***** Related Blog Posts *****
Creating Multi Threaded Dynamic Visuals – Advanced Power BI Technique
Custom Dynamic Segmentation Using DAX In Power BI

***** Related Video Tutorials *****
Create Dynamic Visuals Based On Ranking in Power BI w/DAX

Outlier Detection & Visualization in Power BI – Advanced DAX
How To Use Virtual Tables With COUNTROWS in Power BI – DAX Formula Technique
RANKX Considerations – Power BI & DAX Formula Concepts
Manufacturing Operations – Power BI Showcase

Center of Excellence

***** Related Course Modules *****
Ultimate Beginners Guide to Power BI
Power BI Super Users Workshop
Solving Analytical Scenarios w/ Power BI & DAX
Advanced Analytics in Power BI
Financial Reporting w/ Power BI
Power BI Showcases

***** Related Support Forum Posts*****
Custom Visual AppStore
Custom Visuals vs Standard Visuals
Power BI – Creativity