The BSS Dashboard has been introduced as a tool for providing a fast, accurate, effortless, and user-friendly overview of your business's performance with meaningful statistics such as metrics, KPIs, and other relative data. The tool's purpose is to reduce the business operational costs, eliminate the wrong assumptions of their revenue projections, minimize the risk of missing critical information, and assist in important business decisions/activities. Overall, this tool provides the user with a complete business productivity-improving dashboard while they retain their focus on managing more efficiently their business. When the user logs in the BSS platform with his credentials, the tool becomes available on the home page of BSS instead of the current calendar view.

Dashboard Currency

The dashboard's amounts and currency signs are being displayed based on the predefined organization's currency, found under the "Organization Profile". However, for each following widget, we may take different exchange rates into consideration. More specifically:

For the "General Statistics" widget: We always take into account the current rate between these currencies, and ignore historic data of exchange rates for this widget. This applies to all metrics in this widget whose data stem from invoices.
For the "Product Mix" widget: We take into account the exchange rate between these currencies for the invoice date of the specific invoice, so we first look into the historical data of the currency rate, then we look for whether there is a record of the exchange rate that includes the specific invoice date, and if there is, we make use of that exchange rate. If there are no historical data for this exchange rate for the specific invoice date, we take into account the current exchange rate.

Dashboard Widgets

Dashboard widgets are essentially the tools for graphically depicting the most vital information of all the statistics, metrics and KPIs from the BSS platform, in such a way that you can obtain fast all the information required for assisting you in your business management and activities.

A drop-down menu exists on the upper right corner of the BSS dashboard page, through which the BSS user has the capability to set the time range of all the charts where this is applicable (see "clock" icon) and view their current time range. The data of each widget will get updated accordingly.

By default the option "This Month" is selected on the time range. Upon clicking on the arrow next to the default choice, a drop-down menu shall open with the following fixed options for the time range:

This Month (default): The current calendar month up to the current date.
Last 3 Months: The past three consecutive months, meaning the current month plus the past two months.
Last 6 Months: The past six consecutive months, meaning the current month plus the past five months.
Last 12 Months: The past twelve consecutive months, meaning the current month plus the past eleven months.

General Statistics (of Organization) WIDGET

The General Statistics widget provides the BSS user with several statistics of their organization and consists of many metrics such as: Monthly Recurring Revenue, Monthly Revenue, New Resellers this month, Total Resellers, Total Customers. This widget is not time-dependent, since some of its metrics already refer to a specific time range, such as "This month" and some refer to the current state. Let us further analyze the following image:

Monthly Recurring Revenue

The first metric displayed is the "Monthly Recurring Revenue"(MRR), i.e. the costs that resulted from selling recurring products (i.e. products that create subscriptions) during the current month, up to the current date for all the accounts of the BSS user's organization. We consider the debit & credit invoices whose status is either "Paid" or "UnPaid" and only the invoice items that create recurring subscriptions. More specifically, we will consider the final price of each invoice item and multiply it with its quantity. We do not consider taxes, cancelled invoices, proforma or pending invoices at all. If the resulting amount is negative, it is displayed with its negative value.

Metric's Availability: The Monthly Recurring Revenue metric may not be visible if the BSS user has disabled the "Invoices" section on their settings.

Monthly Revenue

The second metric displayed is the "Monthly Revenue"(MR), i.e. the costs that resulted from selling products during the current month, up to the current date. We consider the "total before tax" amount (as seen on BSS) displayed on the debit & credit invoices, whose status is either "Paid" or "UnPaid". We do not consider taxes, cancelled invoices, proforma or pending invoices at all. For the calculation of monthly revenue, we sum the "total before tax" amounts found on the debit invoices and we deduct the sum of all the "total before tax" amounts found on the credit invoices. If the resulting amount is negative, it is displayed with its negative value.

Metric's Availability: The Monthly Revenue metric may not be visible if the BSS user has disabled the "Invoices" section on their settings.

New Resellers this month

The third metric displayed is the "New Resellers this month". The amount depicted is the result of the summation of all the accounts that have their creation date in the current month, up to the current date and have the flag "reseller" checked at the current time. If a lite reseller's account is converted into a tenant reseller account, during the current month and up to the current date, shall also be depicted in this metric.

Metric's Availability: The New Resellers this month metric may not be visible if the BSS user has disabled the "Accounts" section on their settings.

Total Resellers

The fourth metric displayed is the "Total Resellers". The amount depicted is the result of the summation of all the accounts that have the flag "reseller" checked at the current time. A tenant reseller that used to be a lite reseller shall be depicted also in this metric.

Metric's Availability: The Total Resellers metric may not be visible if the BSS user has disabled the "Accounts" section on their settings.

Total Customers

The fifth metric displayed is the "Total Customers". The amount depicted is the result of the summation of all the accounts of your direct customers and the end-customers of your reseller.

Metric's Availability:

The Total Customers metric may not be visible if the BSS user has disabled the "Accounts" section on their settings.
Different BSS platform editions see different versions of the BSS dashboard. More specifically, the metrics: "New Resellers this Month" and "Total Resellers" are hidden for BSS organizations if your interworks.cloud edition does not support resellers' management. The platform edition of a BSS organization can be found under: BSS Setup > System Options > Organization Profile section.

Product Mix WIDGET

The Product Mix widget displays by default all the Products that the BSS user (distributor or tenant reseller) has sold in the time range set as slices of a pie-chart, filtered by Product Types and Charge Type, and the percentage of each slice is compared to the percentage of the total sales. Each slice of the pie-chart has a distinct color, which correlates to the legend that is located below the chart, and it is where the mapping of the sliced data occurs. This widget is time-dependent as indicated by the clock icon, located on the upper right corner, and is entirely related to the 88934988 set.

The information for this chart is retrieved from all the debit invoices existing in the current BSS organization, with invoice dates in the specified time range and status "paid"/"unpaid". The tool does not consider canceled or pending invoices for its calculations. It sums the amounts it retrieves for these invoice items on the respective debit invoices, for a given period, and then sums them with the total amount calculated for each product. Concerning the resulted cost from the Azure Usage invoices, we collect the "Final Price" as shown on BSS and this is the value depicted on the product mix.
The BSS user has the option to filter the data' visual representation of the Product Mix pie-chart by utilizing the two drop-down menus located on the upper left corner of the widget:

Product Type: From the first filtering drop-down menu on the upper left corner of the Product Mix widget, the BSS user is able to set the Product Type of the chart and thus change the view of the pie-chart. Other than the "All" filtering option which is the default one, as it depicts everything, more options exist for filtering the Product Mix chart concerning specified Products belonging to certain Product Types:
- Product Type: Once selected, the product mix chart gets redrawn with the corresponding contribution data which consists of Products belonging to the chosen Product Type, during the time range set. As a result, different choices of product types will result in a pie-chart with different products along with their corresponding chart percentage.
Charge Type: From the second filtering drop-down menu on the upper left corner of the Product Mix widget, the BSS user is able to set the Charge Type of the chart and thus change the view of the pie-chart. Other than the "All" filtering option which is the default one, as it depicts everything, there exist two more options of filtering the Product Mix chart concerning the charge type:
- Subscriptions: Once selected, the product mix chart gets redrawn with only the percentages of subscription-based product types/products, regardless of their billing cycle. Such products can be recurring products or products with usage charges.
- One time charges: Once selected, the product mix chart gets redrawn with only the percentages of Non-subscription based product types/products. Such products can be assets and one-off products, created as such on our BSS platform.

Upon hovering over a slice of the pie chart, the BSS user is able to view the respective Product Type/Product, along with its percentage contribution and the non-taxed actual invoiced amount, for the specific time range in comparison to the total. The currency displayed is based on the organization's default currency.

Widget's Availability: The Product Mix widget may not be visible if the BSS user has disabled the whole "Billing" section or the "Invoices" section on their settings.

When the "Invoices" section is checked but the "Products" section is unchecked on settings, the BSS user is still able to see the product mix with the products it comprises of, since the invoices containing the products are available to them.

Subscriptions Churn WIDGET

The Subscriptions Churn widget displays a double bar-chart of the new and canceled subscriptions(not Assets) for all or specific Vendors that the BSS user (distributor or tenant reseller) has sold in the time range set. The bar-chart consists of two axes, the horizontal being the time range(daily or monthly depending on the choice of options) and the vertical being the absolute number of subscriptions. For each unit of time depicted, two bars are displayed next to each other, representing the new subscriptions in blue color and the canceled subscriptions in orange color. The numbers displayed on the vertical axis shall be adjusted based on the min/max values of the minimum and maximum values of the new and cancelled subscriptions for the time range selected via the central time range drop-down menu, since this widget is time-dependent as indicated by the clock icon, located on the upper right corner. More specifically, when the BSS user has selected to view the central time range for "This Month", the chart will become daily, therefore the horizontal axis will display all the days, whereas if the BSS user has selected either "Last 3 Months" or "Last 6 Months" or "Last 12 Months", the chart will become monthly, therefore the horizontal axis will display all the months included in the time range selected. Once the BSS user selects a Vendor, he is able to view the new and cancelled subscriptions only of the specific Vendor across the time range set. Upon hovering over a bar, the absolute number of the bar is displayed.

The trial subscriptions, as well as the subscriptions that resulted from renewals of older ones, will not be counted in this metric. As cancelled subscriptions, we consider the absolute number of those whose status was set to "Canceled" in that specific unit of time (either day or month, depending on the time range set). These calculations happen on the spot, so that the BSS user can view the current state. We do not consider the subscription quantity for these metrics, only the absolute number of new and cancelled subscriptions.
The BSS user has the option to filter the data' visual representation of the Subscriptions Churn bar-chart by utilizing the drop-down menu located on the upper left corner of the widget, regardless of whether they belong to a specific Vendor or not:

Vendors: From the first filtering drop-down menu on the upper left corner of the Subscription Churn widget, the BSS user is able to set the Vendors that stem from the new/canceled subscriptions with created/cancellation date in this time range, titled after the respective Vendor names, as they appear on our BSS.
1. This drop-down menu will have a value for each auto-provisioned service, such as: "Panda", "GSuite", "Acronis" and "Kaspersky".
2. For the non-provisioned services, the drop-down menu has a general value named "Other subscriptions" which contains all the subscriptions from product types that are manually created inside the BSS.

Widget Availability: The Subscriptions Churn widget may not be visible if the BSS user has disabled the whole "Billing" section or the "Subscriptions" section on their settings.

Expiring Subscriptions WIDGET

The Expiring Subscriptions widget provides the BSS user with a view of the top fifty (50) active subscriptions (along with their respective data) with annual or lengthier billing cycles, that are expiring in thirty (30) or fewer days, regardless of whether they are automatically renewed or not. This widget is not time-dependent, since its metrics already refer to a specific time range. Let us further analyze the following image: