Тёмный

PREDICT THE FUTURE with LINEAR REGRESSION / How to use LINEST function / Beginners Guide to Power BI 

Fernan
Подписаться 44 тыс.
Просмотров 13 тыс.
50% 1

In this video we're going to look at how you can use the LINEST and LINESTX functions to calculate linear regression in Power BI.
🕓 TIMESTAMPS
0:00 - Intro
00:36 - What is it?
03:10 - LINEST function
05:25 - Demo
09:00 - Add a What-If Scenario
-
📣 Get Demo Files HERE
bit.ly/3dJE2O7
🔍 Looking to get started in data? Check out this COURSE to get the essential skills you need. No experience required.
solutionsabroad.thinkific.com/
📰 Sign up to our FREE Weekly Newsletter for Power BI news, community updates and more
solutionsabroad.co.uk/newsletter
🛒 Power BI TEMPLATES and more at our digital shop
solutionsabroad.co.uk/store
ko-fi.com/solutionsabroad/shop
❤ Other ways to SUPPORT us
/ solutionsabroad
ko-fi.com/solutionsabroad
📧 GET IN TOUCH
Website: solutionsabroad.co.uk/
Email: fernan@solutionsabroad.co.uk
LinkedIn: / solutionsabroad
Facebook: / solutionsabroad
Instagram: / solutions_abroad
🤝 SOLUTIONS ABROAD
Hi Power BI fans, my name is Fernan. In 2018 I founded Solutions Abroad to help fellow data enthusiasts learn Microsoft’s tool, Power BI. I’m currently based in London with over 8 years of experience working with data and business intelligence. In this channel I provide educational videos about Power BI including tips and tricks, step by step tutorials, news, and all of it for FREE. I also provide some paid content such as courses, templates as well as consultancy services.
If you like what we’re doing here and would like to support, consider purchasing something or donating through our Patreon, every little penny helps us keep the channel going.
🙏 THANK YOU
Thank you so much for checking out my channel and my videos. You, the community, have been instrumental in growing the channel to where it is now. Hope to see you again on my next video!
#PowerBI #DataAnalytics #BusinessIntelligence

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

 

26 июн 2024

Поделиться:

Ссылка:

Скачать:

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

Добавить в:

Мой плейлист
Посмотреть позже
Комментарии : 14   
@tubeitz
@tubeitz Год назад
excellent explanation, thank you
@jejetator
@jejetator 8 месяцев назад
Well done fernan. great video to forecast easily
@eyitayoeyitayo-lawal2331
@eyitayoeyitayo-lawal2331 Год назад
I have been saddled with the task in my office to generate some predictive analysis in my report. This nailed it. Thank you so much Fernan
@p.j.882
@p.j.882 11 месяцев назад
Microsoft excel office support has the best explanation of LINEST.
@comptegmail273
@comptegmail273 Год назад
Can you make some videos about machine learning algorithms in power bi
@markconnor8667
@markconnor8667 Год назад
Very interesting
@comptegmail273
@comptegmail273 Год назад
@@markconnor8667 do yo uhave any idea
@John-cq6vh
@John-cq6vh Год назад
@@comptegmail273 I thing python can easily do that in power bi.
@devpattnayak9231
@devpattnayak9231 9 месяцев назад
Hi Fernan, Is there any solution to add Polynomial Trend chart in a scatter plot. I searched over internet but didn't find any solution.
@donatusvictor3500
@donatusvictor3500 10 месяцев назад
Thank you for the video, but i have a problem with my data when I add a column to the value section it will not work again. Please i need your help
@user-rs3vq3xu4f
@user-rs3vq3xu4f 10 месяцев назад
I have Revenue and Cost in two different tables, how can I use the above to arrive at the Linear regression and predict for future years
@lorenzocassina2538
@lorenzocassina2538 9 месяцев назад
Let's say I have a table with 100 different Jobs with all the Salaries and Years of experience. I'd like to do a linear regression on each of the different job. How do I use LINESTX in a smart way, avoiding to write 100 DAX queries? How can I link a dropdown list of the jobs, located in one tab of our dashboard, to LINESTX function? Is that possible? Basically how can I filter dynamically the table that is feeding LINESTX?
@ManishKumar-eu1qw
@ManishKumar-eu1qw Год назад
@Solutions Abroad how to pass parameter to public URL ?? please solve this problem
@eyitayoeyitayo-lawal2331
@eyitayoeyitayo-lawal2331 Год назад
I used COUNT function instead of SUM function as used since i am working with months to predict future sales as i have sales for 6 months. The parameter function did not work since it is factoring SUM instead of COUNT in the calculation
Далее
это самое вкусное блюдо
00:12
Просмотров 1,7 млн
Implementing linear regression in Power BI
13:52
Просмотров 27 тыс.
3 Ways to use Calculation Groups You Need to Know
20:00
How To Create Amazing Forecasts in Power BI in Seconds
10:47
это самое вкусное блюдо
00:12
Просмотров 1,7 млн