Embedding Statistical Analyses

Statistical analysis beyond basic aggregations is typically implemented outside of business intelligence semantic models by data scientists and data science applications. When possible, however, it is much more efficient to leverage existing semantic models, Power BI skills, and the features used for other Power BI reports and dashboards—such as the Analytics pane described earlier in this chapter.

In this recipe, the data points supporting a linear regression model are created from an existing Power BI semantic model. This model is then analyzed and described via DAX measures, with values such as slope, Y-intercept, and the Z-score for residuals. Finally, a rich report page is constructed to visualize the strength and accuracy of the regression model and detect outliers.

Getting ready

1. Download Embedding Statistical Analysis Start.pbix from the following GitHub repository: https://github.com/PacktPublishing/Power-BI-Cookbook...