Basic statistics in power bi

[powerbiexpert22]

is it possible to perform basic statistic like clustering , regression analysis etc in power bi?

[v-csrikanth]

Hi @powerbiexpert22 

We haven't heard from you since last response and just wanted to check whether the solution provided has worked for you. If yes, please Accept as Solution to help others benefit in the community.

If the above information is helpful, please give us Kudos and mark the response as Accepted as solution.
Best Regards,
Community Support Team _ C Srikanth.

[v-csrikanth]

Hi @powerbiexpert22 

Thank you for being part of the Microsoft Fabric Community.

As highlighted by @BhavinVyas3003 @bhanu_gautam , the proposed approach appears to effectively address your requirements. Could you please confirm if your issue has been resolv
If you are still facing any challenges, kindly provide further details, and we will be happy to assist you.

If the above information is helpful, please give us Kudos and mark the response as Accepted as solution.
Best Regards,
Community Support Team _ C Srikanth.

[BhavinVyas3003 · Accepted solution]

Hi,

Yes, Power BI supports basic statistical techniques like clustering and regression analysis. While there are no built-in regression options, you can leverage external integrations for advanced analytics.

Clustering: Power BI includes a clustering feature in visuals like the Scatter Chart and K-Means Clustering. It allows you to automatically group similar data points without writing any code.

Regression Analysis: To perform regression analysis, you can integrate R or Python scripts within Power BI. By using the R script visual or Python visual, you can execute the necessary code for regression models like linear regression directly in the report.

You can also use DAX for certain statistical calculations, but advanced models require R/Python integration.

Thanks,

Bhavin

[bhanu_gautam]

@powerbiexpert22 ,

Yes, it is possible to perform basic statistical analyses such as clustering and regression analysis in Power BI. Power BI provides several built-in features and integrations that allow for these types of analyses:

Clustering: Power BI has a built-in clustering feature that can be used to segment data into clusters. This can be accessed through the "Visualizations" pane by using the "Scatter Chart" and enabling the clustering option.

Regression Analysis: Power BI supports regression analysis through the use of custom visuals and R or Python scripts. You can use the "R script visual" or "Python visual" to write and execute R or Python code directly within Power BI to perform regression analysis.