Simple Linear Regression| Using Power BI🖥️, Python & Excel | LINESTX | RMSE | Dynamic Report pages✨
Simple Linear Regression Analysis using Power BI Desktop.
In this video, you will learn many concepts including :
1) Linear Regression
2) Power BI LINEST and LINESTX functions
3) Calculate Root Mean Squared Error (RMSE)
4) Dynamic Predictions
5) Create a Report page that has interactive visuals.
It's a very simple method and easy to understand step-by-step example . Please watch it till the end. Please Like this video and Subscribe to @LinknetAnalytics
We will be using my Fitbit Activity dataset to create a report page that has interactive visuals
Dataset folder is from my Fitbit watch Charge 5
https://drive.google.com/file/d/1qfO8...
TIMESTAMPS
00:01 Overview of Linear Regression
01:53 About LINEST and LINESTX in Power BI
02:53 LINESTX function practical use case
04:08 Create a measure to predict y ;use the equation y= mX+b
05:02 Create a measure for Residual
05:10 About Standard Deviation & RMSE(Root Mean Squared Error
06:14 Measure for calculating RMSE
08:00 Overview of final report page
09:22 Linear Regression using Python and Excel/Libre office Calc
11:42 Dynamic Prediction using ' What if Parameter'
13:34 Conclusion