PREDICT THE FUTURE with LINEAR REGRESSION / How to use LINEST function / Beginners Guide to Power BI
HTML-код
- Опубликовано: 11 июл 2024
- 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
Well done fernan. great video to forecast easily
excellent explanation, thank you
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
Microsoft excel office support has the best explanation of LINEST.
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.
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
Can you make some videos about machine learning algorithms in power bi
Very interesting
@@markconnor8667 do yo uhave any idea
@@comptegmail273 I thing python can easily do that in power bi.
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
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?
@Solutions Abroad
how to pass parameter to public URL ??
please solve this problem
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