Building KPI Dashboard in Power BI
Using Cyber Crime Data –
Step-by-Step Guide
Go to Data Set
1. Introduction to KPI
KPI (Key
Performance Indicator) is a measurable value that shows how effectively an objective is being
achieved.
In Power
BI, a KPI visual helps us:
- Show the current value
- Track trend over time
- Compare with a target
- Indicate performance using
color (green/red)
- Display growth or decline
using arrows
It is
mainly used for performance monitoring.
2. Why KPI is Important in
Cyber Crime Analysis?
Your
dataset contains:
- Year
- States
- Total Crimes
- Rate of Total Cyber Crimes
- Mid-Year Projected
Population
- Chargesheeting Rate
Raw
numbers alone do not show performance clearly.
Using
KPI, we can:
✔ Monitor if cyber crime is increasing
✔ Check whether enforcement efficiency is improving
✔ Compare against predefined targets
✔ Identify warning signals quickly
3. Important KPIs for Cyber
Crime Dashboard
We will
create 3 KPIs:
- Total Cyber Crimes
- Cyber Crime Rate
- Chargesheeting Rate
Each KPI
will include:
- Value
- Trend
- Target
4. Create Required Measures
(Recommended)
Go to:
👉 Modeling → New Measure
✅ Total Crimes Measure
Total Crimes KPI = SUM('Cyber Crime Data'[Total
Crimes])
✅ Average Cyber Crime Rate
Avg Cyber Crime Rate = AVERAGE('Cyber Crime
Data'[Rate of Total Cyber Crimes])
✅ Average Chargesheeting Rate
Avg Chargesheeting Rate = AVERAGE('Cyber Crime
Data'[Chargesheeting Rate])
5. Create Target Measures
(Very Important Update)
Now we
create Target values for each KPI.
Targets
can be:
- Government benchmark
- Policy goal
- Previous year performance
- Fixed expected standard
Target 1: Crime Reduction Target (5% Reduction)
Crime Target = [Total Crimes KPI] * 0.95
This
means we expect 5% reduction from current level.
Target 2: Cyber Crime Rate Target
Assume
acceptable rate = 50
Cyber Crime Rate Target = 50
(You can
replace with actual policy benchmark)
Target 3: Chargesheeting Rate Target
Assume
expected efficiency = 75%
Chargesheeting Target = 75
6. Insert KPI Visual (Drag
& Drop)
Go to:
👉 Report View
👉 Select KPI visual
You will
see 3 fields:
- Value
- Trend axis
- Target
7. Configure KPI – Total Crimes
Drag:
- Value → Total Crimes KPI
- Trend Axis → Year
- Target → Crime Target
Set Direction
Go to:
👉 Format → Indicator
Select:
✔ Low is good
Because
reduction in crimes is positive.
Now:
- Green arrow → Crime
decreasing
- Red arrow → Crime increasing
8. Configure KPI – Cyber Crime Rate
Add
second KPI.
Drag:
- Value → Avg Cyber Crime Rate
- Trend Axis → Year
- Target → Cyber Crime Rate
Target
Set:
✔ Low is good
9. Configure KPI –
Chargesheeting Rate
Add third
KPI.
Drag:
- Value → Avg Chargesheeting
Rate
- Trend Axis → Year
- Target → Chargesheeting
Target
Set:
✔ High is good
Because
higher efficiency is better.
🔷 10. How Target Works in KPI
When
target is set:
Power BI
compares:
Current
Year Value
vs
Target Value
Then it
shows:
- Distance from target
- Percentage difference
- Green or Red color
- Up or Down arrow
Example:
If
Chargesheeting Rate = 78
Target = 75
→ KPI
shows Green
→ Performance above target
If Total
Crimes > Target
→ KPI
shows Red
→ Performance worse than expected
11. Formatting KPI Visual (Professional Setup)
Click KPI
→ Format Pane.
🔹 Callout Value
- Increase font size (28–36)
- Set display units (K or M
for crimes)
- Keep % for rates
🔹 Indicator Colors
- Positive → Green
- Negative → Red
Keep
simple professional theme.
🔹 Trend Axis
- Use neutral line color
- Stroke width 2
- Avoid bright colors
🔹 Goal Formatting
- Goal line color → Dark gray
- Keep thin line
- Turn ON "Distance to
goal"
12. Add Slicers for Dynamic
KPI
Add
slicers:
- States
- Year
Now KPIs
change dynamically for selected state.
This
makes your dashboard interactive and powerful.
0 टिप्पण्या
कृपया तुमच्या प्रियजनांना लेख शेअर करा आणि तुमचा अभिप्राय जरूर नोंदवा. 🙏 🙏