Forecasting TBATS

Time-series forecasting for series that exhibit multiple seasonalities using the TBATS model.

Imagine that your data is influenced by two seasonality factors. For example, an ice-cream seller expects a certain seasonality pattern that fluctuates daily, and weekly.

The TBATS model is a time-series model for series that exhibit multiple seasonalities.

You can control the visual attributes of the TBATS model to suit your needs.

Here’s how it works:

  • Define the required “Date” field (of type “date” or “date/time”)
  • Define the required “Value” field (numeric)
  • Select the required seasonalities in “Forecasting settings”
  • Use numerous formatting controls to refine the visual appearance of the plot

R package dependencies (which are auto-installed): zoo, scales, reshape2, ggplot2, plotly, forecast, lubridate, htmlwidgets, XML

Supports R versions: R 3.4.0, R 3.3.3, R 3.3.2, MRO 3.2.2

Warning: the optimization procedure for TBATS can be time consuming. It’s recommended only when your data exhibits multiple seasonalities.

NEW: support for tooltips on hover and selection.

This is an open source visual. Get the code from GitHub:

https://github.com/Microsoft/PowerBI-visuals-forcasting-tbats

The full version of this visual (supported in Power BI Desktop only) is available from the following location:

https://github.com/Microsoft/PowerBI-visuals-forcasting-tbats/tree/full

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