The HCP All Base dashboard is a Power BI report that shows the entire healthcare professional (HCP, doctor) base in the CRM, not only the doctors assigned to employees, and how much of it the field force covered last month: by region, target group and specialization.
Where to find it
Power BI Reports → CRM Analytics Report → HCP All
-
On the Dashboard, click Power BI Reports.
-
Open the CRM Analytics report. Go to the HCP All 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 All Base (HCP All tab of the CRM Analytics Report) |
| Business Goal | Give a consolidated view of the entire healthcare professional (HCP) base in the CRM and measure how much of it the company reaches across regions, target groups and medical specialties. |
| Business Value | Helps management see how the company works with the full HCP universe in the CRM, not only with doctors assigned to MR/RM responsibility zones. Supports strategic analysis of market reach, discovery of uncovered HCP segments, evaluation of specialty penetration and control of the customer base quality. |
| Main Users | Top Management, Sales Directors, Regional Managers, CRM Administrators, Product Managers, Business Analysts |
| Key Decisions Supported | Strategic HCP coverage planning, specialty-focused engagement, finding regions or target groups with low coverage, CRM base quality monitoring, field force expansion planning, long-term customer development strategy |
What's on the dashboard
- KPI cards at the top. See KPI cards below.
- HCP All Base Coverage by area chart: the share of covered and uncovered HCPs in each region. Each bar is 100% of the doctors in that region.
- HCP All Base Coverage by target: the same split by target group.
- HCP All Base Coverage by area table: the HCP count, covered and uncovered HCPs and the covered percentage for each region, with a total row. Click + next to a region to expand it.
- HCP All Base Coverage by specialization: the share of covered and uncovered HCPs for each specialization.
- Pivot Table Builder at the bottom: select the check boxes to choose which fields the table shows, for example country, region, area, settlement, organization, HCP, HCP ID, HCP specialization and category, target group, phone number, e-mail, visit last month, visit last year, supervisor, employee, organization type or sales point. The table shows the HCP All Base, HCP All Base Coverage, HCP All Base Coverage % and HCP All Base Uncovered values for each row.
- Report filters on the left: Country, Region, Area, City, HCP Category, HCP Specialization, Target group, Supervisor, Employee, Employee position, Employee direction, Organization, Organization Type and Sales point. The tab has no date filters: coverage is always counted for the last 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 or chart shows, hover the mouse over it, 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 |
|---|---|
| All Base HCP Count | The total number of HCPs (doctors) in the whole CRM base, not only those assigned to employees. It does not depend on calls or dates. |
| All Base HCP Covered (Last Month) | The number of HCPs from the whole base with at least one completed call in the last month. |
| All Base HCP Covered % (Last Month) | The share of the whole HCP base with at least one completed call in the last month: covered HCPs divided by the total number of HCPs. |
Important: Coverage on this dashboard is always calculated for the last month. The dashboard shows only synchronized CRM data. If employees haven't synchronized their apps, their latest calls may not appear yet.
Learn more
- Dashboard: HCP All Base
- HCP All Base - Dashboard Elements
- HCP All Base Dashboard Filters
- HCP All Base Dashboard - KPI Calculation Logic
- HCP All Base Coverage by Region
- HCP All Base Coverage by Target Group
- HCP All Base Coverage by Specialization
- HCP All Base Coverage by Region (table)
- Detailed HCP Coverage Table
- HCP All Base Pivot Table Builder