Analytics: Connect your operational data to BI tools and create customized analyses

Companies that use data to make strategic decisions know how challenging it can be to consolidate information from different systems.

Often, HR, Personnel Department, Technology, and BI teams need to manually export spreadsheets to cross-reference information on work hours, overtime, absenteeism, turnover, productivity, and work performance indicators. Besides being time-consuming, this process increases the risk of inconsistencies and hinders more advanced analyses.

To eliminate this bottleneck, Pontotel offers Analytics, a service that provides structured access to the platform's data so that your company can integrate it into the data ecosystem already used internally.

In this article, you will understand how Analytics works, what information is available for analysis, and how the solution can support data-driven strategies.

What is Analytics?

Analytics is a complementary service from Pontotel that provides secure access to platform data through a structured relational database.

The solution was developed for companies that want to create customized dashboards, develop advanced analytics, or integrate journey management data with other information sources used in the business.

Unlike Farol do DP, which offers ready-made dashboards directly within the Pontotel platform, Analytics provides access to data so your company has the freedom to build its own analyses.

How does it work?

Pontotel provides a secure environment containing structured and documented analytical views

These views can be consumed by Business Intelligence, data platforms, data lakes, data warehouses, or other analytical environments used by the company.

After the integration is set up, your technology team, BI team, or specialized partner will be able to synchronize the data and use it to build customized dashboards, reports, and indicators.

Main benefits

By using Analytics, your company gains access to:

• Structured access to Pontotel data;
• Integration with BI tools and analytical platforms;
• Autonomy to create customized dashboards;
• Cross-referencing data with other corporate systems;
• Reducing dependence on manual exports;
• Faster and more reliable analyses;
• Support for data-driven decision making;
• Greater visibility into operational and strategic indicators.

Compatibility with BI tools

Analytics is not limited to one specific tool.

The data can be used by various market solutions, such as:

• Power BI;
• Tableau;
• Looker Studio;
• Qlik Sense;
• Metabase;
• Apache Superset;
• Data Lakes;
• Data Warehouses;
• other platforms compatible with your company's data strategy.

What information is available for integration?

Analytics provides a set of specialized views for querying and analysis.

Registration data and organizational structure

It allows you to view information related to employees and the company's structure.

Available data:

• Employee identification;
• internal code;
• CPF or equivalent document;
• date of admission;
• shutdown date;
• position;
• department;
• employer;
• workplace;
• direct leadership;
• Access email.

Daily schedule

It provides a consolidated view of each employee's journey.

Information available:

• days worked;
• vacation;
• absences;
• holidays;
• justifications;
• Attendance is mandatory;
• recorded times;
• duration of the workday.

Time clock entries

It provides detailed information about each time clock entry.

Among the available data are:

• recorded times;
• Entrances, pauses, returns and exits;
• origin of the marking;
• type of collector used;
• type of REP;
• online and offline records;
• processing status;
• IP address;
• time zone;
• geolocation;
• Location accuracy;
• QR Code;
• identification methods used.

Advanced audit capabilities

In addition to traditional time and attendance information, Analytics provides data that can support audits and internal controls.

Among them:

• result of facial recognition;
• biometric validation;
• liveness detection ;
• attempts to manipulate location (location spoofing);
• device's automatic time status;
• Automatic time zone status;
• validation hash;
• CRC16 for record integrity.

This information allows you to create customized dashboards and alerts for monitoring compliance and operational safety.

annual leave

It allows you to track all activity related to the time bank.

Information available:

• credits;
• debts;
• accumulated balances;
• due dates;
• daily history;
• monthly history;
• Discharges carried out;
• payments related to the time bank.

Absenteeism and sick leave

It allows you to analyze absences and justifications recorded on the platform.

Information available:

• Reason for dismissal;
• periods of absence;
• collaborator;
• team;
• employer;
• workplace.

Vacation

It provides data related to vacation planning and requests.

Information available:

• vacation periods;
• approvals;
• Vacation sale;
• advance payment of thirteenth salary;
• Request history.

Overtime management

It allows you to track the entire approval workflow for overtime requests.

Information available:

• requests;
• approvals;
• refusals;
• justifications;
• approvers;
• planned periods;
• duration of overtime hours.

Turnover

It provides consolidated indicators related to employee movement.

Information available:

• admissions;
• shutdowns;
• turnover rate;
• active collaborators;
• full movement;
• retention for 6 months;
• 12-month retention period.

Examples of analyses that can be created

With Analytics, your company can develop customized dashboards for:

• costs associated with overtime;
• time bank per unit;
• absenteeism by team;
• Turnover by department;
• Attendance indicators;
• Audit of timekeeping records;
• labor compliance;
• operational productivity;
• Retention indicators;
• vacation accompaniment;
• labor costs;
• Executive dashboards for management.

Furthermore, Pontotel's data can be cross-referenced with information from other company systems, such as ERPs, CRMs, financial platforms, logistics systems, or management tools.

Analytics or Payroll Lighthouse?

Although they are complementary, the solutions have different objectives.

DP Lighthouse

Ideal for companies that want to track ready-made indicators directly within Pontotel.

Features:

• Ready-made dashboards;
• rapid implementation;
• Indicators developed by Pontotel specialists;
• Focus on operational monitoring.

Learn more about the HR Beacon in the article: HR Beacon: track work schedule indicators in real time.

Analytics

Ideal for companies that want to create their own analyses and integrate data into their corporate ecosystem.

Features:

• structured data access;
• Fully customized dashboards;
• Integration with BI tools;
• Freedom to cross-reference information;
• Focus on advanced and strategic analysis.

Frequently Asked Questions

Does Analytics replace the HR Beacon?

No.

The DP Lighthouse offers ready-made dashboards for operational monitoring. Analytics provides access to the data so your company can develop customized analyses.

The solutions can be used in a complementary way.

Does Analytics provide ready-made dashboards?

No.

The service provides access to structured data. The dashboards are built by the company itself or by its technology and BI partners.

Can I use any BI tool?

Yes.

Analytics was developed to allow integration with different Business Intelligence tools and analytical platforms.

Can I cross-reference Pontotel's data with other systems?

Yes.

This is one of the main advantages of the solution. The data can be combined with information from ERPs, CRMs, financial systems, logistics platforms, and other sources used by the company.

Can I change Pontotel data through Analytics?

No.

The access provided is exclusively for viewing and analyzing the data.

All operational maintenance continues to be carried out by Pontotel's official facilities.

Is it possible to create fraud audits using the data?

Yes.

The information provided includes indicators related to geolocation, facial biometrics, and security validations that can be used to create alerts and audit dashboards.

Want to learn about Analytics in practice?

Analytics is the ideal solution for companies that want to transform work journey data into a strategic source of information for the entire organization.

If you want to understand how to integrate Pontotel data into your BI environment and explore new analytical possibilities, schedule a no-obligation presentation with our experts.

🔗 Presentation - Analytics

For further guidance, please visit our Help Center or contact our Support team via the chat integrated into the Management website or via WhatsApp.

Updated on: June 3, 2026