Posts

Sales Dashboard for Pharmaceutical Companies

Example of a Sales Dashboard for Pharmaceutical Companies

What is a Sales Dashboard for Pharmaceutical Companies?

Sales Dashboards are considered revenue analysis tools and are used by sales managers and executives to compare sales performance and monitor monthly trends. Some of the main functionality in this type of report is that it provides analysis from eight different perspectives, including: 1) Products rankes by Net Sales and compared to Gross Sales, 2) Monthly trend for Net Sales and Gross Sales, 3) Sales compared by channel, 4) Reach by product, 5) Gross Sales and Net Sales by business unit, 6) Monthly trend in Gross Sales, 7) Product ranked by units sold, and 8) Samples given by product. You find an example of this type of report below.

Purpose of Sales Dashboards

Pharmaceutical companies use Sales Dashboards to provide sales leaders with an easy way to track product performance. When used as part of good business practices in sales and Financial Planning & Analysis (FP&A) departments, a company can improve its revenue strategies and it can reduce the chances that managers react slow to sales issues because of lack of information.

Example of a Sales Dashboard

Here is an example of a Sales Dashboard with comparisons and monthly trends.

Example of a Sales Dashboard for Pharmaceutical Companies

Example of a Sales 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: Executives, Sales Leaders.

Other Reports Often Used in Conjunction with Sales Dashboards

Progressive sales and Financial Planning & Analysis (FP&A) departments sometimes use several different Sales Dashboards, along with sales forecasts, annual budgets, detailed sales reports, profit & loss 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

/by

Executive Dashboard for Pharma Companies

Example of an Executive Dashboard for Pharma Companies

What is an Executive Dashboard?

Executive Dashboards are considered decision support tools and are used by leaders to monitor corporate KPIs. Some of the main functionality in this type of dashboard is that it provides analysis from five different perspectives, including: 1) Top sales producers with ranked gross sales and net sales, 2) Top sales channels, 3) Products ranked by volume, 4) Top payers ranked by net sales, 5) Monthly trend gross sales and net sales. You find an example of this type of dashboard below.

Purpose of Executive Dashboards

Pharmaceutical companies use Executive Dashboards to give senior leaders an easy way to watch performance and trends in core business areas. When used as part of good business practices in Executive departments, a company can improve its strategic decisions, and it can reduce the chances that discussions and related execution are slowed down by lack of available data.

Example of an Executive Dashboard

Here is an example of an Executive Dashboard with KPI rankings and monthly sales trends.

Example of an Executive Dashboard for Pharma Companies

Example of an Executive Dashboard for Pharma Companies

You can find hundreds of additional examples here

Who Uses This Type of Dashboard?

The typical users of this type of dashboard are: CEOs, COOs, CFO’s, board members.

Other Reports Often Used in Conjunction with Executive Dashboards

Progressive Executive departments sometimes use several different Executive Dashboards, along with financial statements, annual budgets, 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

/by

Digital Media Web Analytics Dashboard for Media Companies

Example of a Digital Media Web Analytics Dashboard for Media Companies

What is a Digital Media Web Analytics Dashboard?

Web Analytics Dashboards are considered operational analysis tools and are used by marketing and web-site managers to analyze trends and anomalies in web visitor metrics. Some of the main functionality in this type of dashboard is that it provides monthly trend analysis per online publication. The example has four different perspectives: 1) Average visitor duration, 2) Visitors per traffic source, 3) Pages per visit, and 4) Total visits. You find an example of this type of dashboard below.

Purpose of Web Analytics Dashboards for Digital Magazines

Media companies use Web Analytics Dashboards to get a clear understanding of monthly trends for key visitor metrics. When used as part of good business practices in Digital Magazine departments, a company can improve its content and marketing strategies, and it can reduce the chances that trends in user behaviors go undetected.

Example of a Web Analytics Dashboard for a Digital Magazine

Here is an example of a Digital Media Web Analytics Dashboard with monthly trend data.

Example of a Digital Media Web Analytics Dashboard for Media Companies

Example of a Digital Media Web Analytics Dashboard for Media Companies

You can find hundreds of additional examples here

Who Uses This Type of Dashboard?

The typical users of this type of dashboard are: Marketing Managers, Digital Media Managers, Web Site Managers.

Other Reports Often Used in Conjunction with Web Analytics Dashboards for Digital Magazines

Progressive Digital Magazine departments sometimes use several different Web Analytics Dashboards for Digital Magazines, along with web analytics transaction reports, user analytics dashboards, content 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

/by

User Behavior Dashboard for Media Companies

Example of a User Behavior Dashboard for Media Companies

What is a User Behavior Dashboard?

User Behavior Dashboards are considered statistical analysis tools and are popular with media executives and content managers to help analyze monthly trends in user metrics. Some of the main functionality in this type of dashboard is that it shows monthly subscriber trends from six different perspectives: 1) Total US versus international subscribers, 2) Average views per subscriber, 3) Average total hours streaming, 4) Monthly hours streaming per platform (pc vs mobile), 5) Binge watch users for current year vs prior year, and 6) Users sharing account credentials current year versus prior year. You find an example of this type of dashboard below.

Purpose of User Behavior Dashboards

Media companies take advantage of User Behavior Dashboards to easily detect changes in patterns and monitor declines or improvements in KPIs. When used as part of good business practices in Subscription Sales and Content departments, a company can improve its revenue growth strategies, and it can reduce the chances that managers don’t quickly notice problems and outliers in user metrics.

Example of a User Behavior Dashboard

Here is an example of a Use Behavior Analysis Dashboard with monthly KPI trends.

Example of a User Behavior Dashboard for Media Companies

Example of a User Behavior Dashboard for Media 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, Subscription Managers, Marketing Managers, Category Managers.

Other Reports Often Used in Conjunction with User Behavior Dashboards

Progressive Subscription Sales and Content departments sometimes use several different User Behavior Dashboards, along with churn reports, subscription reports, sales forecasts, profit & loss reports, annual budgets, financial dashboards, KPI dashboards, category 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

/by

Streaming TV Subscriber Dashboard for Media Companies

Example of a Streaming TV Subscriber Dashboard for Media Companies

What is a Streaming TV Subscriber Dashboard?

Subscriber Dashboards are considered user analysis tools and are used by media executives and subscription managers to analyze monthly trends in user metrics. Some of the main functionality in this type of dashboard is that it provides monthly trend analysis from four different perspectives: 1) Current year (CY) and prior year (PY) subscribers by number of countries reached, 2) Paid subscribers added versus churned, 3) Total subscribers CY versus LY, and 4) US versus international subscribers. You find an example of this type of dashboard below.

Purpose of Subscriber Analysis Dashboards for Streaming TV

Media companies use Subscriber Analysis Dashboards for Streaming TV to enable self-service trend analysis for key subscription statistics. When used as part of good business practices in Subscription Sales and Content departments, a company can improve its revenue growth strategies, and it can reduce the chances that managers miss or react slow to important customer trends.

Example of a Subscriber Analysis Dashboards for Streaming TV

Here is an example of a Streaming TV Subscriber Analysis Dashboards with monthly trend charts.

Example of a Streaming TV Subscriber Dashboard for Media Companies

Example of a Streaming TV Subscriber Dashboard for Media 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, Subscription Managers, Marketing Managers, Category Managers, Budget Managers.

Other Reports Often Used in Conjunction with Subscriber Analysis Dashboards for Streaming TV

Progressive Subscription Sales and Content departments sometimes use several different Subscriber Analysis Dashboards, along with recurring revenue forecasts, recurring revenue dashboards, churn reports, subscription reports, sales forecasts, profit & loss reports, annual budgets, financial dashboards, KPI dashboards, category 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

/by

Category and Listener KPI Dashboard for Media Companies

Example of a Category and Listener KPI Dashboard for Media Companies

What is a Category and Listener KPI Dashboard?

Category and Listener KPI Dashboards are considered statistical analysis tools and are used by media executives and content managers to analyze monthly trends in user and content metrics. Some of the main functionality in this type of dashboard is that it provides monthly trend analysis from six different perspectives: 1) Current year (CY) and prior year (PY) by number of countries reached, 2) Average daily listening (minutes) by desktop and mobile device, 3) Total users versus paid subscribers, 4) Monthly listeners by genre, and 5) Total songs and number of songs added per day. You find an example of this type of dashboard below.

Purpose of Category and Listener Dashboards

Media companies use Category and Listener Dashboards to give managers a clear picture of monthly trends and seasonality as it relates to streaming users and available content. When used as part of good business practices in Subscriber Sales and Content departments, a company can improve its marketing and category strategies. It can also reduce the chances that underperforming  subscriptions or categories go under the radar that otherwise would be evident looking at trend charts.

Example of a Category and Listener Dashboard

Here is an example of a Music Category and Listener Metrics Dashboard with six monthly trend charts and comparative data.

Example of a Category and Listener KPI Dashboard for Media Companies

Example of a Category and Listener KPI Dashboard for Media 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, Content Managers, Marketing Managers, Category Managers, Budget Managers.

Other Reports Often Used in Conjunction with Category and Listener Dashboards

Progressive Subscriber Sales and Content departments sometimes use several different Category and Listener Dashboards, along with recurring revenue forecasts, recurring revenue dashboards, churn reports, subscription reports, sales forecasts, profit & loss reports, annual budgets, financial dashboards, KPI dashboards, category 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

/by

Streaming Radio Subscriber Dashboard for Media Companies

Example of a Subscriber Dashboard for streaming radio media companies

What is a Subscriber Dashboard?

Subscriber Dashboards are considered statistical analysis tools and are used by streaming radio media executives to analyze monthly trends in subscriber metrics. Some of the main functionality in this type of dashboard is that it shows monthly trends for six different KPIs, including: 1) Current year (CY) and prior year (PY) subscriber reach by number of countries, 2) Comparison of number of added and churned subscribers per day, 3) Total users versus paid subscribers, and 4) Paid subscribers versus free subscribers. You find an example of this type of dashboard below.

Purpose of Subscriber Analysis Dashboards for Streaming Radio

Media companies use Subscriber Analysis Dashboards for Streaming Radio to provide a self-service tool to closely monitor monthly trends in the most essential subscriber metrics. When used as part of good business practices in Subscriber Sales and Media departments, a company can improve its marketing and product strategies, and it can reduce the chances that subscriptions underperform due to lack of timely and informed management decisions.

Example of a Subscriber Dashboard for Streaming Radio

Here is an example of a Subscriber Analysis Dashboard with streaming radio metrics and monthly trends.

Example of a Subscriber Dashboard for streaming radio media companies

Example of a Subscriber Dashboard for streaming radio media 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, Content Managers, Marketing Managers, Category Managers, Budget Managers.

Other Reports Often Used in Conjunction with Subscriber Dashboards for Streaming Radio

Progressive Subscriber Sales and Media departments sometimes use several different Subscriber Dashboards, along with recurring revenue forecasts, recurring revenue dashboards, churn reports, subscription reports, sales forecasts, profit & loss reports, annual budgets, financial dashboards, 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

/by

Print Circulation Dashboard for Media Companies

Example of a Print Circulation Dashboard for Media Companies

What is a Print Media Circulation Dashboard?

Print Media Circulation Dashboards are considered operational analysis tools and are used by media executives to monitor circulation variances and compare metrics. Some of the main functionality in this type of dashboard is that it displays KPIs from four different perspectives: 1) Current year (CY) and Prior year (CY) Press Run metrics by publication, 2) CY versus PY average paid distribution by publication, 3) Average controlled distribution by publication, and 4) Average paid digital distribution by publication. You find an example of this type of dashboard below.

Purpose of Print Media Circulation Dashboards

Media companies use Print Media Circulation Dashboards to give managers an easy way to see how each of their publications perform as compared to the prior year metrics. When used as part of good business practices in Media and Publication departments, a company can improve its marketing and product strategies, and it can reduce the chances that subscriptions fall due to lack of timely information to drive important management decisions.

Example of a Print Media Circulation Dashboard

Here is an example of a Print Media Circulation Dashboard for year-over-year comparisons.

Example of a Print Circulation Dashboard for Media Companies

Example of a Print Circulation Dashboard for Media 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, Publication Managers, Marketing Managers, Sales Managers, Budget Managers.

Other Reports Often Used in Conjunction with Print Media Circulation Dashboards

Progressive Media and Publication departments sometimes use several different Print Media Circulation Dashboards, along with sales dashboards, sales forecasts, consolidating profit & loss reports, annual budgets, financial dashboards, 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

/by

Brand Analysis Sales Dashboard for Media Companies

Example of a Brand Analysis Sales Dashboard for Media Companies

What is a Brand Analysis Sales Dashboard?

Brand Analysis Dashboards are considered sales and marketing monitoring tools and are used by managers to compare different perspectives of sales performance to historical data. Some of the main functionality in this type of report is that it displays metrics graphically from for different perspectives: 1) Current year (CY) versus prior year (PY) revenue by company, 2) CY versus PY revenue by media service, 3) CY versus PY revenue by offering type, and 4) CY versus PY quantity (e.g. subscriptions) sold. You find an example of this type of report below.

Purpose of Brand Analysis Sales Dashboards

Media companies use Brand Analysis Sales Dashboards to easily review sales performance from a product offering viewpoint. When used as part of good business practices in Sales and Financial Planning & Analysis (FP&A) departments, a company can improve its revenue growth strategies, and it can reduce the chances that managers’ brand-and product-related decision-making is slowed down because of lack of metrics.

Example of a Brand Analysis Sales Dashboard

Here is an example of a Brand Analysis Sales Dashboard with year-over-year comparative data.

Example of a Brand Analysis Sales Dashboard for Media Companies

Example of a Brand Analysis Sales Dashboard for Media Companies

You can find hundreds of additional examples here

Who Uses This Type of Report?

The typical users of this type of report are: Executives, VP of Sales, Product Managers, Marketing Managers, Sales Managers, Budget Managers.

Other Reports Often Used in Conjunction with Brand Analysis Sales Dashboards

Progressive Sales and Financial Planning & Analysis (FP&A) departments sometimes use several different Brand Analysis Sales Dashboards, along with sales dashboards, sales forecasts, consolidating profit & loss reports, annual budgets, financial dashboards, 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

/by

RGU Sales Dashboard for Media Companies

Example of an RGU Sales Dashboard for Media Companies

What is an RGU Sales Dashboard?

Revenue Generating Unit (RGU) Dashboard are considered sales and subscription analysis tools and are used by sales and product managers to analyze metrics related to the subscribers that are producing revenue for the business. Some of the main functionality in this type of KPI report is that it provides analysis of RGU metrics from five different perspectives: 1) Revenue comparison by media company (subsidiary), 2) Monthly trend in Added RGUs, 3) Monthly trend in churned RGUs, 4) Monthly trend in Total RGUs, and 5) Sold quantity by media company comparative group. You find an example of this type of KPI report below.

Purpose of RGU Analysis Dashboards

Media companies use RGU Analysis Dashboards to give managers an easy, self-service way to quickly see trends and comparative RGU data. When used as part of good business practices in Sales and Financial Planning & Analysis (FP&A) departments, a company can improve its revenue growth and customer retention strategies, and it can reduce the chances that managers make slow or no decisions due to lack of clear RGU data.

Example of a RGU Analysis Dashboard

Here is an example of a RGU Sales Dashboard with monthly trend analysis and business unit comparisons.

Media – RGU Sales Analysis

You can find hundreds of additional examples here

Who Uses This Type of KPI report?

The typical users of this type of KPI report are: Executives, VP of Sales, Sales Managers, Budget Managers.

Other Reports Often Used in Conjunction with RGU Analysis Dashboards

Progressive Sales and Financial Planning & Analysis (FP&A) departments sometimes use several different RGU Analysis Dashboards, along with churn reports, subscription reports, sales forecasts, consolidating profit & loss reports, annual budgets, financial dashboards, 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

/by