Customized Widgets on the Dashboard
Why a Customized Widget Dashboard?
On the home screen (Dashboard), MSPCFO provides a quick glance at relevant information. These snippets of information, or widgets, provide a quick look at actionable items. Currently there are over twenty widgets available.
The standard dashboard is entitled 'Hello World' which is accessed by clicking on the first pull down entitled Dashboards and will be the MSPCFO landing page for a user who has not set up additional dashboard(s) under the second tab My Dashboards. As soon as a custom dashboard is created by a user, the new dashboard will become the MSPCFO landing page.
The My Dashboard tab allows every user of MSPCFO to customize one or more dashboards. For example at the end of the month, the user might want to look at something different than in the middle of the month. The user could have an End of Month dashboard and a Mid-Month dashboard. Each widget can be sized to take up more or less space on the dashboard.
Cloning a Dashboard for another User
Custom Dashboards that are created under the My Dashboard tab belong to the user who creates them. The user can also clone a dashboard for another user by clicking on the Clone Dashboard icon.
After you click on the Clone Dashboard icon, the above table will open and allow you to clone any dashboard for an active user of MSPCFO. You can select one user at a time.
Sample Dashboards
Sample 1 - Month End Dashboard - An end of month dashboard that gives a snapshot of action items to be aware of going into the next month.
Sample 2 - Mid-Month Dashboard - A look at the company at mid-month to see which clients need more attention and which clients are already ahead in their labor consumption for the month.
(Note: At mid-month, For FFA Monthly Tracking, the greatest concern is the over-utilizers at this point of the month, only look at Quintile 1.)
Sample 3 - Long Term Trends - A look over the past 6 months which examines trends in revenue, efficiency, and profitability.
Sample 4 - Tickets - Some of the areas of ticket analysis that need to be addressed.
Options for the Custom Dashboard
PAGE CONTOLS
After clicking on the Add Dashboard option, you have the ability to (1) add a widget from the list of widgets provided; (2) customize the dashboard (see below); (3) save the file; (4)delete the custom dashboard; (5) download to an Excel file; (6) download to a PDF file; or (7) download to a CSV file.
CUSTOMIZE THE DASHBOARD
WIDGET CONTROLS
Within each widget, to the right of the widget name, you can (1) change filters; (2) expand the widget to take up the entire screen; (3) download the individual widget to PDF, Excel; or CSV files; or (4) delete the specific widget from the custom dashboard.
SIZING THE WIDGET
The customized dashboards have the feature of sizing and positioning each of the widgets on the screen. To size the widget, click on the bottom right corner of the widget (highlighted in yellow below) and change the size. To move the widget to a new position, click on the title of the widget to change position.
Selecting a Widget
There are over two dozen widgets provided. Most have filters to customize. When you click on "+Add Widget" the widgets can be selected from the images. The widgets are grouped by:
CONCENTRATIONS
Value of the report: The chart gives an indication of the most profitable agreement categories over time.
The pie chart of the agreement margins for agreement categories over a period of time.
Pie chart shows % of total gross margin (contribution) over time of each agreement category. The values include labor and product within agreements.
Mouse-over on each segments shows total agreement monetary margin.
Value of the report: The report shows the distribution of agreement labor revenue over a period of time. It also shows the average Efficiency of each agreement type. This is a good measure of comparison for the different agreement categories.
The widget shows a pie chart with the concentration of labor revenue by agreement type for the given time period.
Pie chart shows % of labor revenue in each agreement category. The values include labor and product within agreements.
Mouse-over on each segments shows revenue and average efficiency.
Value of the report: The report ranks clients by a specific data point to show the outliers as well as the average clients depending on the ranking value.
The Client Segments Report allows ranking of clients by any one of the listed columns of information in the chart. The clients are aggregated into five quintiles or segments ranked from lowest (quintile 1) to highest (quintile 5). The quintile can be expanded by clicking on the '+' to see clients within the segment.
The filters are the same as in the Client Segments report. For a more detailed explanation of the line items in the Client Segments report and its filters click here.
The widget shows a pie chart with the concentration of all revenue (labor and product) by agreement type.
Mouse-over on each segments shows total revenue for the agreement type.
Value of the Report: The chart shows the concentration of recurring revenue of your ten largest clients. The value is in knowing which of your largest clients provide the most ongoing revenue to your business. The filter allows a view of labor and product or labor only.
The pie chart shows the monthly recurring revenue of the ten largest clients over a period of time. A mouse-over the segments shows the actual recurring revenue.
The value of the revenue is shown when you mouse over the client's segment.
EFFICIENCY
Value of the report: The report shows which clients are taking longer to service per endpoint/node (by the threshold %) for the past 30 days than they did on average for the trailing six months.
The widget shows the change in time spent servicing an endpoint or node (in minutes) for the past 6-month average as compared to the trailing 30 days.
Results can be in chart format or table format depending on the filter:
Value of the report: The report indicates which of the values listed contributes to a high or low efficiency.
The Efficiency Components widget deconstructs the values that go into the efficiency calculation:
- Hours Per Node
- Revenue per Node
- Effective Rate
- Shadow Billable
by looking at endpoints (nodes), tickets and hours which are components of the Efficiency.
The filters are the same as in the Efficiency Components report. For a more detailed explanation of the line items in the Efficiency Components and its filters, click here.
Below is an example of one of the components - Hours Per Ticket. The graph compares the client (one client, an aggregate, or all clients depending you the filter) in the blue line to the average top, median, and low of the whole range of clients.
Value of the report: The report is a view of how many hours are being delivered for an agreement vs. expectations.
By using the target effective rate (set in the Lookup/Options table) or a customized rate for selected companies or types of agreements (set in the FFA/Monthly Tracking report), the target hours for each client on a monthly basis are identified (target hours = agreement labor revenue for the month/target hours). When sorted by Delta Hours, the clients with negative hours are over utilizing and the ones with positive hours are not using the hours they are paying for.
The filters allow you to refine the settings. An explanation of the filters can be found in the report FFA/Monthly Tracking.
The report is a bar chart that can be sorted by any of the three bars: hours, target, delta. In the example below, the chart is sorted on Delta Hours. The clients to the left are over-utilizers and the ones to the right are not using all of the hours of labor they are paying for. If more detail is required, the FFA/Monthly Tracking report should be examined.
REVENUE
Value of the report: The report shows clients that are declining in their total profitability (excluding projects) over the past six months.
The widget compares the contribution/hour of the current closed month to the trailing 6-month average and reports on a % decline that is set in the fiter. For example if the filter is set to 25%, the value for last month would be 25% below the average for the past 6 months.
Results can be in chart format or table format depending on the filter:
Value of the report is to show trends for one of the line items in the Client P&L over a period of time.
The bar chart is a view over time of any line item in the Client P&L report. The widget can be filtered on date scope (Current Month; Previous Month; Year-to-Date; Trailing 3 Months; Trailing 6 Months; or Trailing 12 Months) and line item. One specific line item from the Client P&L can be highlighted in the chart. The last bar is an average value for the time period.
The format of the chart can be either line or bar. For the bar or line chart, the revenue is shown for each month when you mouse over the bar or data point on the line.
For a more detailed explanation of the line items in the P&L/Client click here.
Value of the report: To inform you when there has been revenue generated that needs to go on an invoice or be written off, but has not.
The Company un-invoiced Labor shows the amount of revenue that has not gone on an invoice. This would be actual rate time, overages to agreements, and projects where the time record must be on an invoice to be included in revenue, but the invoice has not been created or has not been 'sent'. The filter allows for a range of months and either the report can be in chart format or table format.
The report can be viewed in graph format or table format.
Value of the Report: The report shows on a monthly basis the margins or contribution for specific categories of business (labor revenue, product revenue, project product revenue).
The widget shows the % margin by work type (MRR Margin; T&M Labor Margin; MRR Product; T&M Product; Project Product) for each of the last six months.
Example below for the month of August: margin on the recurring agreement labor = 56%; labor revenue for straight time was less than the cost showing -9% margin; agreement products had a 26% margin; products sold outside of an agreement or project had a 18% margin; no project products were sold (looks like 100% margin).
Value of the Report: The report shows on a monthly basis how much margin is left from recurring revenue minus recurring costs.
The widget shows how much revenue is left for overhead each month. The recurring components of revenue and costs are calculated as follows:
Recurring Revenue:
- FFA labor,
- L&S products,
- FFA additions (products)
Recurring COGS:
- All labor COGS (all labor is included because you are paying for members no matter what they do)
- L&S products
- FFA additions (products)
Every other form of revenue and costs (projects, T&M) is variable per month. What is left covers your overhead.
Value of the report: The report provides a way to analize recurring revenue over a period of time for growth (either positive or negative) in current agreement clients, as well as new and lost recurring clients. The widget gives the monetary change. For more detail on the clients who have caused this change, go to the Revenue Report.
The Monthly Recurring Revenue consists of four components that cause a change in monthly revenue for two periods of time (ie. last month to this month; six months ago to this month, etc.) The widget can be filtered on: 1) all recurring revenue; 2) labor recurring revenue; or 3) product recurring revenue.
The four components considered are:
- New MRR Clients $
- Lost MRR Clients $
- Change in $ Growth of Existing Clients
- Change in $ Contraction of Existing Clients
Totals for Growth, Decline and Net Growth/Decline are also calculated.
The widget gives a summary view of the components of MRR that have caused MMR $ to either expand or decline in the previous closed month.
For a more detailed look at the recurring revenue, go to the Revenue report.
In the example below, an individual client was selected in the filter.
For a more detailed report, look at the Revenue report.
Value of the report: The report show how the non-recurring revenue (non-agreement revenue) for this month compares with the non-recurring revenue in prior months. Note: Good to look at this report after the 20th of the month.
The widget shows you for the current month, the non-recurring revenue as compared to the average non-recurring revenue over the past six months.
Value of the report:
Value of the report: On a week to week basis, the widget shows where you have given the client too little support over the past seven days.
Most MSPCFO reports look at revenue and costs on a monthly basis. This widget looks at the trailing seven days to determine if there is a surplus in the prorated portion of the agreement revenue as compared to the last seven days of shadow billable. This widget looks at Sunday thru Saturday of the las week.
A filter allows you too put in a currency threshold so that only values outside the threshold are considered.
TICKETS
Value of the report: Ability to track the evolution of one Issue Type Benchmark performance over time.
The report filters on one or more issue type benchmark. The list of benchmark issues is in the pull down filter. The filter allows you to look at all issues over time, a single issue (i.e. Firewall issues) or multiple issues (i.e. Workstation Change, Workstation Connectivity Issue, Workstation Performance).
The filters allows for
1. A date range;
2. Selected boards;
3. A specific report: Time Spent, Time to Resolution, First Touch Resolution;
4. One or more Issue Types
The chart shows in the bars, black bars above the zero where it takes less time for the MSP in the time period than the universe of MSPs, or a red bar where it is taking more time.
Value of the report: To analyze the types of tickets for a selected client (or all clients) over a period of time. Each line represents a unique board/service type/subtype/item combination.
For detailed information about the report go to the Ticket Concentration report: https://mspcfo.screenstepslive.com/s/customer_doc/m/60283/l/1628027-ticket-concentration
Value of the report: Identifies the clients and ticket types receiving significantly more tickets per node and calculates the impact of the excess excess hours, revenue opportunity and EBITDA opportunity.
For detailed information about the report to to the Ticket Count/ Too Many Tickets report:
https://mspcfo.screenstepslive.com/s/customer_doc/m/60283/l/1628970-too-many-ticketsFor
Value of the report: Identifies the clients and ticket types where you are spending significantly more time than other clients and calculates the excess hours, revenue opportunity and EBITDA opportunity.
For detailed information about the report go to the Tickets Take Too Long report:
https://mspcfo.screenstepslive.com/s/customer_doc/m/60283/l/1617461-tickets-take-too-long
Value of the report: To show the amount of work on each configuration identified by the engineer. The report can point out if there is a configuration that has too many tickets, is out of warranty, or is taking too much of the engineers time.
The report filters allow you to look at all configurations or an individual client's configurations over time.
The report lists the different configuration types. Click on the "+" to see the individual configurations. Drill down to a third level with the pie to see the specific clients. In the example below, Config Type 11 has four different configurations. When the pie is opened for Conf. 19153, information about the client and the tickets are shown.
Down load the information for configurations. When you open the pie for the individual clients, there is a download at this level also.
The last line of the report gives the total hours and tickets.
OTHER
Value of the report: The report gives a list of agreements that are nearing their renewal date.
The report lists the clients and specific agreements that are close to their renewal dates.
Value of the report: The report shows when work is done during the week.
The report filters allow you to (1) look at all hours over a date range; (2) Look at all clients or a selected client; (3) Filter on certain work roles or all work roles --- you can choose multiple work roles; and the same with (4) work types..
The report shows the number of hours that have been worked. If you put your mouse over a bar, you can see the number of hours.
Value of the report: The report gives a current view of all projects that will close during the month. You can easily see if a project end date needs to be extended, if the labor revenue needs to be billed during the month, if the shadow billable is too high or too low.
The table shows all of the projects that have an End Date of the current month. The chart shows client, project name, end date, labor revenue (to date), shadow billable (to date) and current efficiency.
The widget gives the user a quick review of the status of each Health Check. An exclamation point in a red circle means there may be some issues and a check in a green circle means there are no issues for this category. Health Checks are a way to verify that the data received from your PSA will be processed correctly in the MSPCFO reports. Click on the Health Check Name to drill into more information.
Value of the report: The line items shows you when MSPCFO thinks there might be a gap or error in the information from CW or when one of the MSPCFO settings needs to be updated.
For more detailed information on Health Checks click here.
0 Comments
Add your comment