Check your eligibility for this 50% exam voucher offer and join us for free live learning sessions to get prepared for Exam DP-700.
Get StartedDon't miss out! 2025 Microsoft Fabric Community Conference, March 31 - April 2, Las Vegas, Nevada. Use code MSCUST for a $150 discount. Prices go up February 11th. Register now.
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?
Solved! Go to Solution.
hi, @mmace1
You may refer to this blog:
https://powerbi.microsoft.com/en-us/blog/describing-the-forecasting-models-in-power-view/
No, this is a different tool, and a different (but similar) algorithm.
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
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
hi, @mmace1
You may refer to this blog:
https://powerbi.microsoft.com/en-us/blog/describing-the-forecasting-models-in-power-view/
No, this is a different tool, and a different (but similar) algorithm.
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
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).
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
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Prices go up Feb. 11th.
Check out the January 2025 Power BI update to learn about new features in Reporting, Modeling, and Data Connectivity.
User | Count |
---|---|
143 | |
84 | |
64 | |
52 | |
49 |
User | Count |
---|---|
211 | |
87 | |
80 | |
69 | |
60 |