Analytics & Reports
Learn how to navigate PIN's analytics dashboards, build custom reports, use data visualisation tools, export data, and set up automated scheduled reports.
Dashboard Overview
Understanding PIN's analytics home screen
The Analytics dashboard is PIN's intelligence layer — aggregating de-identified registry data from across the network into outcome benchmarks, treatment comparisons, and cohort statistics. It is read-only and refreshes nightly.
Pain score distribution — your cohort vs. network average
0–12–33–45–66–77–88–910
Summary Panel
Top-level KPIs for your cohort: total patients, active treatment count, mean NRS scores at baseline and last follow-up, and percentage with ≥30% pain reduction.
Network Benchmarks
Your cohort's outcomes compared to anonymised network averages, stratified by diagnosis and treatment type. Hover any metric to see the network sample size behind it.
Treatment Breakdown
Distribution of current treatment modalities across your patients — pharmacotherapy, interventional, combined, and multimodal — with mean outcome per modality.
⚠️ Alerts Panel
Patients flagged for overdue follow-up, worsening pain trajectory (≥2-point NRS increase over 90 days), or pending risk reassessment.
Research Activity
Patients enrolled in active research protocols, pending consent renewals, and data contribution status for ongoing PIN studies.
Date range filter All dashboard panels respect the global date range selector in the top-right corner. Set a custom range to focus on a specific period — for instance, the past 12 months of outcomes for your annual audit.
Data refresh cadence The dashboard updates nightly at 02:00 UTC. Data entered today will appear in analytics from the following morning. The last-updated timestamp is shown in the footer of each panel.
️
Creating Custom Reports
Build and save reports for your specific cohort or question
Custom reports let you define a patient cohort, select outcome metrics, apply filters, and save the result as a named report you can revisit, share with colleagues, or schedule for automated delivery.
1
Navigate to Analytics → Reports → New Report
In the Command Center, open Analytics in the sidebar, then click the Reports tab. Select + New Report to open the report builder.
2
Define your cohort
Use the cohort builder to specify which patients are included. Filters can be combined — all must match (AND logic):
Diagnosis
One or more ICD-10 codes or diagnosis categories (e.g. all neuropathic pain diagnoses)
Treatment type
Pharmacotherapy, interventional, multimodal, or specific procedure codes
Date range
Registration date, first treatment date, or follow-up date window
Demographics
Age band, biological sex, or institution site
Risk tier
Filter by ORT/SOAPP-R risk tier at baseline or most recent assessment
3
Select outcome metrics
Choose one or more metrics to display for the cohort. Available metrics include mean NRS at baseline and follow-up, percentage with ≥30% / ≥50% pain reduction, PGIC distribution, BPI interference scores, treatment duration, and adverse event rates. Metrics can be viewed as aggregate totals or broken down by a grouping variable (e.g. by treatment type or by diagnosis).
4
Preview and refine
Click Preview to see a live render of the report with your current settings. Adjust filters or metrics as needed. The preview also shows the cohort size — if it's below 10 patients, results will be suppressed in the export to protect de-identification.
5
Name and save the report
Give the report a descriptive name (e.g. SCS outcomes 2025 — FBSS cohort). Click Save Report. Saved reports appear in your Reports library and can be opened, cloned, or shared with other PIN members at your institution.
Clone a report template PIN provides pre-built report templates for common clinical audit scenarios (annual opioid review, neuromodulation outcomes audit, new patient cohort summary). Browse templates under Reports → Templates and clone to customise.
Data Visualisation Tools
Charts, heatmaps, and outcome trajectories
Every report and dashboard panel in PIN can be rendered as one of several chart types. Visualisations are interactive — hover for values, click to drill down, and drag to zoom on time-series charts.
Bar Chart
Grouped or stacked. Best for comparing outcomes across categories (e.g. treatment modalities, diagnosis groups, or institutions). Default view for most cohort comparisons.
Line Chart
Time-series. Used for tracking outcome trajectories over follow-up intervals — NRS trend, BPI improvement curve, or registry enrolment growth. Supports multiple series with a legend.
Donut Chart
Proportional. Best for treatment mix distributions and PGIC category breakdowns. Hover a segment to see exact count and percentage.
Heatmap
Two-dimensional. Used for visualising outcome distribution by age band × diagnosis, or follow-up frequency × pain reduction. Colour intensity represents the metric value.
⚫ Scatter Plot
Each point is one patient. Used for baseline vs. follow-up pain score comparisons — points above the diagonal line represent improvement. Drag to select a cluster and drill down to those records.
Geo Map
Network-level only. Visualises registry contributor distribution by country — available on the Network Benchmarks panel and global PIN analytics views.
Switching chart type
1
Click the chart type icon in the panel toolbar
Each analytics panel has a toolbar in its top-right corner. The chart type selector shows the current type as an icon — click it to open the type picker. Not all types are available for every metric (e.g. geo map is only available for geographic data).
2
Use "Compare to network" toggle
On bar and line charts, toggle Compare to network to overlay your cohort's data against the anonymised network average as a secondary series or reference line.
3
Save the view to your report
If you have changed a panel's chart type and want to preserve it, click Save to Report from the panel menu. The chart type preference is saved with the report configuration.
Presentation mode Click the expand icon on any chart panel to enter full-screen presentation mode — useful for MDT meetings or grand rounds. Press
Esc to exit.⬇️
Exporting Data & Reports
Download data for audit, research, or presentation
PIN supports several export formats depending on your intended use — formatted PDFs for clinical audit reports, CSV for statistical analysis, and chart images for presentations. All exports are de-identified and logged.
| Format | Best for | Includes raw data? |
|---|---|---|
| PDF Report | Clinical audits, governance submissions, MDT packs | No — summary tables and charts only |
| CSV | Statistical analysis in R, SPSS, or Excel | Yes — row-per-patient, de-identified |
| Excel (.xlsx) | Formatted tables for administrators or non-analysts | Yes — with formatted headers and filters |
| PNG / SVG | Embedding charts in slides or publications | No — chart image only |
1
Open the report or dashboard panel you want to export
Navigate to Analytics → Reports and open the saved report, or use the export option directly from any dashboard panel.
2
Click Export and choose your format
Click the Export button in the top-right toolbar. Select your format from the dropdown. For CSV and Excel, you'll be prompted to confirm the cohort scope and date range before downloading.
3
Review the data use reminder
Before any CSV or Excel export, PIN displays a brief data use reminder confirming the data is de-identified and must be handled in accordance with your institution's data governance policy. Tick to confirm and the download will begin.
Minimum cohort size CSV and Excel exports are suppressed if the cohort contains fewer than 10 patients — this is a de-identification safeguard. If you need data on a very small cohort for a specific clinical reason, contact support to discuss options under your institution's IRB protocol.
Export log All exports are recorded in your account's export log under Settings → Data Exports. This log is available to your institution's data governance lead on request.
Scheduled Reports Setup
Automate recurring report delivery to your inbox
Scheduled reports run on a recurring basis and deliver a formatted PDF or CSV to your registered email — useful for monthly outcome reviews, quarterly audits, or weekly patient alert summaries.
1
Open a saved report
Scheduled delivery can only be set up on a saved report. If you haven't already created and saved your report, do that first — see Creating Custom Reports above.
2
Click Schedule Delivery
From the report toolbar, click Schedule → to open the delivery configuration panel.
3
Configure the schedule
Set the following options:
Frequency
Daily, Weekly (choose day), Monthly (choose date), or Quarterly
Delivery time
Time of day to send — defaults to 07:00 in your account's timezone
Format
PDF summary (default) or CSV data file
Recipients
Your email is added automatically. Add up to 4 additional PIN members at your institution as co-recipients.
Date window
Rolling (e.g. "last 30 days") or fixed. Rolling is recommended for recurring reports.
4
Send a test delivery
Click Send Test Now to receive an immediate preview at your email. Verify the format and content look correct before saving the schedule.
5
Save the schedule
Click Activate Schedule. The schedule is now live — it appears under Analytics → Scheduled Reports where you can pause, edit, or delete it at any time.
All set You now know how to navigate the analytics dashboard, build custom reports, switch visualisation types, export data in multiple formats, and automate recurring delivery. PIN's analytics tools turn your registry contributions into actionable clinical intelligence.