Forum Discussion

powerbiexpert22's avatar
powerbiexpert22
Impactful Individual
1 year ago
Solved

Basic statistics in power bi

is it possible to perform basic statistic like clustering , regression analysis etc in power bi?
  • BhavinVyas3003's avatar
    1 year ago

    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