The New LINEST() DAX Function in Power BI - Regression Analysis Made Easy #regressionanalysis

preview_player
Показать описание
The new DAX function LINEST() is a new powerful tool in your Data Analysis skillset.

It is the easiest way to do Regression Analysis. And Regression Analysis is a fundamental concept in Data Science.

LINEST() function uses the Least Squares method to calculate a straight line that best fits the given data, then returns a table describing the line.

The equation for the line is of the form: y = Slope1*x1 + Slope2*x2 + ... + Intercept.

While we had this function in Excel for many years, only with this month update we have it in Power BI.

====CHAPTERS====
01:23 LINEST() documentation
02:40 LINEST table creation
03:20 Equation for linear regression
04:30 Parameters table (years)
07:07 Measure for selected years
08:13 2nd Equation for prediction

Here is the link to the pbix file:

#dax #powerbi #linest #dataanalysis #businessintelligence #linearregression #regressionanalysis
  1. Data Analytics Central
  2. Power BI
  3. Data Analytics
  4. Power Query
  5. Data Analysis
  6. Business Intelligence
Рекомендации по теме
The New LINEST() 0:10:28

The New LINEST() DAX Function in Power BI - Regression Analysis Made Easy #regressionanalysis

The New LINESTX() 0:08:20

The New LINESTX() DAX Function in Power BI - Clearly Explained #linearregression

PREDICT THE FUTURE 0:10:31

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

LINEST function 0:04:44

LINEST function

Implementing linear regression 0:13:52

Implementing linear regression in Power BI

DAX CALCULATE Function 0:08:45

DAX CALCULATE Function Made Easy to Understand (just one word)

Time to look 0:08:01

Time to look at the new INDEX function in DAX and Power BI

How to use 0:08:18

How to use Linest Function in Excel || Linest Formula

NON LINEAR Regression 0:09:19

NON LINEAR Regression with Power BI - Logarithmic Growth #nonlinear #regression

Basic Excel Business 0:04:45

Basic Excel Business Analytics #49: LINEST Array Function for Simple Linear Regression

How to do 0:09:10

How to do Simple Linear Regression in Power BI | Diana Arciniega

LINEST vs LOGEST 0:01:11

LINEST vs LOGEST Statistical Function with Examples in MS Office Excel 2016

Data forecasting using 0:08:01

Data forecasting using DAX functions

Power BI - 0:00:19

Power BI - DAX function - ANY

Options for Simple 0:09:24

Options for Simple LInear Regression in Power BI

Linest Function In 0:02:54

Linest Function In Excel | Linest Formula In Excel | Excel Tutorial

LINEST STATISTICAL ALGORITHIM 0:15:23

LINEST STATISTICAL ALGORITHIM LIST IN EXCEL 0.9

Power Bi : 0:35:33

Power Bi : Build a simple Linear Regression Equation in DAX to Predict a Goal

Power Bi : 0:03:40

Power Bi : Evaluating my linear regression model

CHISQ.INV DAX Function 0:01:22

CHISQ.INV DAX Function in Power BI - Learning Power Bi 2023

Excel Tutoriral ,Python 0:00:12

Excel Tutoriral ,Python Tutorial Video #ankitshree #ankitshree

Excel Magic Trick 0:01:53

Excel Magic Trick 1046: Linear Regression Estimate & Add Many Predicted Y-Values Single Cell For...

SINH, COSH, ASINH, 0:00:42

SINH, COSH, ASINH, ACOSH, TANH, ATANH, COTH, ACOTH - DAX Guide

Basic Excel Business 0:08:31

Basic Excel Business Analytics 52: LINEST, F.DIST.RT, T.DIST.2T & ABS Functions Test of Signific...

Комментарии
Автор

Man, I just want you to know, that I've just found your channel, I've just watch your video, hit the dumb buttom, suscribe to EVERY notification, and share your content with my people.

Really thanks for this amazing content; keep breaking it 🤙

angelmaravilla
Автор

great! very helpful video, thank you! My "Salary_Data" table is similar but also has a third column (object) which I need to filter in. The code to calculate SalaryEST, in fact, computes all mixed ebjects, even if I select a single object by a slicer from Salary_Data. Is there a simple solution without making X, Y table for each single object in Salary_Data?

Cirocarbone
Автор

Thanks for amazing video, If i have a column 'product' how i do a equation for each product? Because only did to all together.

rafaelfelipenovi
Автор

Missing items: standard errors values of coefficients, coefficient of determination, standard error of y estimate, f statistic, degree of freedom, regression sum of squares, residual sum of squares.... check excel help on linest.

p.j.
Автор

how about if the relationship is not linear?

adilmajeed