The HCP Base dashboard is a Power BI report that shows how the field force covers the healthcare professionals (HCPs, doctors) assigned to employees during the selected period: how many doctors were covered, how many remain uncovered, how often they get calls and which employees reach their HCP base.
Where to find it
Power BI Reports → CRM Analytics Report → HCP
-
On the Dashboard, click Power BI Reports.
-
Open the CRM Analytics report. Go to the HCP tab at the bottom of the report.
Note: You see the dashboard only if your role has access to Power BI reports.
At a glance
| Section | Description |
|---|---|
| Dashboard / Tab Name | HCP Base (HCP tab of the CRM Analytics Report) |
| Business Goal | Show how the field force covers and engages healthcare professionals (HCPs) in the responsibility base of MR/RM employees during the selected period. |
| Business Value | Helps management evaluate how effectively medical representatives and regional managers work with the doctors assigned to them, find uncovered HCPs, analyze call frequency and compare engagement across specialties and target groups. Supports optimization of field force activities and control over customer reach in assigned territories. |
| Main Users | Regional Managers, Sales Managers, Territory Supervisors, CRM Administrators, Product Managers |
| Key Decisions Supported | HCP coverage optimization, follow-up on uncovered doctors in employee responsibility zones, employee activity monitoring, target group prioritization, call planning adjustments, specialty-focused engagement strategy |
What's on the dashboard
- KPI cards at the top. See KPI cards below.
- HCP Base chart: the HCP base and covered HCPs by month, with the covered assigned HCP percentage as a line.
- Employee HCP Coverage: the HCP base, covered HCPs and covered assigned HCP percentage for each employee, with a total row.
- Coverage Frequency by HCP Category/Target Group: the average number of calls per covered doctor. Use the Category and Target Group buttons to group the chart by HCP category or by target group.
- Detailed HCP Coverage Table: all metrics by supervisor, employee and employee direction, with totals.
- Pivot Table Builder on the left: select the check boxes to choose which fields the Detailed HCP Coverage Table shows, for example period, supervisor, employee, HCP, HCP specialization and category, target group, country, region, area, settlement, address, organization, organization type or sales point.
- Report filters on the left: the period mode (All Periods, Current Year or Current Month), Year, Quarter, Month, Day, Supervisor, Employee, Employee direction, Employee position, Country, Area, Settlement, Target group, HCP Specialization, HCP Type and Responsibility. By default, the dashboard shows the current month.
- Info: opens the user guide for this dashboard in the Proxima knowledge base in a new browser tab, with a full description of the dashboard, its filters and metrics.
- Notify Employee: sends a notification to the selected employee.
- Last update: the date and time of the latest data refresh.
KPI cards
To see what a card shows, hover the mouse over the card, and then hover over the question mark icon (?) that appears above it. A tooltip with the description of the metric opens.
| Card | What it shows |
|---|---|
| HCP Base | The number of unique HCPs (doctors) assigned to the selected employees, that is, the target base for coverage. It does not depend on calls. |
| Covered HCP (Any Owner) | The number of unique HCPs with at least one completed call in the selected period, no matter who made the call and whether the HCP is assigned to that employee. |
| HCP Visits | The number of completed calls to HCPs (doctors) in the selected period. Each call is counted once. |
| Uncovered HCP | The number of HCPs in the base that the responsible employee did not call in the selected period: the HCP base minus covered assigned HCPs. |
| Visits per Covered HCP | The average number of completed calls per covered HCP: HCP calls divided by the unique HCPs called in the selected period. Shows how often each doctor gets a call. |
| Covered Assigned HCP % | The share of the HCP base with at least one completed call from the responsible employee in the selected period. The HCP base is the doctors assigned to the selected employees; calls by other employees do not count. |
Important: The dashboard shows only synchronized CRM data. If employees haven't synchronized their apps, their latest calls may not appear yet.