topic Measures or KPI in Warehousing & Analytics

Measures or KPI

harveychun — Mon, 30 Dec 2024 19:17:51 GMT

With Databricks BI, Is there anyway to create a KPI or Measures that can be used in a visual? If so, how to achieved that one?

Re: Measures or KPI

Walter_C — Mon, 30 Dec 2024 19:44:06 GMT

Can you please provide some more context on your current usecase?

Re: Measures or KPI

harveychun — Mon, 30 Dec 2024 19:56:47 GMT

Hi @Walter_C

I am just figuring out if possible in databricks.

Let say for example I have a Measure in Power BI or a formula in Thoughtspot and wanted to move it to databricks XYZ = (sum(x) + sum(y))/z

I wanted to use that XYZ formula/measure in a visual either by vendor or by product or by category. XYZ data will dynamically change depending on grouping or filters applied.

I am thinking of whatever I have in Power BI and Thoughtspot, I can translate to Databricks and users can just directly use it in databricks without having to do data model in power bi and create measures in power bi. Wanted to have everything in Databricks

Re: Measures or KPI

szymon_dybczak — Mon, 30 Dec 2024 20:55:20 GMT

Hi @harveychun ,

You can try to use AI/BI dashboards in Databricks SQL. There is a good article written by Cody Austin Davis that shows how combination of parameters and filters allows to create dynamic reports.
But keep in mind that reproducing complex DAX measures in Databricks SQL can be complicated and that the capabilities of databricks dashboards (which are getting better) are still pretty limited comparing to Power BI.

Building Lakeview Dashboards on Databricks — Best Practices | by Databricks SQL SME | DBSQL SME Engineering | Medium