NON LINEAR Regression with Power BI - Logarithmic Growth #nonlinear #regression
2.6 هزار بار بازدید -
پارسال
-
The new DAX function LINEST()
The new DAX function LINEST() can be used also for non-linear regression.
Depending on the type of relation (logarithmic, exponential etc) we can adjust the LINEST() parameters to get the desired prediction.
In this video we predict an outcome based on a logarithmic curve where the equation will be: y = a + b*ln(x)
Here is the link for the pbix file:
https://drive.google.com/file/d/1WLjs...
====CHAPTERS====
01:00 Dataset presentation
01:26 Logarithmic growth
03:08 Scatterplot in Power BI
04:18 LINEST() function
05:10 Adjust the LINEST() function for logarithmic
06:34 DAX Measure for prediction
Here is the link to the pbix file:
https://drive.google.com/file/d/1VLkY...
#dax #powerbi #linest #dataanalysis #businessintelligence #nonlinear #regressionanalysis
Depending on the type of relation (logarithmic, exponential etc) we can adjust the LINEST() parameters to get the desired prediction.
In this video we predict an outcome based on a logarithmic curve where the equation will be: y = a + b*ln(x)
Here is the link for the pbix file:
https://drive.google.com/file/d/1WLjs...
====CHAPTERS====
01:00 Dataset presentation
01:26 Logarithmic growth
03:08 Scatterplot in Power BI
04:18 LINEST() function
05:10 Adjust the LINEST() function for logarithmic
06:34 DAX Measure for prediction
Here is the link to the pbix file:
https://drive.google.com/file/d/1VLkY...
#dax #powerbi #linest #dataanalysis #businessintelligence #nonlinear #regressionanalysis
پارسال
در تاریخ 1401/12/14 منتشر شده
است.
2,618
بـار بازدید شده