You can but it won't be a very accurate forecast. There are too many unknown variables that affect stock prices (market crashes, pandemics, interest rate changes, etc).
The passage of time is the best measure of any forecast. Power BI needs to add statistics that allow you to better gauge the underlying forecast assumptions like Tableau does.
Hello. Thanks for Sharing. i did as you said. all good but 1 issue. when my mouse cursor point on forecast line the tool tip dont show the month. i want to see the month.
Thanks for showing me this tool Anthony. There is one thing bugging me which I dare to elaborate on. Aren't what you are describing supposed to be called "prediction intervals" or actually "credible intervals" not confidence intervals. As I understand, say we were to repeat the same test 100 times (and therefore obtain 100 CI's), if 95 of those 100 intervals had the true value inside, we could call it a 95% CI. It confuses the hell out of me but according to people a lot smarter than me, I have been told this is not the same as saying there is a 95% chance our predicted value will fall in the confidence range. Just thought I would confuse you too haha...
@@AnthonySmoak Hi Anthony Yes I was. although my method may be a tad clunky. First I did my forecast, then I exported my data as a csv. The csv will have all of the forecast data points you discuss. You could just bring back the csv back into Power BI...Sounds clunky, but all of the data including confidence points will be in the csv
Thanks for the video. If I want to show the same but with multiple columns, lets say within the "Vehicle" there are one more level of data like a hierarchy, then how to show the % of totals for each column individually? anyone? Thanks
Hey the video was amazing dude But could you tell how to get the error metrics like the RMSE and the MASE , MAPE values like you showed us in the Tableau tutorial Would be grateful if you could do that.
@@AnthonySmoak I think in ARIMA you get that within PowerBi. Still exploring though. One issue that I have with PowerBi Time Series is that, it does not show Data Lables for the forecasted periods/ Points. Did you find any workaround for it?
Thanks for sharing! Definitely agree with the strikes/cons of it, but great way to do simple forecasting
Thanks for sharing Anthony!, I concur with you that PBI team could disclose what is going on behind the scenes, let us vote on this one hehe
Hi , great video. Wanted to know how we can forecast assuming we have a target after certain period of time.
Good stuff man. Discovered your website and youtube channel today. Great stuff. Thanks for sharing your knowledge. Definitely subscribed.
I appreciate that, thanks!
Thanks for sharing. Is there any way to get the forecast data in a tabular for or on a card?
Do you think they use the ARIMA model to estimate the forecasted values?
Tableau uses exponential smoothing. help.tableau.com/current/pro/desktop/en-us/forecast_how_it_works.htm
@@AnthonySmoak Okay and where does that leave PowerBI? hehe
wow, thanks! Exactly what I was looking for! Any recommended courses/training on PowerBI?
Stay tuned, I might come up with a course one of these days!
edX offers a MS training
Can we create forecast for stock market future ?
You can but it won't be a very accurate forecast. There are too many unknown variables that affect stock prices (market crashes, pandemics, interest rate changes, etc).
Great tutorial. How do we measure the performance of this forecasting in Power BI?
The passage of time is the best measure of any forecast. Power BI needs to add statistics that allow you to better gauge the underlying forecast assumptions like Tableau does.
Thank you.
You're welcome!
Hello. Thanks for Sharing. i did as you said. all good but 1 issue. when my mouse cursor point on forecast line the tool tip dont show the month. i want to see the month.
This should be easily remedied by manually adding your month field to the tooltip.
Thanks for showing me this tool Anthony. There is one thing bugging me which I dare to elaborate on. Aren't what you are describing supposed to be called "prediction intervals" or actually "credible intervals" not confidence intervals. As I understand, say we were to repeat the same test 100 times (and therefore obtain 100 CI's), if 95 of those 100 intervals had the true value inside, we could call it a 95% CI. It confuses the hell out of me but according to people a lot smarter than me, I have been told this is not the same as saying there is a 95% chance our predicted value will fall in the confidence range. Just thought I would confuse you too haha...
@@emiliod90 Interesting read. Thanks for sharing.
How to reproduce this in Dax?
you can get the data into excel. Views the data, you can then export that view as a csv
Thanks for commenting. Just to clarify, were you able to get the forecasted values into a csv?
@@AnthonySmoak Hi Anthony Yes I was. although my method may be a tad clunky. First I did my forecast, then I exported my data as a csv. The csv will have all of the forecast data points you discuss. You could just bring back the csv back into Power BI...Sounds clunky, but all of the data including confidence points will be in the csv
What is upper and lower bounds
Thanks for the video. If I want to show the same but with multiple columns, lets say within the "Vehicle" there are one more level of data like a hierarchy, then how to show the % of totals for each column individually? anyone? Thanks
Hey the video was amazing dude
But could you tell how to get the error metrics like the RMSE and the MASE , MAPE values like you showed us in the Tableau tutorial
Would be grateful if you could do that.
Unfortunately PBI does not yet have those error metrics available. If you find otherwise please let us know here in the comments.
@@AnthonySmoak I think in ARIMA you get that within PowerBi. Still exploring though.
One issue that I have with PowerBi Time Series is that, it does not show Data Lables for the forecasted periods/ Points. Did you find any workaround for it?
How to choose stationality pattern?
That is currently not an option.
Most people don't get confidence intervals...😁
Request to have 1048 p video quality