Analytics: how to extract relevant data for your business

The Analytics dashboards consist of interactive cards that display real-time indicators and charts, enabling strategic analyses of your company's operations.

In this article, you will learn how to use Day.io Analytics, the BI tool that acts as your business's data partner. Attendance data are valuable assets for people management because they allow:

• Decision Making
  • They support leadership with reliable information to evaluate scenarios, identify opportunities, and reduce risks.
• Operational Efficiency
  • They optimize internal processes and give the team more autonomy to generate strategic indicators quickly.
• Employee Insight
  • They allow understanding behavior patterns, supporting predictive analyses such as Bank of Hours and Overtime.

Additionally, through panels like Absenteeism, Overtime, Absences, and Irregularities, it is possible to deepen analyses by expanding cards and using advanced filters.

Each card can be expanded (full screen icon) and offers options such as Show and Filter, which allow customizing metrics and refining data, making the analysis more precise and targeted.

Main Actions or Configuration

1. Select the module and identify the cards
   • Click on Analytics in the side menu and choose the module related to the analysis (for example, Overtime or Absenteeism for absences).
   • Each module contains several cards with indicators, charts, or tables. The cards show metrics such as total overtime hours, absenteeism percentage, or top employees for each metric.
     
     
2. Expand a card for detailed viewing
   • Hover over a card and click the expand icon (a square with an outward arrow). The card will enlarge into a bigger window.
   • In the expanded view, use the Show and Filter buttons to customize the display:
     • Show allows you to choose which metrics or series will appear in the chart or table (for example, switch between monthly and yearly overtime or display only certain columns).
     • Filter enables specific filters within the card, such as limiting smaller periods, selecting only certain teams or departments, or setting a maximum number of records to display.
   • After adjusting the options, notice how the data updates instantly and click Back to dashboard to return to the dashboard.
     
     
3. Apply global filters in the Filters panel
   • On the left side of the screen, click + in the FILTERS panel to add global filters that affect all cards in the module.
   • Available filters include Date, Team, Department, Subsidiary, Cost Center, Supervisor, among others.
   • You can combine multiple filters to refine the search (e.g., Date between 01/01 and 01/31, Department: Sales, Subsidiary: São Paulo).
   • To remove a filter, click the X next to the applied criterion.
     
     
4. Interpret and navigate additional information
   • Sort columns by clicking on the header (for example, sort employees by descending overtime hours).
   • When comparing periods or segments, use global filters and card filters simultaneously for consistent analyses.
     
     
5. Export data or capture insights
   • Some cards offer a download icon; click it to export the table in CSV or Excel format and continue the analysis outside the platform.
     
     

Other Actions Available on This Screen

• Combine the use of dashboards with the platform's reports (Reports) to add detailed data to your analyses.
• Global filters remain active while your session is open; adjust or remove them as needed.
• Share insights with your team by exporting tables.

Tips or Troubleshooting

• Global filters and card filters can add up; if there is no data, review each applied criterion and broaden the time range or teams.
• Analytics data is updated every 3 hours; if there are discrepancies, wait for the next update or check for pending approvals in the Attendance tab.

Best Practices

• Regularly explore the expansion features to analyze trends in detail and identify patterns that may not be visible in the standard view.
• Set analysis routines (weekly or monthly) and use global filters to consistently compare periods and teams.
• Guide leaders and supervisors to use the Show and Filter options on cards to customize reports according to their needs.
• Cross-reference the data obtained in dashboards with internal goals and KPIs to guide action plans.

Frequently Asked Questions

How do I expand an Analytics card? Hover over the desired card and click the expand icon (square with arrow). The card will be displayed full screen, and you can use the Show and Filter options to customize the metrics.

What are the Show and Filter buttons for? Show allows selecting which metrics or columns will be displayed in the expanded view. Filter allows refining the data within the card, such as limiting the period or choosing a specific department.

Do global and card filters work together? Yes. Filters added in the FILTERS panel affect all cards, while card filters adjust only the expanded card. Use both for more precise analyses.

Can I export data from a card? Some cards have a download icon. Click it to export the table in CSV or Excel format.

How do I compare different teams or departments? Add global filters by Department, Team, or Subsidiary in the FILTERS panel and change the values to view each segment; in expanded cards, use Filter to further refine.