Forum Discussion
KPI overview from multiple workspaces, possible?
Hi Jakob_PBI ,
Please try to use Power BI’s usage metrics feature. This feature enables you to discover who’s using reports throughout your organization, and how they’re using them. You can also identify high-level performance issues and consolidate KPIs in a single report.
To access usage metrics for a report, you must have edit access to the report. Your Power BI admin must have enabled usage metrics for content creators. Your Power BI admin may have also enabled collecting per-user data in usage metrics. Once you have access to usage metrics, you can create and view a new usage metrics report. The report contains usage metrics for that content for the last 30 days.
Monitor usage metrics in workspaces (preview) - Power BI | Microsoft Learn
Consolidating KPIs in Power BI: the only guide you'll ever need Zebra BI
If I have misunderstood your meaning, please provide more deails.
Best Regards
Community Support Team _ Rongtie
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Thank you for replying, but I am asking about KPI's and not usage metrics.
KPI = Key Performance Indicators.
Each department have their own indicators of how well they are doing. These indicators are called KPIs. They are not part of the same data model. The top management want to monitor the performance across all departments and each department have their own workspace.
So the question is.. how do I create an overview of KPI's that combine data and measures from different workspaces?
Here below you can see examples of KPI's across departments.
Brunner_BI They are not part of the same datamodel and if 1 table in the refresh fails then the entire refresh will stop, so this is not a good idea. I have 12 workspaces and if just 1 fails then none of the data will be updated.
Sales:
- Revenue Growth: Measures the increase in a company's sales over a period.
- Conversion Rate: The percentage of leads or prospects that turn into actual sales.
- Customer Acquisition Cost (CAC): The total cost associated with acquiring a new customer, including marketing and sales expenses.
Procurement:
- Cost Savings: The reduction in costs achieved through effective procurement strategies.
- Supplier Lead Time: The time taken by suppliers to deliver products or services after an order is placed.
- Purchase Order Cycle Time: The duration from when a purchase order is created to when the goods or services are received.
Human Resources (HR):
- Employee Turnover Rate: The rate at which employees leave the organization and are replaced.
- Time to Fill: The amount of time it takes to fill an open position.
- Employee Engagement: A measure of how engaged and motivated employees are within the organization, often assessed through surveys.
You can create a dashboard then - I don't like them but it could work.
Or you create a report with a composite model based on DirectQuery connection to all your Sales, Procurement and HR datasets.
