Important: This article describes the default version of the report that every customer gets at the start. If the report was later customized for your company, its appearance and functionality may differ, including how some metrics are calculated.
The Prescription dashboard is a Power BI report that compares the prescription potential of healthcare professionals (HCPs, doctors) with planned and actual prescriptions, and shows how call activity of the field force relates to prescription results: by period, employee, brand, SKU and HCP.
Where to find it
Power BI Reports → CRM Analytics Report → Prescription
-
On the Dashboard, click Power BI Reports.
-
Open the CRM Analytics report. Go to the Prescription 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 | Prescription (Prescription tab of the CRM Analytics Report) |
| Business Goal | Provide visibility into prescription generation dynamics, compare prescription potential with planned and actual prescription results, and evaluate the effectiveness of field force influence on prescription activity. |
| Business Value | Helps management assess how effectively promotional and call activities convert into actual prescriptions, monitor achievement against prescription potential and planned targets, and identify gaps between expected and actual prescription performance. Supports evaluation of commercial effectiveness at employee, brand, SKU and HCP level, links prescription results to HCP coverage, and helps optimize prescription-focused strategies and resource allocation. |
| Main Users | Product Managers, Sales Managers, Regional Managers, Marketing Managers, CRM Administrators, Business Analysts |
| Key Decisions Supported | Prescription performance evaluation, prescription plan adjustment, brand prioritization, employee effectiveness analysis, HCP targeting and call coverage optimization, commercial strategy improvement based on prescription dynamics |
What's on the dashboard
- KPI cards at the top. See KPI cards below.
- Period switch: All Periods, Current Year or Current Month. The selected period is shown under the chart and table titles, for example 11/2026 - 11/2026.
- Prescriptions Dynamic Overview chart: Potential count, Potential plan and Potential fact for each day of the selected period.
- Pivot Table Builder: select the check boxes to choose which fields the table shows: Year, Month, Day, Supervisor, Employee, HCP, HCP Id, HCP Specialization, HCP Category, Brand and SKU.
- Detailed Prescriptions Table: the Potential count, Potential plan and Potential fact values for each row built with the Pivot Table Builder, with a Total row. Click a column header to sort the table.
- Report filters on the left: Year, Quarter, Month, Day, Supervisor, Employee, Employee direction, Employee position, Brand, Category and Visit Type.
- 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 |
|---|---|
| Potential count | The potential number of prescriptions of HCPs by brand: the volume the brand could reach with these doctors. It is the benchmark for planned and actual prescriptions. |
| Potential plan | The planned number of prescriptions for the selected period. |
| Potential fact | The actual number of prescriptions for the selected period. |
| HCP Visits | The number of calls to HCPs in the selected period. |
| cp_covered_hcp | The number of HCPs covered with calls in the selected period. |
Important: All cards, the chart and the table show data for the period selected in the period switch and the report filters. The dashboard shows only synchronized CRM data. If employees haven't synchronized their apps, their latest calls may not appear yet.