Forecasting the future: Now in Power BI

The September 2016 release of Power BI desktop marks a preview of the forecasting feature. In this post, you’ll see how you can enable it and use it. Also I’ll share some perspective on how to use forecasting to make better business decisions. Let’s start with a video showing how to use the new forecasting feature.


This Harvard Business Review article How to choose the right forecasting technique (may require registration) offers a really nice summary of techniques you can apply and the best options for using them.  Simply put, it’s not that easy to get it right. Seems like everyone, the Small Business Administration, Investopedia, Inc, iSixSigmaBusiness Insider, and surprisingly even WikiHow have solid content offering insight into the art and science of building business forecasts. Of course some formal education on the topic might be of interest before you stake you business on the resulting forecast.

While a built-in UX feature is great for forecasting, sometimes you want more control. To that end, Power BI supports R, where you can do customized forecasting using a number of different techniques. The forecast package can be obtained from CRAN. The Power BI R Script Showcase contains a forecast example to help you get started. While R is more technical and requires a bigger investment of your time to learn, you might find that using R to really understand the principles of forecasting will enable you to make better forecasts and crucially understand the limitations of what a forecast can and cannot tell you.

Last but not least, now that you can pin tiles from Excel files to your Power BI dashboards, you might also want to explore Excel 2016’s built-in forecasting options that are backed by Excel functions (Forecast.ETS, Forecast.ETS.SEASONALITY, Forecast.LINEAR, Forecast.ETS.CONFINT, Forecast.ETS.STAT). Again, you get some UI to help you get started (it might be more approachable than R) and you get some functions that help you understand the details of the forecast.

Power BI’s forecasting feature is starting it’s preview. Give it a try, but as with any forecast double check your assumptions before you proceed.

  • Data Made Good

ArcGIS Maps for Power BI (preview)

Let’s take a look at some of the amazing features of the new ArcGIS Maps for Power BI visual that’s available with the September release of Power BI Desktop. As you know, Power BI Desktop is a free visual analytics tools provided by Microsoft. The new ArcGIS Maps for Power BI feature is also available at no cost. So what are you waiting for  ;).

You’ve probably read my blog post about the visual already, seen the product page, read some reviews as well. Now, I wanted to go into some more depth and give some insights into how I imagine users will leverage the capabilities. Let’s start with a video that gives a quick summary of feature set and shows some examples.

In the example above, I used Seattle Building Permits data that I loaded from The reference layer was found just by searching for Seattle in the ArcGIS search box. The City of Seattle already had published some layers that I was able to discover and use in about a minute.

David Eldersveld put together a nice tutorial showing how to publish your own public reference layer. The steps are easy: you sign up for ArcGIS Online, make your layer, then set the permissions to make it public. Once done, you can search for your layer in the ArcGIS tab under Reference Layer in the ArcGIS Maps for Power BI visual.

Overall the ArcGIS Maps for Power BI visual is just starting out. I know there are more features coming, as well as refinements that will make it even better.

  • Data Made Good