From the course: Power BI: Integrating AI
Join today to access over 24,800 courses taught by industry experts.
Calculating correlations - Power BI Tutorial
From the course: Power BI: Integrating AI
Calculating correlations
- [Instructor] Covariance measures the strength of the relationship between two variables, but not the direction. Correlation measures both the strength and the direction of the relationship between two variables. If we visualize our correlations, a perfect best fit line with a correlation of one would perfectly fit a straight line through these data points. However, we don't live in a perfect world. Correlation values range inclusively between negative one and positive one. Perfect negative correlated values have a correlation value of exactly negative one, where they line up perfectly along a straight line where the slope is negative. Most correlation values though, will range between negative one and one as we'll see in our examples. The trend line that we can add to Power BI Visuals represents the output of linear regression models. To figure out how well this line fits, we want to quantify how closely the points land up along the trend line. In this visual, the X measure…
Practice while you learn with exercise files
Download the files the instructor uses to teach the course. Follow along and learn by watching, listening and practicing.
Download courses and learn on the go
Watch courses on your mobile device without an internet connection. Download courses using your iOS or Android LinkedIn Learning app.