In this article, you can read about the Business insights module in RecMan BI.
Overview
This module helps you analyze your projects or companies more effectively by organizing and visualizing key data like financial metrics, resource allocation, and performance trends.
Key features include a dynamic 12-month timeline for tracking progress, advanced filtering to focus on what matters most, seamless integration with related data sets for a comprehensive view, and the ability to set custom date ranges for tailored analysis.
The Business insights module aims to:
- Provide complete visibility into the financial and operational aspects of projects over time.
- Enable companies to track performance metrics such as contribution margin, costs, revenue, etc.
- Offer an Excel-like grid interface (similar to the Workforce insights module) for easy interaction and overview of key project data.
- Facilitate data-driven decision-making by allowing users to filter and view data from different sources.
How to access
The Business insights module is accessible by hovering over the green RecMan BI icon. If you don't find it in your system, make sure it is activated in the System settings → Users (Co-workers). Contact your System administrator, who has all the required permissions.
Projects or companies will be displayed in an intuitive grid format, organized by month and your selected data point. Each data point is broken down monthly, with totals provided for quick comparisons and trend analysis.
Default data point – Logged work.
Key features:
- 3-12 months view grid
- Only one data point can be examined within a specific date range
- Possibility to create various tabs depending on your needs
Projects or companies will be displayed in a grid format, with data columns representing various data points for easy analysis. Adjust the date settings effortlessly, choosing from week, month, quarter, year, or defining a custom range to match your specific needs.
Default data points – Logged work, Revenue, CM, CM%, Employees.
Key features:
- Custom date range
- Possibility to create various tabs depending on your needs
To add a new view, tap on the + icon. By hitting the three-dot button next to the tab name, you can duplicate, rename, download as .xlsx or remove it. The Download (.xlsx) feature captures exactly what you see on screen – your active date range, applied filters, visible columns and SUM formulas are all respected in the export.
Clicking on the company or project name leads to the corresponding page in RecMan in a new tab.
Choose which entities to view – companies or projects.
For financial data, you can also select a currency. The default is your department's currency.
Data points
| Category | Data point | Description |
|---|---|---|
| Economy | Revenue | The sum of invoice lines minus the sum of credit note lines. |
| Orders | Orders' amount. | |
| Logged work | CM | Revenue - Total cost. |
| CM % | (CM / Invoice) * 100. | |
| Salary | Logged work salary. | |
| Social cost | Social cost of logged work. | |
| Social cost % | Social cost of logged work in percent. | |
| Total cost | Salary + Social cost. | |
| Jobs | The quantity of jobs in projects. | |
| Hours | Logged work hours, showing article type and article if clicked. | |
| Invoice | Logged work invoices. | |
| Employees | The number of employees who have logged work. | |
| Projects | Applicants | Number of applicants. |
| Candidates in pipeline | The number of applied candidates added to the pipeline. | |
| Offers (Quantity) | Quantity of offers. | |
| Offers (Value) | Value of offers. | |
| Department | Department name. | |
| Responsible co-worker | Name of the responsible co-worker. | |
| Value | Amount of value set on the project. | |
| Customer no. | Customer number in RecMan. | |
| Job posts | Quantity of job posts. | |
| Company | Company name. | |
| Start date | Start date of the project. | |
| End date | End date of the project. | |
| Project no. | Project number in RecMan. | |
| Custom fields | Extra, user-defined data fields that capture more information. Read about custom fields in this article. | |
Filtering
The module supports advanced filtering capabilities at the data level. All projects are shown by default. You can add filters, specifying different criteria:
- Quick filters: Projects/companies with data
- Project filters: Corporation, Company, Department group, Department, Project, Co-worker, Employee, Project type, Project phase and Status.
- Economy & Staffing: Article type, Product, Product group, Service group and Service type.
- Custom fields: Single select, Multi-select, Date, Text, Number, Money and Percent. Custom fields depend on the project and can vary depending on the projects in the module. When custom field filters are applied in the Companies view, project data is grouped by company.
- Offers (if the Offers data point is selected): Has signature, Status and Offer type.
- Employee type (if the Employees data point is selected): Employee, Subcontractor or All.
You can use several filters simultaneously.
In Advanced settings, articles marked as "Include in CM = No" can be included. Even if set to "No," such articles will still count towards Invoice and Salary calculations.
Sorting
You can adjust the order of any column by clicking its name. The icon for sorting in ascending or descending order appears.
Drawer
Certain elements, such as specific data in the spreadsheet, are clickable. Clicking them provides more detailed information in a right-drawer format.
Forecasting
The Business insights module supports future forecasting for vital financial and operational data points, such as CM, CM%, Salary, Invoice, and Logged work. This tool provides invaluable predictive insight, helping you plan resources and budgets more effectively.
Forecast displays forward-looking data alongside actual, logged data in both views. In Period view, the number of columns varies based on the selected period. Where a period contains a mix of actual and forecasted data, both are combined within the same column, with logged data always taking priority over forecasted data – once hours have been recorded for a given period, the forecast is no longer counted.
Forecast values are shown on hover. If a cell contains only forecasted data, a "Forecast data" tooltip is displayed. If a cell contains a combination of actual and forecasted data, the tooltip displays Actual, Forecast, and Combined values. The forecast period can be extended up to a maximum of two years into the future.