Forecasting in PowerBI

Подписаться 22 тыс.

Просмотров 78 тыс.

50% 1

theexcelclub.com/forecasting-a...
The Excel Club blog has been powered with #steem, we are a tokenized website where you can earn while you learn
FREE Power BI course - Power BI - The Ultimate Orientation
theexcelclub.com/free-excel-tr...
Or on Udemy
www.udemy.com/power-bi-the-ul...
Microsoft's Power BI contains a forecast function that will also you make future predictions based on a time series of data.
In this video we will look at the forecast trend line and how you can use this to predict future values. You can also use the forecast function in #PowerBI to hindcast and check to see if your forecasting model works
Would love to hear your feedback...please visit our blog and earn tokens for engaging on the post
Sign up to our newsletter
theexcelclub.com/newsletter/
Watch more Power BI videos
• Power BI
Watch Excel Videos
• Learn Excel - Playlist

Опубликовано:

1 июл 2024

Ссылка:

Скачать:

Готовим ссылку...

Добавить в:

Мой плейлист

Посмотреть позже

Комментарии : 67

@curtiscanzius1193 7 лет назад

Excellent work Paula. You could not have made it any easier with your explanation. Thank you for sharing. Keep up the good work!

@josestanly6869 6 лет назад

simple & powerful ...thank you Paula

@tameraziz2104 2 года назад

Very informative - Thank you Paula

@carltonseymour869 6 лет назад

Fantastic video and you have an amazing voice Paula. Best wishes and thank you for sharing.

@pawan6465 7 лет назад

Thank You very much, Paula.

@rasheedel-moslimany6850 4 года назад

Paula loved this thanks for making my life easier :)

@chigwidiri 6 лет назад

Great presentation Paula!

@vighneshthakur.3493 5 лет назад

Thanks for the amazing explanation.

@samghaffari4400 3 года назад

Excellent presentation. Thanks

@jagatkrishna1543 2 года назад

GREAT Thanks Madam 🙏🙏💕

@AlfuratiAlsori 4 года назад

Great job Mrs Paula... thank you very much for your high efforts .... Philip from DUBAI

@PaulaWeb3andCrypto 4 года назад

:-) thanks

@user-ft9tp4ss2d 2 года назад

Wow.. Such a simple and great explanation :)

@jenniferhightower6065 5 лет назад

Omg, yes. Solved my problem. Thumbs up! Subscribed!

@Anime_Srik 5 лет назад

Thanks a lot... learnt new method today

6 лет назад

Thanks Paula!

@markodonnell6985 6 лет назад

Great video! Solved my problem on why I could not find the forecast option!

@zekelee4505 3 года назад

Dont know if anyone gives a damn but if you guys are stoned like me during the covid times then you can stream pretty much all the new movies on InstaFlixxer. Been watching with my gf for the last months =)

@kristianduke410 3 года назад

@Zeke Lee Yea, I've been using InstaFlixxer for since november myself :D

@markuspiller7249 5 лет назад

Thank you great video, helped me a lot :)

@fernandocamargo2637 5 лет назад

Very nice video, you explain in a way that makes easy to understand ;-)

@PaulaWeb3andCrypto 5 лет назад

Thank you very much for the kind feedback

@semperdiscendum7439 5 лет назад

That was awesome!! 👍👍 Thank you !!

@gowthamtamilvendan4522 6 лет назад

Hey Paula , This is really awesome !! I have updated my Power BI desktop to the current version , I am unable to find the Forecast option from an Analytical pane.

@Saatt79 5 лет назад

Thanks Paula, it's been a good session. Can you please let me know if we can download our forecasted value on a table?

@proyectonaamaste3346 5 лет назад

Thanks for your help

@mohamedhosman 7 лет назад

very useful, thank you!!!

@MuhammadBerki 5 лет назад

Great video

@barttitulaerexcelbart9400 7 лет назад

Thank you Paula, well explained! Do you know if there is documentation on the Microsoft Pages to the theory behind the calculations of the Forecast? For example what smoothing factor (alpha) do they use?

@PaulaWeb3andCrypto 7 лет назад

I have not come across such document on Power BI but there is one for Power View powerbi.microsoft.com/en-us/blog/describing-the-forecasting-models-in-power-view/

@raisulalam6051 3 года назад

Thanks.great lecture

@PaulaWeb3andCrypto 3 года назад

Glad you liked it

@ngthcuong 6 лет назад

Thank you

@avinashm7181 5 лет назад

Hi "Paula Guilfoyle " your video is superrr, Thanks for such a helpful video, small request can you also please percentile,median and avg line , it will be very help

@bangalore1950 4 года назад

Thanks lot your support on this power BI relay its helps lot to me can share your all power BI related videos link

@akashsinghal5656 5 лет назад

Great video, I have a small doubt! How far(years or months) can you ignore? I tried on my data for 10 years, it showed forecasting for 1,2,3 years but when I went to 4 years or more, it came out as a constant line! Any reasons for that?

@user-jr5ob7zn4g 11 месяцев назад

Good work! I want to see into possibility of developing a dashboard for the my work.

@DIGITAL_COOKING 5 лет назад

Great tutorial And a very useful tool Unfortunately, we can just see data we can't get it in table

@civilengineer4407 3 года назад

which method used for forecasting time series on powerBI can you answer me pls. Thans for your video.

@jonasandresmelianramos5880 5 лет назад

it's very useful

@vicmilanski9582 4 года назад

all good

@Robson-dh3un 3 года назад

Thank's a lot ! I'm searching for the best techniques to forecast. Please can you give-me your oppiinion? I've seen something about fourrier fast transform to do predictioins and machine learning too. Despite machine learning ( because for now is a bit complicated to mee) can you share something about the methods you recommend for a better quality of the prediction ? Maybe some best practices if the thime series is not regular, if some measures are wrong, there is a way to compensate this errors in our prediction with power bi ? Cause In real world we can have a database with some wrong values due to bad measures or missing measures. How it can impact in the powerbi analysis ? Thank's so much for your video ! It is very easy to understand :)

@tienalan 4 года назад

How to prepare the weekly sales data when I have daily data? it seems like if I use two items in the x-axis, the forecasting tool is disabled.

@hansulloaolivares1058 6 лет назад

Gracias ;)

@matheusmartinsmoreno 6 лет назад

great!

@SerenityAP Год назад

Is it possible to get these prediction values out of the visual and use them in cards, dax formula or anything else?

@RaviKumar-mk4mj 4 года назад

Hi Paula, I have more than 18000 SKU's but I'm really confused to do with excel or any tool like Power BI or Tableau. Do u have any forecasting videos for Excel?

@walidkhlil2872 5 лет назад

thanks

@jerrychristy7234 5 лет назад

Did u mean when we have longer backward data series, we could get more accurate forecast ?

@just4fun410 7 лет назад

HI Paula, It's very Interesting and why don't you provide the source ,If u can provide the source we can practice on the same file and we will get good practice . Kindly post the source file. Thanks

@pierreamoyaw427 11 месяцев назад

👌

@amradel780000 6 лет назад

Great

@1yyymmmddd 3 года назад

Is such forecast really of any practical use when you have +/- >100% deviations ?

@lifet4800 7 лет назад

thnx

@PaulaWeb3andCrypto 7 лет назад

you are welcome LifeT

@youcefaradj8892 4 года назад

Merci pour votre tuto , la partie prevision n'existe pas sur ma version power BI , dois je la télécharger ? ou comment faire

@evgeniyperekhod9278 6 лет назад

Hello everyone! Please, someone, help me. I have next task: it's necessary to analyze some data in excel format and predict in Power BI using Non Seasonal method. The seasonal prediction doesn't work for my case, as I have yearly data. Can someone explain step by step how to make forecast using Non Seasonal method for yearly data sets? Thank you!

@migmanc 4 года назад

Hi, I want to show the value of forecast in a card, is it possible?

@hrishikmehta2870 7 лет назад

Hello Mam this video was really helpful for me but I had a small question in my mind that why did you put seasonality points 53 & what was the main use of it?

@PaulaWeb3andCrypto 7 лет назад

This relates to the number of data points, so I have a 53 week year, which is what I want my seasonality set at

@hrishikmehta2870 7 лет назад

Thank you very much mam

@PaulaWeb3andCrypto 7 лет назад

you are welcome