The CCTV Installation KPI Dashboard in Power BI scores 14 installation, commissioning, video-availability, network, service and commercial KPIs against monthly targets across three interactive report pages and two hover tooltip pages. The data pack that ships with it holds 504 monthly rows — 168 target rows for 2025 and 336 actual rows spanning 2024 and 2025 — so month-on-month and year-on-year comparisons work the moment the file opens. Every KPI is defined in a spreadsheet rather than hard-coded into the report, which means you can add, rename or delete metrics without ever opening the report editor.
Most security and CCTV installation firms already have the numbers. They sit in a job sheet, a commissioning log, a service-desk export and an accounts package, and nobody has time to knit them together before the monthly management meeting. This template is the knitting: you paste target and actual figures into three sheets, press Refresh, and get a traffic-light scorecard, a trend page and a per-KPI detail page that a non-technical owner can read in thirty seconds.
What This Template Is — and What It Absolutely Is Not
CCTV is surveillance of people, and in many jurisdictions that is regulated. So this needs saying plainly and early, before any of the feature detail.
This is an internal management reporting template over data the buyer supplies. It does not view, record, store, analyse or process any video, image or footage of any kind. It holds installation project records only — counts, hours, rates, costs and dates that you type in. It performs no facial recognition, no biometric identification and no video analytics of any description.
It also does not establish compliance with anything. Not GDPR or UK GDPR, not the EU AI Act, not the Data Protection Act 2018, not the Surveillance Camera Code of Practice, not BIPA, not state CCTV or two-party consent laws, not data-retention rules, and not any licensing requirement for security installers such as SIA registration or state alarm and CCTV licences. It is not a Data Protection Impact Assessment, not a surveillance risk assessment, not a system design, not a commissioning record and not an inspection certificate. It certifies nothing about camera performance, coverage, uptime or evidential quality.
One further caveat worth reading twice: if you record client site names, camera locations or any personal data in the workbook, lawful handling, minimisation and retention of that data are entirely your responsibility. Several of the operators we have spoken to keep sites as codes rather than addresses for exactly this reason. The UK Information Commissioner’s video surveillance guidance is a sensible place to start if you are unsure what your obligations are.
Finally: every number in the screenshots on this page is buyer-entered demo data. It is realistic sample data shipped so the report is not blank when you open it. It is not real operational data from any installer, and you should replace it before showing the report to anyone.
Key Features of the CCTV Installation KPI Dashboard in Power BI
- 14 KPIs across 6 groups. Installation Delivery (Cameras Installed, Install Hours per Camera, Cabling Rework Rate %, Project Schedule Variance %), Commissioning (Commissioning First-Time Fix %, Image Quality Complaint Rate %), Video Availability (Camera Offline Hours, Recording Retention Compliance %), Storage & Network (Bandwidth per Camera, Storage Cost per Camera), Field Service (Service Ticket Resolution Time, Preventive Maintenance Completion %) and Commercial (Revenue per Site, Technician Utilization %).
- Direction-aware scoring. Each KPI is tagged UTB (higher is better) or LTB (lower is better). Higher-is-better KPIs score Actual ÷ Target; lower-is-better KPIs score Target ÷ Actual. Beating a cost or cycle-time target therefore reads above 100%, which is the behaviour most people expect and most spreadsheets get wrong.
- Fixed traffic-light thresholds. On Target at 100% or more, At Risk between 95% and 100%, Missed below 95% — applied to both the MTD and the YTD achievement figures.
- Nothing is bound to a KPI name. The visuals between them reference 46 distinct field and measure names, and not one of them names a specific metric. Rename a KPI in the three input sheets and the whole report follows.
- Correct MTD and YTD behaviour. YTD sums for additive measures such as counts and money, and averages for rates and ratios. This is the single most common mistake in a hand-built KPI pack — a compliance percentage that totals 1,900% by December makes every YTD chart useless.
- Owner and priority on every metric. Field Operations, Commissioning Team, Remote Monitoring Center, Network Engineering, Service Desk, Maintenance Planning, Commercial Finance, Compliance & Assurance, Project Management Office, Cabling & Infrastructure and Resource Planning all appear as owners, and every KPI carries a Critical / High / Medium priority you can slice on.
Dashboard Pages Explanation
Page 1: KPI Scorecard
Five slicers — Month, KPI Group, Owner, Priority and Direction — sit above five summary cards: Total KPIs, MTD Target Met, MTD At Risk, MTD Target Missed and Achievement MTD. Each card carries its own month-on-month delta and a 12-month sparkline. The scorecard table below lists every KPI with its group, unit, a 12-month trend column, Actual and Target MTD, Achievement % MTD, a status light, a YoY arrow, Actual YTD, Achievement % YTD and a second status light.
Page 2: KPI Trend
A single-select KPI list on the left drives the entire page. Six context cards restate the selected KPI, its group, unit, direction, owner and priority; five value cards show Actual MTD, Target MTD, Achievement % MTD, the status light and YoY % MTD. Two line charts follow — CY MTD vs PY MTD vs Target MTD by Month and CY YTD vs PY YTD vs Target YTD by Month — each plotting current year, prior year and target on the same axis.
Page 3: KPI Definition
The same KPI selection, synced as a slicer rather than a drillthrough, surfaces the metric’s formula and its written definition alongside group, unit, direction, owner, priority and a 12-month sparkline. A Monthly Detail for the Selected KPI table gives twelve months of Actual MTD, Target MTD, Achievement % MTD, status, Actual YTD and Achievement % YTD with a total row, beside MTD Actual vs Target by Month and Achievement % by Month.
The pages you will not see as tabs
The file also carries two 280×360 tooltip pages, KPI Detail and Trend Detail, each holding three cards and a bar chart. They are hidden in view mode by design and appear when you hover a visual. There are no hidden drillthrough pages. A fourth page, Get More Templates, is the NextGenTemplates catalogue plus a short customisation note rather than a report page, which is why it is not shown among the screenshots above.
CCTV Installation KPI Dashboard in Power BI vs. a Tableau/Qlik Build vs. Field-Service SaaS — Feature Comparison
| Feature | This Power BI template | Tableau / Qlik build | ServiceTitan / Jobber |
|---|---|---|---|
| Cost | $12.99 one-time ✅ | $75–$115 / user / month | $99–$400+ / month, quoted |
| Platform | Power BI Desktop, free from Microsoft ✅ | Paid licence per creator and viewer | Vendor-hosted only |
| Setup time | Under 10 minutes ✅ | Days of modelling and design | Weeks of onboarding and migration |
| Add or rename a KPI | One spreadsheet row ✅ | Rebuild the calculation and the visuals | Fixed metric set, vendor roadmap |
| Target vs actual, MTD and YTD | Built in, direction-aware ✅ | You build it | Partial, job-level only |
| Prior-year comparison | 24 months shipped ✅ | You build it | Depends on plan tier |
| Your data leaves the building | No ✅ | Usually cloud-published | Yes, vendor-hosted |
| Real-time team collaboration | No — file-based | Yes ✅ | Yes ✅ |
| Year-1 cost at 5 users | $12.99 ✅ | $4,500–$6,900 | $1,200–$4,800+ |
For an installer who wants a board-ready monthly KPI pack without a BI licence or a field-service subscription, this template sits in the sweet spot.
Who Should Use This Template
Perfect for:
- Security and CCTV installation contractors running 5–200 sites a year who report monthly to an owner or a board
- Operations and project managers who keep install, commissioning and service numbers in a spreadsheet and want them scored against target
- Managed-service providers reporting camera availability, retention compliance and storage cost back to clients
- Anyone who wants a reusable Power BI KPI pack they can rename for an adjacent trade
Not a fit if:
- You need to view, store, search or analyse actual video footage — this file never touches footage
- You are looking for evidence of GDPR, EU AI Act, DPA 2018, BIPA or Surveillance Camera Code compliance, or for a DPIA
- You need live camera-health monitoring or alerting — this is a monthly report, not an NVR or VMS console
- You need dispatch, scheduling, quoting or invoicing
- Several people must edit the same report simultaneously in a browser
Real-World Use Cases
Marcus runs a 22-engineer CCTV installation firm in Manchester. He replaces the demo rows with his own monthly numbers and opens the scorecard on the first Monday of every month. The MTD Target Missed card tells him in one glance how many of his 14 metrics slipped, and the Direction slicer lets him look only at the lower-is-better ones — rework, schedule variance, offline hours — before the ops meeting starts.
Priya manages remote monitoring for a managed-service provider. She uses the KPI Trend page on Camera Offline Hours and Recording Retention Compliance %, showing current year against prior year and target on one chart, and drops it straight into the client’s quarterly service review. Client names never go into the workbook; sites are referred to by code.
Dan owns a small alarm and access-control business. He renamed six of the 14 KPIs to suit his trade, deleted two he does not measure, pressed Refresh, and had a working scorecard the same afternoon without ever opening the report editor.
Advantages of the CCTV Installation KPI Dashboard in Power BI
- One-time cost instead of a subscription. $12.99 once against $1,200–$6,900 in year one for the alternatives in the table above.
- No BI licence needed. Power BI Desktop is free from Microsoft and opens the file directly.
- Your data stays on your machine. Nothing is uploaded unless you choose to publish it to your own workspace — which matters more than usual when the subject is surveillance.
- Genuinely reusable. Because no KPI name is hard-coded, the same file becomes a fire-safety, lift-maintenance or glazing KPI pack with a spreadsheet edit.
- The maths is already right. Direction-aware achievement, sum-versus-average YTD, and prior-year comparison are the three things hand-built packs usually get wrong.
Opportunities for Improvement
An honest list, because no template is perfect:
- The Total KPIs card’s sparkline is effectively blank. It plots a count that never changes month to month, so it renders as a flat, almost invisible line. It is not broken — there is simply nothing to trend.
- Line-chart axis labels sit at uneven intervals. On the KPI Trend page the Y axis reads 3.9 / 4.2 / 4.6 / 4.9 because Power BI rounds axis labels to one decimal place at that scale. Cosmetic, but visible.
- Monthly granularity only. There is no weekly or per-site breakdown; the model is one row per KPI per month.
- No per-site or per-technician drill. Adding one means extending the data model yourself, which is straightforward but is real work.
- The prior year must be typed in. If you only have twelve months of actuals, every YoY figure will be blank until you add the earlier year.
Best Practices
- Fill the KPI Definition sheet first. Unit, formula, definition, owner, priority and direction drive most of what the report displays.
- Use site codes rather than site names or addresses. The report never needs the real name, and keeping personal data out of the file is the cheapest privacy control available.
- Load the prior year of actuals even if it is approximate. Without it, every YoY arrow is empty.
- Keep
Data.xlsxand the.pbixin the same folder. If you must move them, use Home > Transform data > Data source settings > Change Source. - Set the At Risk band deliberately. The shipped 95–100% band is a sensible default, not a rule.
- Do not delete the shipped demo rows until your own data loads cleanly — they are a useful reference for the expected column shapes.
Explore Relevant Templates
If you would rather work in a browser, the same KPI pack ships as the CCTV Installation KPI Dashboard in Google Sheets, and there is a lighter CCTV Installation KPI Scorecard in Google Sheets too.
On this blog, the closest reads are the Smart City Surveillance Dashboard in Power BI, which is the analytics-style sibling rather than a KPI scorecard, and the Fire Safety Services KPI Dashboard in Power BI, which uses the identical scorecard architecture for a different trade. For other installation trades built the same way, see the Glass Installation KPI Dashboard in Power BI, the Garage Door Service KPI Dashboard in Power BI and the Window and Door Installation KPI Dashboard in Excel. If your interest is the risk side rather than the delivery side, the Cyber Risk Management Dashboard in Excel is a useful companion.
Frequently Asked Questions
Does this handle CCTV footage or make our surveillance compliant?
No — to both. The CCTV Installation KPI Dashboard in Power BI holds installation project records only. It never views, records, stores or analyses video, images or footage, it performs no facial recognition or video analytics, and it establishes no compliance with GDPR, the EU AI Act, the DPA 2018, BIPA, the Surveillance Camera Code or any installer licensing scheme.
What KPIs does the dashboard track?
It tracks 14 KPIs across 6 groups, including Cameras Installed, Install Hours per Camera, Cabling Rework Rate %, Commissioning First-Time Fix %, Camera Offline Hours, Recording Retention Compliance %, Bandwidth per Camera, Storage Cost per Camera, Service Ticket Resolution Time, Revenue per Site and Technician Utilization %.
Can I add my own KPIs or remove the ones I do not use?
Yes. No KPI name is hard-coded anywhere in the report. Add, rename or delete rows across KPI Definition, Input_ Target and Input_ Actual, then press Home > Refresh. The cards, the scorecard, the KPI slicer list and every chart follow automatically.
How long does setup take?
Under ten minutes if your figures are already in a spreadsheet. Paste them into the three input sheets, keep the workbook beside the .pbix, and press Refresh. The included Power BI Dashboard user manual PDF covers repointing the data source if you move the folder.
Are the numbers in the screenshots real?
No. Every figure shown is realistic sample data supplied for demonstration, not real operational data from any installer or any site. Replace it with your own before showing the report to anyone.
How does this compare to ServiceTitan or Jobber?
Those are field-service platforms for dispatch, scheduling and invoicing at $99–$400+ a month. This is a $12.99 one-time management report that scores KPIs against target. They solve different problems, and plenty of installers run both side by side.
What exactly is in the download?
A ZIP containing three files: the .pbix report, Data.xlsx with its four sheets (Read Me, Input_ Target, Input_ Actual and KPI Definition), and a Power BI Dashboard user manual PDF. Keep all three in the same folder.
About the Author
Built by PK — Microsoft Certified Professional with 15+ years of Excel, Google Sheets and Power BI experience. Founder of NextGenTemplates, reaching 300K+ subscribers across YouTube channels. Every template is hand-built and tested before release.
Conclusion
If you install cameras for a living and your monthly reporting is still a spreadsheet stitched together the night before the meeting, the CCTV Installation KPI Dashboard in Power BI replaces that job with a data-entry task and a Refresh. It will not manage your footage, it will not make you compliant, and it will not dispatch an engineer — but it will tell you, honestly and in one screen, which of your 14 numbers are on target this month and which are not.
👉 Click here to Purchase the CCTV Installation KPI Dashboard in Power BI
Instant download · One-time payment · No subscription
For step-by-step video tutorials, visit Youtube.com/@PKAnExcelExpert.
Last updated: September 2026
