Analysis Grid (AG) Reports Overview – Executive Briefing Service

Speed up Cash Flow in your MSP Practice

Running an MSP (Managed Service Provider) is a challenging task. There are so many things that you need to pay attention to: Sales Pipeline, Customer Satisfaction, Engineering Productivity, and more. Today we’re going to focus on a topic that usually is not on the “top” of the priority list until it becomes a problem: Cash [...]
Read more
Find the Margin Problems

Last time we talked about the importance of Leadership to the success of your MSP practice. We suggested that the first step in leadership is to “formulate a desired direction, trajectory or destination”. Today we begin that process by looking at the most fundamental outcome of your business activities: MARGIN. Margin (a la New Haven) [...]
Read more
MSP Leadership

Success has many facets, but the most important one? Leadership. Leadership (a la New Haven) formulate a desired direction, trajectory or destination effectively communicate and engage your organization towards that common objective actively encourage and enable successful execution of the designated plan In future posts, we’ll be discussing each of these components of Leadership, with [...]
Read more
Reward Engineers for Revenue They Directly Affect

Last time, we looked at simplifying your sales management process. This time, we’d like to focus on: How do I REWARD my MSP Engineers for the Revenue that they directly impact? It can be difficult to provide an “objective” incentive plan for your MSP engineers, especially since they may work on a variety of different [...]
Read more
Simplifying Sales Management

What are the the areas that will drive success in your business this year? None is more important (and perhaps more misunderstood) than SALES. How can I manage my sales team given that I have almost NO time left in the day to manage them? Let’s face it: A bunch of us got into the [...]
Read more
Simplify ConnectWise Time Entry

What’s the #1 issue that most MSPs struggle with? Accurate “Time Entry” in ConnectWise. Can I SIMPLIFY ConnectWise Time Entry? You need to KNOW where your engineers are spending their time, even if your clients are all “flat-fee fully managed” clients? Why? Without an accurate idea of how much engineering time is being consumed to [...]
Read more
ConnectWise Reporting Tools Overview

To build the success of your MSP Practice, you need to have access to relevant information to make the right decisions for your business. There’s a variety of ways to get information out of ConnectWise, so a key question you need to answer is: What reporting tools are available for ConnectWise? How do I pick [...]
Read more
Saving Time by PREVENTING Time Entry errors

Being successful with your MSP practice is a balance of being “effective” (i.e. doing the “right” thing) and being “efficient” (i.e. “doing things right”). Today we’ll focus on boosting “efficiency” by streamlining business practices that may not be “fun”, but that HAVE to be done for your MSP practice: How much time/effort/cost could I save [...]
Read more
KPIs to motivate your MSP Engineers

Our focus in this discussion is: How can I motivate my MSP engineering team? What are some of the KPIs (key performance indicators) that I might want to consider including in that process? Keeping your MSP (managed services) engineering team focused on doing the ‘right’ thing is important, but also can be quite a challenge. [...]
Read more
How do I MAKE my engineers report their time?

Last time, we looked at MSP clients that might be “at risk” due to lack of attention. This time, we’d like to focus on: How do I MAKE my engineers report their time? My MSP clients pay me the same “flat fee” every month, so why does it matter if my engineers report their time? [...]
Read more

Home
Uncategorized
Analysis Grid (AG) Reports Overview

Recent updates to the Executive Briefing Service have introduced a new style of report called “Analysis Grid” reports. Analysis Grid reports are designated via the addition of “(AG)” to the end of the name of the report on the EBS menu. Analysis Grid reports allow you to customize the report to suit your own needs, and the “Bookmark” feature of EBS allows you to save those customizations as a Bookmark for one-click retrieval of your report. Here’s a quick introduction to Analysis Grid (AG) reports:

When you first open an Analysis Grid report (designated as such with “(AG)” at the end of the name of the report on the EBS menu, you’ll see data displayed in a table format. Above the report table you will see a series of buttons which allow you to customize the display of the report to your needs.

We’ll take a look at each of the Analysis Grid buttons, starting with the FILTER button (since it is the most-used):

FILTER button

The filter lets you reduce the displayed data so that you see only the records that you are interested in seeing. Click the FILTER button, select the field that you want to “filter” on, the condition and the value for the filter.

For many “Filter Column” fields, you can display the matching values to pick from by clicking the “…” button to the right of the VALUE pop-up menu.

Once you are done, click the “Add” button and your filter will be applied to the displayed data.