cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
mmace1 Post Patron
Post Patron

Power BI Forecasting vs. Excel Forecasting - why different numbers?

Using the same source data, same confidence level, and default settings on both, Excel & Power BI give different numbers. 

 

The forecasts are pretty close (again though, not the same), and additionally Power BI seems to give tighter ranges for the same confidence level. 

 

Is there any overview as to how Excel & Power BI handle forecasting differently? 

2 ACCEPTED SOLUTIONS

Accepted Solutions
Community Support
Community Support

Re: Power BI Forecasting vs. Excel Forecasting - why different numbers?

hi, @mmace1 

You may refer to this blog:

https://powerbi.microsoft.com/en-us/blog/describing-the-forecasting-models-in-power-view/

https://powerbi.microsoft.com/en-us/blog/introducing-new-forecasting-capabilities-in-power-view-for-...

Does Power View use the same forecasting algorithm as in the Data Mining Add-ins for Excel?

No, this is a different tool, and a different (but similar) algorithm.

  • Charting and forecasting in Power View does not require a connection to Analysis Services, and instead runs on data stored in Excel, with processing done “behind the scenes” on the Excel Data Model.
  • Forecasting on Power View charts does not use the ARTXP or ARIMA algorithms provided by SQL Server Analysis Services. Although those algorithms were developed by Microsoft Research in response to common theories and research on time series forecasting, and solve many of the same problems, they are implemented on a different code base and might yield different results.

We recommend that you experiment with various methods of forecasting and compare results. Typically data scientists will try out many models and evaluate their accuracy before accepting a prediction as valid for business application.

 

Best Regards,
Lin

 

Community Support Team _ Lin
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

View solution in original post

Highlighted
Community Support
Community Support

Re: Power BI Forecasting vs. Excel Forecasting - why different numbers?

hi, @mmace1 

My apologies,  It seems that there is no new information about this,  but the development route of them should be similar. So you could use it as a reference.

 

Best Regards,

Lin

 

Community Support Team _ Lin
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

View solution in original post

3 REPLIES 3
Community Support
Community Support

Re: Power BI Forecasting vs. Excel Forecasting - why different numbers?

hi, @mmace1 

You may refer to this blog:

https://powerbi.microsoft.com/en-us/blog/describing-the-forecasting-models-in-power-view/

https://powerbi.microsoft.com/en-us/blog/introducing-new-forecasting-capabilities-in-power-view-for-...

Does Power View use the same forecasting algorithm as in the Data Mining Add-ins for Excel?

No, this is a different tool, and a different (but similar) algorithm.

  • Charting and forecasting in Power View does not require a connection to Analysis Services, and instead runs on data stored in Excel, with processing done “behind the scenes” on the Excel Data Model.
  • Forecasting on Power View charts does not use the ARTXP or ARIMA algorithms provided by SQL Server Analysis Services. Although those algorithms were developed by Microsoft Research in response to common theories and research on time series forecasting, and solve many of the same problems, they are implemented on a different code base and might yield different results.

We recommend that you experiment with various methods of forecasting and compare results. Typically data scientists will try out many models and evaluate their accuracy before accepting a prediction as valid for business application.

 

Best Regards,
Lin

 

Community Support Team _ Lin
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

View solution in original post

mmace1 Post Patron
Post Patron

Re: Power BI Forecasting vs. Excel Forecasting - why different numbers?

Thanks! 

 

Is there confirmation that the (2014) blog  data there is still accurate?  On the PBI side it mentions PowerView (now depricated), and on the Excel side it mentions the data add-in (it's built-in to Excel now, not an add-in).

 

 

Highlighted
Community Support
Community Support

Re: Power BI Forecasting vs. Excel Forecasting - why different numbers?

hi, @mmace1 

My apologies,  It seems that there is no new information about this,  but the development route of them should be similar. So you could use it as a reference.

 

Best Regards,

Lin

 

Community Support Team _ Lin
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

View solution in original post

Helpful resources

Announcements
New Ranks Launched March 24th!

New Ranks Launched March 24th!

The time has come: We are finally able to share more details on the brand-new ranks coming to the Power BI Community!

‘Better Together’ Contest Finalists Announced!

‘Better Together’ Contest Finalists Announced!

Congrats to the finalists of our ‘Better Together’-themed T-shirt design contest! Click for the top entries.

Arun 'Triple A' Event Video, Q&A, and Slides

Arun 'Triple A' Event Video, Q&A, and Slides

Missed the Arun 'Triple A' event or want to revisit it? We've got you covered! Check out the video, Q&A, and slides now.

Join THE global Microsoft Power Platform event series.

Join THE global Power Platform event series.

Attend for two days of expert-led learning and innovation on topics like AI and Analytics, powered by Dynamic Communities.

Community Summit North America

Community Summit North America

Innovate, Collaborate, Grow. The top training and networking event across the globe for Microsoft Business Applications

Top Solution Authors
Top Kudoed Authors