The HCO All Base dashboard is a Power BI report that shows the entire healthcare organization (HCO, institution) base in the CRM, not only the organizations assigned to employees, and how much of it was covered by calls in the last month: by region, city, organization type and employee.
Where to find it
Power BI Reports → CRM Analytics Report → HCO All
-
On the Dashboard, click Power BI Reports.
-
Open the CRM Analytics report. Go to the HCO 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 | HCO All Base (HCO All tab of the CRM Analytics Report) |
| Business Goal | Provide a consolidated overview of the entire healthcare organization (HCO, institution) base in the CRM and measure overall coverage across all territories, regions and organization types. |
| Business Value | Helps management evaluate how effectively the company covers the full HCO base in the CRM, not only the institutions assigned to specific MR/RM responsibility zones. Supports strategic analysis of market penetration, identifies uncovered segments by geography and organization type, and helps assess the completeness and quality of engagement across the entire customer base. |
| Main Users | Top Management, Sales Directors, Regional Managers, CRM Administrators, Product Managers, Business Analysts |
| Key Decisions Supported | Strategic coverage planning, territory expansion analysis, identifying regions or organization categories with low coverage, CRM data quality monitoring, customer base segmentation and long-term field force planning |
What's on the dashboard
- KPI cards at the top. See KPI cards below.
- HCO All Base Coverage by region and HCO All Base Coverage by city charts: the share of covered and uncovered organizations in the last month for each region and city.
- HCO All Base Coverage by region table: the HCO count, covered and uncovered organizations and the covered percentage for each region. Click + next to a region to see its details.
- HCO All Base Coverage by type: the share of covered and uncovered organizations in the last month for each organization type, such as hospitals, pharmacies or clinics.
- Detailed HCO Coverage Table: all metrics by supervisor and employee, with totals.
- Pivot Table Builder on the left: select the check boxes to choose which fields the Detailed HCO Coverage Table shows, for example country, region, area, settlement, organization category and type, organization, organization network, main organization, address, supervisor, employee, employee position, Visited last month or Visited last year.
- Report filters on the left: Country, Region, Area, Settlement, Organization Category, Organization Type, Organization, Organization Id, Archive Status, Supervisor, Employee and Employee position.
- 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 |
|---|---|
| All Base HCO Count | The total number of HCOs in the all-base list: every organization in the company base, not only those assigned to a representative. It does not depend on calls or the selected dates. |
| All Base HCO Covered (Last Month) | The number of all-base HCOs with at least one completed call in the last month. |
| All Base HCO Covered % (Last Month) | The share of all-base HCOs with at least one completed call in the last month: covered HCOs divided by the total number of all-base HCOs. |
Note: Coverage on this dashboard is always calculated for the last month. The period is fixed and doesn't change with the dates shown on the charts.
Exporting data
You can export the data of any visual on the dashboard to a table file:
- Hover over the visual and click More options (⋯).
-
Select Export data.
- In the Which data do you want to export? window, choose what to export:
- Data with current layout: the data exactly as it looks in the visual. Available only for tables and matrices.
- Summarized data: the aggregated values used to build the visual, such as sums and averages. Available for all visuals.
- Underlying data: detailed row-level data. Available only if the report author turned on this option.
4. In File format, select .xlsx (up to 150,000 rows) or .csv, and then click Export.
If the visual has a lot of data, the number of exported rows may be limited, depending on the file format. For more information, see Report page elements and their essential functions.
Important: The dashboard shows only synchronized CRM data. If employees haven't synchronized their apps, their latest calls may not appear yet.
Learn more
- HCO All Base Dashboard: Coverage of Healthcare Organizations (Institutions)
- HCO All Base - Dashboard elements
- HCO All Base Dashboard filters
- HCO All Base Dashboard - KPI Calculation Logic
- HCO All Base Coverage by region
- HCO All Base Coverage by city
- HCO All Base Coverage by type
- HCO All Base Coverage by region (table view)
- Detailed HCO Coverage Table
- HCO All Base Pivot Table Builder