13 - Power BI KPI's - Examples and Discussion
The more time you spend thinking about your KPI's, the more you should begin to realise that a Data Culture is a must in this day and age. It is impossible to have a ring-fence around your analysis and only have structured static content leave (PowerPoint). The expectation now and the capability is to be able to explore the data and dig into it. This is a two-edged sword, as shown in this video. Trust becomes a vital part of your success, and without it, you become bogged down in a mire of pointless analysis.
Inspections LY =
CALCULATE(
[Inspections],
SAMEPERIODLASTYEAR('Calendar'[Dates] )
)
YOY Change % =
DIVIDE(
[Inspections],
[Inspections LY]
)
Join us at https://geordieintelligence.co.uk, read the articles supporting this series; become a member to get the inside track.
Support us: https://geordieintelligence.co.uk/sup...
00:00 - Introduction
01:01 - Simple is best
05:30 - Power BI - Time Intelligence and X-Functions
09:05 - Example - NYC Water Tower Inspections - What is a KPI?
10:40 - Practical Demonstration in Power BI
19:15 - Conclusions