Full Sail Partners Blog | Business Intelligence (2)

Seeing is believing, and with Entrinsik Informer, many different types of professional services firms already have the ability to quickly visualize and analyze data to make informed business decisions. Informer, a highly ranked business intelligence (BI) solution, allows users firmwide to create customized dashboards and easily drill down into the data pertaining to their specific department and role to find the answers to questions or get status reports on areas of concern.

So much insight can be gained already using Informer. However, with the latest release of Entrinsik Informer 5.4, employees at professional services firms now have new and improved features to improve data visualization.

Enhancements with Informer Template Creation

Templates are an exciting new feature in Informer 5.4. Templates are custom formatted outputs using HTML coding. This allows total pixel-perfect control over the end product. The template code is in HTML, but being an HTML expert is not required. Many users of the Informer business intelligence tool have little or no HTML experience when they first start. Some even creating a template in less than a day.

Using the data that resides in a firm’s Deltek Vision or Vantagepoint system, firm employees are able to customize the final output into almost any format. The first step is to get the data organized into datasets so that it is easily available for the template. Then it is simply creating the template in the format the user wants.

Within the template, logical formulas can be applied. For example, if the invoice on an accounts receivable (AR) statement is past due, it can be shown in yellow highlight, or if survey is checked in an opportunity, specific survey language can be inserted into the agreement that is being sent to the client.

Additionally, users will be able to create a CSS (Cascading Styles Sheet) for templates to standardize the firm’s output and have logos readily available. Even more, there is also a way to save those commonly used expressions, so it is not necessary to retype every time.

Some of the uses for the templated output are:

• Client Agreements
• Compensation Reports
• Financial Reports
• Project Status for Clients
• AR Statements
• Custom Invoices
• Governmental Reporting (DOT reports)

Once a templated output is set up, it is repeatable and can be shared firm-wide with the appropriate staff.

New Ways to Look at Data

Informer 5.4 also offers different ways to visualize data. Within the Informer 5.4 visuals tab, new visualization charts are available, heat maps and spider charts, which allow fresh perspectives to analyze important data.

A heat map is a graphical representation of data where values are guided by color accent with the deeper the shade, the higher the value. Heat maps are a great way to see concentrations in the data and are really useful if there is a lot of data to manage. In this example, at first glance, the color variations easily indicate the different values and can guide evaluation.

A spider chart, by comparison, is a helpful way of showing outliers. For example, a spider chart may show employees with the highest or lowest utilization. By viewing the chart, it is apparent that Mary Best is exceeding her utilization target, while Michelle Beien, Moshen Farsi, Leia Skywalker and Geoff Smith are not.

See More than Before with Informer 5.4

The Entrinsik Informer 5.4 release was developed to improve how users can take their BI further and visualize their data so that better and quicker decisions can be made. With this newest release, users of Informer across the firm will have even better options for visualizing their data. And, going into the future, as BI needs continue to evolve so will Entrinsik Informer to meet them.

In the professional services industry, reporting is key. The common complaint amongst professionals is they don’t have time to analyze the data, since they need to just get the job done. Time is always of the essence, but true efficiency incorporates being proactive and taking the time to evaluate the data and determine what to pay attention to or worry about. This is where exception reporting comes into play. 

Many times, though, professionals aren’t really aware of the robust capabilities of exception reporting and how it can save firm leaders and employees valuable time. Oddly, there seems to be some disconnect about the real benefits of exception reporting to their firm’s bottom line.

What is Exception Reporting?

Simply put, exception reporting can indicate a red flag to a business. Within the professional services industry, it is especially important to receive exception reporting related to projects and people. An exception report can be a report, alert and/or dashpart that notifies a user, department, or business about data that is outside of a defined expectation of what is typically acceptable. This notification indicates action should be taken. With an ERP or business intelligence system, exception reporting can be programmed to highlight parameters of values that appear outside of a defined criteria range. 

Why Use Exception Reporting?

With growing professional services firms, the more projects a firm wins, and the more employees hired, means managing more projects and employees. Anyone in the professional services industry knows that there is no such thing as a perfect project. Whether managing projects or employees, it’s important to know what needs closer attention and when to adjust a project or processes. With the ebb and flow of projects and availability of resources, those adjustments can come at any time. When done right, exception reporting can ensure a firm is addressing potential problems or weaknesses before they wreak havoc on the bottom line. 

What Are Examples of Exception Reporting for Professional Services Firms?

Exception reporting can be simple or more in-depth for professional services firms. Below are some examples of the most commonly used exception reports along with some that are less common, but highly effective within the professional services industry.

Identify Unsubmitted Timesheets with Ease

Having timesheets completed on time allows for timely billing and improved cash flow. Additionally, having the ability to list the staff who have worked less than expected hours for a selected time period lets managers know who to focus their efforts on and helps avoid mass emails to the entire company. Below is an example within Deltek Vantagepoint. Managers can identify which of their employees need to receive notifications or reminders and can quickly send one. Accounting and principals will also find it helpful to know which managers are underperforming. Additionally, business intelligence tools, like Entrinsik Informer, can provide insight in a visual way to alert those department managers who have the most employees slacking on their timesheet.

Draw Attention to Accounts Receivable (AR) at Risk

Accounts receivable “at risk” refers to the likelihood that a client or project is beyond the expected timeframe. For some firms, this may be 45 days and others may deem more than 60 days as being unacceptable. The longer the DSO (days sales outstanding) cycle, the more likely a business is offering credit to its clients. The longer the bill goes unpaid, the more likely a firm may not collect 100 percent of what is owed. Providing accounting, project managers and principals a list of “at risk” accounts allows a firm to focus just on those that are beyond the normal threshold. 

A project manager might be managing 50 projects. With an exception report, the PM can quickly see that they have 10 projects that need attention related to AR. For accounting and principals, an exception report may be one showing which project managers, principals or divisions have the most AR “at risk” to narrow down individuals or groups that need further attention.  

Resource Allocation Balancing

Another example of an exception report is one providing management information to demand the resources they need. With a resource allocation report for a project-based business, it outlines competing priorities required to execute on projects. It provides those overseeing projects the ability to determine who is over and underutilized allowing them to readjust those out of balance to maximize the effectiveness of the firm’s resources.

Spotting Projects in Trouble

A projects in trouble report is another exception report that identifies variances from the plan or project data. This type of report identifies the reason(s) a project may potentially be in trouble. The Blackbox Connector for Entrinsik Informer has an out-of-the-box BI reporting solution that can report on common reasons a project may be in trouble and includes:

• Over budget or approaching budget
• Low gross margin ratio percentage
• AR is at risk or getting old
• Percentage of time used is beyond expected days
• Actual hours exceed budget
• Low expected revenue
• Project past expected completion date
• No current activity

Project Feedback to Manage Expectations

Listening to feedback from clients about a project is essential to ensure project success. Projects require adjustments along the way and the best way to ensure a project is meeting client expectations is to provide a method for clients to provide quick feedback. The most effective method for professional services firms we have seen is the Client Feedback Tool by Client Savvy. This electronic feedback is quick, effective, and provides indicators when someone records a low score. As a result, an exception report alerts the team and leaders that follow-up is required, and potential mentoring of their employees is needed.

Reduce Employee Turnover with a Burnout Report

In professional services firms, a commonly used phrase is “our employees are our greatest asset.” This is true for so many reasons as they are often the primary contact with our clients. They also have the project knowledge as well as the technical skills required for project success. Having to replace an employee on a project costs time and money and can potentially result in a poor product or project delays. Ensuring that employees are maintaining a work life balance goes a long way to keeping productive staff. Providing executives and managers an exception report on identifying employees that may potentially be burnt out can help reduce turnover. In a burnout report, criteria might include employees that have:

• Not taken PTO in the past 6 months
• No PTO scheduled for the next 6 months
• Consistently working more than 8 hours a day

Being Proactive with Exception Reporting Adds to Bottom Line

Training project managers, principals and teams on project details to look for across the board is essential. Exception reporting is a great way to quickly identify variances between what is expected and what is happening to help identify potential issues sooner. Utilizing business intelligence like exception reports offers firms the chance to proactively make adjustments and reduce data analysis time. Exception reporting can be a positive thing to help achieve better processes or avoid costly issues and should be a part of professional services firms’ operational strategies.

Completed by BARC (Business Application Research Center), the worlds’ most comprehensive survey of business intelligence (BI) end users, the BI & Analytics Survey 21, was conducted from March to June 2020 and included 2591 responders in all. It examined user feedback on BI product choices and use across 36 KPIs. This extremely detailed survey provides great insights into the benefits and drawbacks of a plethora of BI tools.

Not surprisingly, Entrinsik Informer achieved excellent results and customers reported an outstanding user experience. Additionally, Informer received high ratings for its ease of use, ad hoc query capabilities, operational BI, and data preparation. Informer also demonstrated business benefits and business value and received praise for self-service and functionality.

Ease of Use 

One of the biggest advantages to Informer for the majority of its customers and a huge strength of the product is its ease of use. The interface is accessible and allows for the creation of personalized dashboards and reports. Even more, the analysis pipeline is simple to use with drill down capabilities on visualizations and simple exploration of data using pivot tables. Therefore, technical professionals are not required anymore.

Ad Hoc Query Capabilities 

The BARC report indicated that ad hoc query is a key function of Informer, and it offers the ideal synergy for report creation. With a drag-and-drop functionality and easy data access, the query process is quite fast and simple. Yet it remains both versatile and scalable with many options for data sources. 

Timely Operational BI Data

Informer has implemented an effective pipeline for using near real-time updates. Initial reports can be sent out that end-users can custom update when needed. This setup creates an agile work environment for all users granting situational awareness all of the time.

Simplified Data Preparation

Informer users appreciate the data preparation and transformation process which happens in the Data Flow interface. Data Flow allows a review of the incoming datasets such as appending incomplete entries and normalization of inconsistent fields. This feature also has options for data governance and security.

Tangible Business Benefits

Users consider Informer to be beneficial to their business development and consider it to be a market leader in the BI software realm. Informer has a solid understanding of market niches and drives insights which provides for a more collaborative effort. Futhermore, value is given by the ability to query and access data across the organization.

Proven Business Value

Which BI tool creates value for your business is a key metric to consider when selecting the right solution. Informer’s good ratings show that the promise to increase reporting productivity does hold up and this core competency has delivered on every level. The value-add comes from accessibility empowering all departments to create their own reports working with real-time insights to make decisions.

Self-service Abilities

Informer enables all users to benefit from the BI tool. Simply put, elaborate SQL knowledge is not required, and it appeals to clients with multiple data structures allowing flexible integration of a variety of data sources. With its easy set-up, all users can generate insights and reports which drive business decisions without having to rely on IT.

Intuitive Functionality 

Client needs are met with the capabilities of Informer with its dashboards, ad hoc query and distribution of reports. Entrinsik continuously looks to improve these core functionalities such as the update in April 2020 including more flexibility with personal alerts and scheduling individual data updates. Informer 5 focused on client concerns and found solutions that are useful to them. 

In the BARC survey, Entrinsik was also rated as a top vendor in customer satisfaction, price-to-value, vendor support and implementer support. Furthermore, Entrinsik recently made major enhancements to Informer with the version 5 which includes visual attractiveness enhancements. Additionally, Informer has an intuitive report creation that is easy to set up and runs directly on databases, flat files or operational business applications. As far as customer base, Informer is mostly used by mid-sized firms between 100 and 2500 employees. Entrinsik’s familiarity with its clients allows them to anticipate and handle their growing needs timely and thoroughly.

Price-to-Value

Based on the survey results, Informer has a lead over the competition with consistency and its delivery at a bargain price. Two-thirds of clients have stated that the price-performance ratio is a main reason for choosing the tool. Many Informer clients like that it follows a subscription-based pricing model so that costs are predictable and flexible based on use.

BI Product Customer Service

BARC’s data shows that around a third of clients said their good relationship with Entrinsik is why they purchased Informer. The responsive support of Informer shows the commitment to clients after the purchase is made. Entrinsik also has an online presence which offers supplemental instruction in the way of tutorials, webinars and manuals.

Product Implementation Support

There is the right balance of individual flexibility and assistance with Entrinsik. Clients are able to rely on implementation specialists for help with integration and installation. Also, the Development Toolkit offers an internal development team to adopt solutions. Everything is targeted at a fast implementation time period so clients can pursue their own business agenda.

Entrinsik Informer is Worth the Investment 

According to BARC, the Entrinsik Informer BI tool is mainly used for reporting based on 97% of its customers who depend on it for reporting and the ad hoc query functionality. 85% of survey participants used the tool to view data insights and two-thirds of users found benefit from using the available dashboards. These functions of Informer make it the perfect self-service tool for IT and BI professionals, and even those not familiar with BI can use Informer to gain insight.

Business intelligence (BI) is playing an increasingly critical role in the strategic planning of organizations. The output of established analytics can be used to track performance against business goals, identify inefficiencies, optimize processes, report and share information consistently, and identify unrealized business insights, all in real-time across a growing number of browsers and devices. The options are plentiful, and it can get overwhelming as you determine where to start.

Before you can reach these autonomous, pilot-cockpit-type dashboards, you will need a strategy. This will remain fluid and evolve as you adapt to your firm’s needs.  However, it is important to establish a roadmap to ensure that your efforts remain focused and deliver value where it is most needed. Let’s take a look at how to get there.

Identify Pain Points at a High Level

A basic first step is to summarize key pain points impacting your business. What are the questions your business is hoping to answer with its data? What are the information voids in your company? What reports are being run week after week to make decisions? Oftentimes, the pain points will evolve with your BI and shed light on areas needing attention. 

An easy and high-value place to start is exception reporting. Exception reporting highlights potential problem areas in your data based on a set of criteria you define. Examples may include:

• Executive staff need to have visibility when a branch has not met its profit goal;
• A project manager wants a consolidated dashboard to display his or her projects as he or she may be stretching the budget;
• Administrative support staff wish to easily see what project records need review and approval;
• An employee wants to view a dashboard of outstanding items (i.e. timesheet submissions, learning and development courses, annual review progress).

This proactive approach to quick-glance data can be a strong starting point to develop your BI strategy while staying focused on important metrics that require action.

Review Organization Structure

How does your organization structure support your reporting needs?  If you would like to produce reports by organization units (i.e. division, practice, group), then you will want to ensure that your system supports that structure. In the case of Deltek products, you may consider how you are utilizing organizations, teams, timesheet groups, and custom field associations. Furthermore, the firm and system structure will ultimately affect the data that is accessible by different groups.

Define Role Based KPIs

Each role in your organization has a unique business function. Frequently, these roles can share a responsibility that cascades down the business’s organization structure.

Consider the various roles in your company. How can they be grouped into subsets that could be measured together; such as, will a project manager be measured with the same standards as a project principal or supervisor?

One fundamental metric for any company is managing accounts receivable (AR) – getting paid for services or products that have been delivered. Here is an example of role based KPIs, starting at the top of the organization:

• CEO wants to ensure that the AR Aging is in a healthy position to deter cash-flow concerns. CEO is pleased as long as the AR >60 days is less than 10% of the total AR balance at a company level. If that target is not met, CEO can interrogate the data.
• Group manager ensures the total accounts receivable >60 days remains below 10% of the total AR balance for his or her entire group. Data can be summarized by project principal and prompt a discussion with any principal who is above the 10% threshold.
• Project supervisor ensures that AR >60 days is below 10% for each project he or she is responsible for. BI can prompt a discussion with any project manager who is approaching the threshold.
• Project manager is responsible for ensuring that invoices are paid per the 30-day payment terms. Invoices aging over 30 days must be chased and addressed. 

This example illustrates how a single metric is relevant to all roles. Therefore, a CEO can reference a dashboard in discussion with a group manager, who can then take it to the project supervisor, and onward down the hierarchy, directly to the project manager. Since this metric is consistently measured, each role understands the importance and relevance of his or her responsibility. This ties all roles to the financial success of the company.

Educate Team Members

It is important to educate on how defined measures are calculated. By doing so, your teams will clearly understand how their work is being measured and how their project success influences KPIs. BI tools can offer sophisticated and shiny visuals, but the end-user must understand how to use the data. Otherwise, the insights will be lost, or worse – misleading. Clean, simple data and education can provide clear definition to team members. Furthermore, it will give consistent data interpretation across all roles.

Measure the Firm’s Success

As you navigate through the BI journey, pause to measure the success of your BI strategy and the analytics you are measuring.  It is critical to gather feedback from the intended audience to understand how the BI tools are promoting productivity as well as transparency. Are the end-users interacting with the data and making smarter decisions because of it? By being agile in the BI development strategy, you can confidently deliver the most valuable analytical tools for your firm and ultimately power project success.

“What gets measured gets done” is a common phrase heard in the business world. This thought process relies on business metrics that can be tracked and focused on within an organization. Key Performance Indicators (KPIs) are the critical measurements which business leaders pay close attention to consistently. There are many leading and lagging indicators that can be analyzed to gauge a company’s health and employee productivity. So, what are KPIs that leaders and employees use to determine if their firm is operating effectively?  

Leading Indicators Look Forward

Firm leaders must always be looking to the future. New business is crucial to maintain a successful operation of a company. Likewise, appropriate staffing is necessary to ensure employee productivity.

New Business Pipeline – This measures the opportunities in the pipeline throughout the business development or sales process. The process typically covers efforts to attract clients, engage clients, then secure clients. How is a pipeline goal determined? Look at the firm’s hit rate – the ratio of wins to the number of projects pursued – and work backwards to determine the number of calls, meetings, and proposals needed to meet pipeline goals. Other metrics include client touch points, new leads, web visits, blog views, and dollar of proposals submitted, which all feed into the new business pipeline.

Full-Time Equivalent – This number shows if a firm is properly staffed for current and future work. The concept includes hours worked by part-time employees and full-time employees to determine the full-time equivalent (FTE). A firm can look at the total number of hours worked by all staff combined for a given time period and divide it by the number of working hours in that same time period. The FTE metric could trigger human resources to ramp up recruiting efforts or signal to business developers to target work for a specific time to keep utilization where it should be.  

Lagging Indicators Evaluate the Past

To keep a firm running successfully, business leaders must constantly measure results against goals. Were the goals met? Why or why not? There are a number of factors leaders analyze here.

Utilization Rate – Many firms use utilization goals as the benchmark for employee productivity. These goals are usually set by team managers and consider billable time, employee development, and administrative time. Employees can bring their highest value to the firm when they are operating at their optimal billable utilization goal. This metric is widely used at the individual employee level and group level.

Overhead Rate – This measures a firm’s non-billable costs compared to billable costs. Overhead expenses can be monitored and adjusted if this number is higher than desired. Examples of non-billable, or overhead, costs include leases, supplies, and non-billable professional hours, to name a few.

Revenue – This popular metric is the number that sits at the top of the income statement and measures the income a firm generates before subtracting expenses. This can be measured against revenue goals to determine how the company is performing. This number is important, but it should not be the only source of motivation.

Gross Profit Margin – This metric tells the firm’s process efficiency. The higher the number, the more efficiently the work is being completed. This can be measured overall for the firm as well as at the project level.

Revenue Growth – Is your firm on the desired growth path? This comprehensive view shows leaders the growth trajectory year-over-year. If it’s not on the desired path, course corrections can be made to get back on track.

Ongoing Pulse Checks Monitor the Present

It is also important to keep abreast of the general attitude towards your firm by both clients and employees. Both clients and employees contribute to the ultimate success of your firm. Thus, both should be assessed for current satisfaction levels.

Client retention and satisfaction – Repeat clients are vital to a firm’s success and can be tracked against new clients. Keeping clients satisfied helps ensure they will continue using the firm’s services. Tools such as the Client Feedback Tool can be used to gauge how satisfied clients are with the firm’s work and communication. The Client Feedback Tool can also be used to the employee’s advantage, learning where improvements can be made, or assistance requested.  

Employee satisfaction – The employee experience is just as important as the client experience. Satisfied employees are typically more productive, resulting in a stronger bottom line. It is best to keep lines of communication open and engage with, survey, and collaborate with employees regularly.

Using Metrics Ensures Firm Success

There are hundreds of metrics that can be tracked on a daily, weekly, monthly, and annual basis. It is key to find the proper balance of metrics that works for your firm type and structure. Knowing how to get the right data is also important. Solutions such as Deltek Vision, Vantagepoint, and Informer can provide business intelligence showing real-time KPIs, giving leadership teams the data necessary for effective decision making and business management. Clear data can be used to identify the most successful areas as well as those that need attention and improvement. This is the most effective way to regularly stay on top of your firm’s performance.

Business Intelligence (BI) puts together business analytics, data mining, data visualization, technology resources along with the best practices to help companies make more data-driven decisions. Business intelligence can help businesses make better choices by displaying present and historical data in their business context. Analysts can use data visualization to provide performance and competitor benchmarks for a smoother and more efficiently run organization. Analysts can also detect market trends to boost sales or income more quickly. Making sure you are using BI and data visualization properly is important. Let’s look at how you can choose the right data visualizations for your company.

Temporal Visualizations

In the temporal category, data visualizations belong if they satisfy two conditions: they are linear, and they are one-dimensional. Temporal visualizations normally have lines that either stand alone or intersect with each other, with starting and ending time. Some common examples of data visualizations include scatter plots, time series sequences, timelines, line graphs, and polar area diagrams. These visualizations are usually pretty easy to recognize and understand. Picking the right visualization all depends on the kind of story you are trying to tell. When choosing a temporal visualization, your end goal should be comparing one or many value sets. This can help you easily show the low and high values of a data set.

Hierarchical Visualizations

In the hierarchical category, data visualizations are those that organize groups within larger groups. These are best used to display clusters of information, especially if they flow from one point to another. Typical hierarchical visualizations are tree diagrams, ring charts, and sunburst diagrams. Just like any type of data visualization, it is important that you are effectively telling a story with the graphics that you use. For this type, showing levels of importance coming from a single source is the main purpose of these visualizations. The only downside is that these graphs tend to be complex and sometimes difficult to read. The tree diagram is used most frequently because of its easy-to-follow linear path.

Multidimensional Visualizations

While linear data is easier to understand, sometimes you have the need to capture your audience’s attention. Multidimensional displays two or more different variables to create a 3D data visualization. These types of visualizations are scatter plots, pie charts, Venn diagrams, stacked bar graphs, and histograms. These visuals can break down a ton of data into key takeaways, making it easier to clearly identify what you are trying to get across. Multidimensional is used to compare data and parts of a whole and show relationships between two variables. With multidimensional data, you are able to choose different colors and shapes to really customize your graphic.

Data Visualization Makes an Impact

Choosing the right visualization for your data directly impacts how it gets across to the viewers. Your main goal should always be to properly tell a story with the graphics that you use. Data visualization allows you to display specific data in an eye-catching way leading to a successful conveyance of important and relevant information.

Business analytics has become increasingly important for professional services firms. However, finding a business intelligence (BI) tool that works with Deltek Vision and gives us the analytics we want has been challenging. We need flexibility, customization and ease of use to answer important questions about our firms yet often we find that this type of analysis is not accessible in Vision. Thus, we are faced with the export/import/number crunch process in an external tool like Excel plus countless hours spent doing the calculations over and over. We need a better solution, instant access, and easy updates.

Enter Informer 5

Introducing Informer 5, the BI tool which works with Deltek Vision to make instant analytics readily available. Informer 5 is an integrated customizable interface to Vision data for use in various analytical scenarios. Using the Blackbox Connector, direct integration with Vision is now a reality.

You simply select the data fields you want in your database including standard Vision fields, User Defined Fields, and User Defined Info Centers, and you’ll quickly be able to visually see project metrics, employee measurements, marketing results, and firm forecasting. You’ll be able to answer questions such as:

• How are my projects performing?
• How is that new branch office doing?
• Are my employees billing enough hours?
• How is the firm doing compared to the last three years?

Also, remember those spreadsheets with all that data we built over the past years? Informer 5 can integrate this data with your Vision data. No need to reinvent the wheel, we can use it as a data source. Other data sources? Informer 5 can access those too.

Visualize Your Data with Informer 5

Are you interested in where your work is being done and where the profits are made? Well, Informer 5 also includes geographical presentations including maps. You can easily visualize and determine these specifics with Informer 5. You can even find the numbers behind the pictures. Informer 5 has built in drill down capabilities that can take you directly to the detail data. From Profit Center to Project Manager, Project Manager to Project, and all the way down to line item detail, data can be acquired with Informer 5, and all of this can be gathered from the same graph with no need to run additional reports.

Make Smarter Decisions with Informer 5

On a final note, the Informer 5 package includes set calculations for many of our industry standard metrics. Additional calculations can be added to customize this solution for any firm. Also, firm data can be updated regularly on schedule or updated on demand from Vision. It is up to you. So, with all of these awesome features of Informer 5 and its integration with Vision, isn’t it time for your firm to start making smarter decisions?