Posts

Example of a Reimbursement Analysis Dashboard for Pharma Companies

What is a Reimbursement Analysis Dashboard?

Reimbursement Dashboards are considered operational analysis tools and are used by program and product managers to review expenses and other metrics related to the company’s drug reimbursement program. Some of the main functionality in this type of report is that it provides graphical analysis of five key performance indicators (KPIs), including: 1) Year-to-date (YTD) costs of reimbursement requests, 2) Reimbursements by channel (hospitals, physicians, retail pharmacies, etc.) YTD, 3) Number of claims by reimbursement status (in process, paid, pending, to pay), 4) Top five claimants (hospital, patients, health plans, government, social workers), and 5) Reimbursement cost by product. You find an example of this type of dashboard below.

Purpose of Reimbursement Analysis Dashboards

Pharmaceutical companies use Reimbursement Analysis Dashboards to give managers self-service analysis that enables them to closely monitor expenses and other metrics related to the reimbursement program. When used as part of good business practices in Finance and Product departments, a company can improve its profitability and policies, and it can reduce the chances that managers miss trends and outliers that could have been used to improve program strategies.

Example of a Reimbursement Analysis Dashboard

Here is an example of a Reimbursement Dashboard with costs, top claimants and refunds by product.

Example of a Reimbursement Analysis Dashboard for Pharma Companies

Example of a Reimbursement Analysis Dashboard for Pharma Companies

You can find hundreds of additional examples here

Who Uses This Type of Report?

The typical users of this type of report are: Program managers, controllers, analysts, executives.

Other Reports Often Used in Conjunction with Reimbursement Analysis Dashboards

Progressive Finance and Product departments sometimes use several different Reimbursement Analysis Dashboards, along with reimbursement reports, profit & loss reports, KPI dashboards, annual budgets and other management and control tools.

Where Does the Data for Analysis Originate From?

The Actual (historical transactions) data typically comes from enterprise resource planning (ERP) systems like: Microsoft Dynamics 365 (D365) Finance, Microsoft Dynamics 365 Business Central (D365 BC), Microsoft Dynamics AX, Microsoft Dynamics NAV, Microsoft Dynamics GP, Microsoft Dynamics SL, Sage Intacct, Sage 100, Sage 300, Sage 500, Sage X3, SAP Business One, SAP ByDesign, Acumatica, Netsuite and others.

In analyses where budgets or forecasts are used, the planning data most often originates from in-house Excel spreadsheet models or from professional corporate performance management (CPM/EPM) solutions.

What Tools are Typically used for Reporting, Planning and Dashboards?

Examples of business software used with the data and ERPs mentioned above are:

  • Native ERP report writers and query tools
  • Spreadsheets (for example Microsoft Excel)
  • Corporate Performance Management (CPM) tools (for example Solver)
  • Dashboards (for example Microsoft Power BI and Tableau)

Corporate Performance Management (CPM) Cloud Solutions and More Examples

Example of a Patient Assistance Dashboard for Pharmaceutical Companies

What is a Patient Assistance Dashboard?

Patient Assistance Dashboards are considered program analysis tools and are used by managers of patient initiatives and researchers to monitor performance and results of patient assistance programs. Some of the main functionality in this type of report is that it provides analysis from eight different perspectives, including: 1) Patient requests by status, 2) Medical advisory inquiries, 3) YTD enrollees by product, 4) Medical advisory inquiries by product, 5) Enrollees by eligibility criteria, and 6) Medical advisory inquiries by method. You find an example of this type of report below.

Purpose of Patient Advisory Dashboards

Pharmaceutical companies use Patient Advisory Dashboards to give managers a good understanding of results of active patient programs. When used as part of best practices in Product and Patient Program Departments, a company can improve its initiatives and service level, and it can reduce the chances that managers lack good field data when making their decisions.

Example of a Patient Advisory Dashboard

Here is an example of a Patient Assistance Dashboard with inquiries and enrollment metrics.

Example of a Patient Assistance Dashboard for Pharmaceutical Companies

Example of a Patient Assistance Dashboard for Pharmaceutical Companies

You can find hundreds of additional examples here

Who Uses This Type of Report?

The typical users of this type of report are: customer service leaders, researchers, product managers.

Other Reports Often Used in Conjunction with Patient Advisory Dashboards

Progressive Product and Patient Program departments sometimes use several different Patient Advisory Dashboards, along with detailed patient program reports, KPI dashboards and other management and control tools.

Where Does the Data for Analysis Originate From?

The Actual (historical transactions) data typically comes from enterprise resource planning (ERP) systems like: Microsoft Dynamics 365 (D365) Finance, Microsoft Dynamics 365 Business Central (D365 BC), Microsoft Dynamics AX, Microsoft Dynamics NAV, Microsoft Dynamics GP, Microsoft Dynamics SL, Sage Intacct, Sage 100, Sage 300, Sage 500, Sage X3, SAP Business One, SAP ByDesign, Acumatica, Netsuite and others.

In analyses where budgets or forecasts are used, the planning data most often originates from in-house Excel spreadsheet models or from professional corporate performance management (CPM/EPM) solutions.

What Tools are Typically used for Reporting, Planning and Dashboards?

Examples of business software used with the data and ERPs mentioned above are:

  • Native ERP report writers and query tools
  • Spreadsheets (for example Microsoft Excel)
  • Corporate Performance Management (CPM) tools (for example Solver)
  • Dashboards (for example Microsoft Power BI and Tableau)

Corporate Performance Management (CPM) Cloud Solutions and More Examples

Example of a Clinical Trial Dashboard for Pharmaceutical Companies

What is a Clinical Trials Dashboard?

Clinical Trials Dashboards are considered program analysis tools and are used by executives and drug trial managers to monitor actual and planned program expenses and KPIs. Some of the main functionality in this type of dashboard is that it enables interactive analysis from four different perspectives, including: 1) Target versus actual cost per drug trial, 2) Target versus actual participants by drug trial, 3) Target versus actual hours by drug trial, 4) Target versus actual cost by status. You find an example of this type of dashboard below.

Purpose of Clinical Trials Dashboards

Pharmaceutical companies use Drug Trial Dashboards to provide managers with essential actual and planning drug trial data in a format that is easy to consume. When used as part of good business practices in Financial Planning & Analysis (FP&A) and Clinical Trial departments, an organization can improve its drug trials and product strategies, and it can reduce the chances that there is lack of clarity in expenses and trial results.

Example of a Clinical Trials Dashboard

Here is an example of a Drug Trial Dashboard with actual and targeted cost and trial performance data.

Example of a Clinical Trial Dashboard for Pharmaceutical Companies

Example of a Clinical Trial Dashboard for Pharmaceutical Companies

You can find hundreds of additional examples here

Who Uses This Type of Dashboard?

The typical users of this type of dashboard are: Executives, product managers, clinical trial managers.

Other Reports Often Used in Conjunction with Drug Trial Dashboards

Progressive Financial Planning & Analysis (FP&A) and Clinical Trial departments sometimes use several different Clinical Trial Dashboards, along with detailed program reports, product forecasts, multi-year budgets, KPI dashboards, expense dashboards, expense reports, detailed drug trial reports and other management and control tools.

Where Does the Data for Analysis Originate From?

The Actual (historical transactions) data typically comes from enterprise resource planning (ERP) systems like: Microsoft Dynamics 365 (D365) Finance, Microsoft Dynamics 365 Business Central (D365 BC), Microsoft Dynamics AX, Microsoft Dynamics NAV, Microsoft Dynamics GP, Microsoft Dynamics SL, Sage Intacct, Sage 100, Sage 300, Sage 500, Sage X3, SAP Business One, SAP ByDesign, Acumatica, Netsuite and others.

In analyses where budgets or forecasts are used, the planning data most often originates from in-house Excel spreadsheet models or from professional corporate performance management (CPM/EPM) solutions.

What Tools are Typically used for Reporting, Planning and Dashboards?

Examples of business software used with the data and ERPs mentioned above are:

  • Native ERP report writers and query tools
  • Spreadsheets (for example Microsoft Excel)
  • Corporate Performance Management (CPM) tools (for example Solver)
  • Dashboards (for example Microsoft Power BI and Tableau)

Corporate Performance Management (CPM) Cloud Solutions and More Examples