Dashboards in minutes

Connect Sólides DP to Redash: Dashboards in Minutes

Get started for free

No credit card required | 14 days | 10 million records | 30 pipelines

sso google logo
Sign up with Google
sso facebook logo
Sign up with Facebook
sso microsoft logo
Sign up with Microsoft
sso linkedin logo
Sign up with Linkedin

or sign up with your email

By signing up, you agree to Kondado’s Terms of service and Privacy policy

Connect Sólides DP to Redash

How to visualize Sólides DP data in Redash? Start by connecting your Sólides DP account to Kondado, then select Redash as your destination. Kondado replicates your attendance and employee data on a configurable schedule, delivering fresh information directly to your Redash environment without any intermediate databases or complex technical setup. Business teams can then build custom reports to track workforce productivity, monitor attendance patterns, and optimize labor costs using intuitive visual dashboards.

13
available pipelines
276
extractable fields
  • ✓No code, no spreadsheets
  • ✓Auto-refreshed data
  • ✓14-day free trial

Try out all the features for free for 14 days

Kondado provides a direct integration between Sólides DP and Redash, replicating Daily Summary and Employees data on a configurable schedule ranging from every 5 minutes to daily, enabling non-technical teams to build attendance dashboards without writing code.

With this connection, operations managers and HR professionals can transform raw time clock data into actionable insights. Whether you need to analyze overtime trends across departments or track employee admission dates for workforce planning, Kondado keeps your Redash reports updated automatically so you always have current information for strategic decisions.

Our prices start from $19 USD/month, and you can try Kondado for free for 14 days with no credit card required

Try out all the features for free for 14 days

Available data

Sólides DP data available in Redash

Each item below is automatically replicated by Kondado from Sólides DP into Redash — no schema setup, no manual mapping.

13
available pipelines
276
extractable fields
∞
Auto-refresh

Available integrations

Daily Summary
Includes information such as worked hours, paid hours, and compensatory hours. Fields like id, employeeid, and isholiday help analyze employee attendance.
Employees
Contains data about employees, including name, email, and admission date. Fields like id, jobroledto__id, and birthdate provide essential details about each employee.
Time Clock Records
Employee clock-in and clock-out punches, one per row, with date and time, entry and exit geolocation, workplace, and adjustment and validation flags (fingerprint, facial recognition).
Time Adjustments (incl. vacations and leaves)
Time adjustments such as vacations, medical certificates, days off, and excused absences. Each row has the period, reason, employee, and approval status, useful for tracking justified absences.
Adjustment Reasons (incl. vacations and leaves)
Registered adjustment reasons, such as vacation, medical certificate, day off, and excused absence. This is the table that classifies time adjustments.
Job Roles
Company job roles, with description, CBO (Brazilian occupation code), and base salary.
Work Schedules
Registered work schedules (shifts), one per row, to compare the planned workday with the recorded hours.
Workplaces
Workplaces (departments and units), active and inactive, to analyze attendance and hours by unit.
Managers
Registered managers and their matching employee record, to build attendance analysis by team and leadership.
Companies (branches)
Registered companies (headquarters and branches, by CNPJ). Employees point to their company through the company__id field, so attendance and hours can be analyzed by branch.
Time Clock Rules
Registered time clock rules: tolerances, night hours, hour bank vs. overtime control, and hour bank percentages and limits.
Hour Bank (current balance)
Current hour bank balance for each employee at read time. The table is rewritten on every run, as a snapshot of the balance, without history.
Time Edit Justifications
Justifications available for manually editing clock punches, with the attachment and note requirements of each one.

Try out all the features for free for 14 days

Combining Sólides DP with Redash unlocks powerful workforce analytics for your business. By replicating the Daily Summary pipeline, you can visualize worked hours, paid hours, and compensatory hours to identify attendance trends and overtime patterns across teams. The Employees pipeline brings essential HR data including admission dates and job roles into your dashboards, enabling you to correlate staffing levels with productivity metrics. Together, these datasets allow operations teams to create comprehensive reports that track labor costs, monitor holiday attendance, and optimize shift scheduling without manual data exports.

Try out all the features for free for 14 days

How to create Sólides DP dashboards in Redash

Visualize your data automatically — no spreadsheet exports or custom scripts.

1
Connect Sólides DP to Kondado

Add Sólides DP as a data source by entering your account credentials and selecting the Daily Summary and Employees pipelines you want to replicate.

2
Choose Redash as destination

Select Redash from the available destinations and configure your connection settings to determine how the attendance data will appear in your visualization environment.

3
Configure refresh and build dashboards

Set your preferred update frequency, ranging from every 5 minutes to daily, then start building custom reports in Redash that track worked hours, employee attendance, and labor costs.

Access Sólides DP data in Redash and combine it with dozens of other data sources

If the source you want is not listed, drop us a chat message. We love to add new sources!

Visualize Sólides DP data in other BI tools

If the software you need is not listed, drop us a messagem. You can use almost every tool

Hundreds of data-driven companies trust Kondado
arezzo
brf
Contabilizei
dpz
Experian
grupo_soma
multilaser
olist
unimed
v4_company
webmotors
yooper

Frequently Asked Questions (FAQ)

Answers about visualizing Sólides DP data in Redash automatically

How do I connect Sólides DP to Redash using Kondado? ▼
Start by adding Sólides DP as a data source in your Kondado account and authenticate with your credentials. Then select Redash as your destination and choose which pipelines you want to replicate, such as Daily Summary or Employees. Kondado handles the data transfer automatically, delivering your attendance information directly to Redash without requiring any technical configuration or intermediate storage.
What attendance KPIs can I track in Redash with Sólides DP data? ▼
You can monitor essential metrics including total worked hours, paid hours, compensatory hours, and holiday attendance using the Daily Summary pipeline. The Employees pipeline allows you to analyze metrics by job role, track admission dates for turnover analysis, and correlate staffing data with productivity trends. These insights help HR teams identify overtime patterns and optimize workforce allocation across departments.
How often does Sólides DP data update in Redash? ▼
Kondado updates your Sólides DP data on a configurable schedule that you control, with options ranging from every 5 minutes to daily refreshes. You can adjust the frequency based on your reporting needs, ensuring your Redash dashboards reflect recent attendance records without manual intervention. This automated refresh keeps your workforce analytics current for timely decision-making.
Can I build a dashboard showing overtime trends from Sólides DP? ▼
Yes, using the Daily Summary pipeline you can create visualizations that track overtime hours, regular worked hours, and compensatory time across specific periods. Filter the data by employee ID or department to identify which teams consistently work extra hours, enabling managers to address workload imbalances and control labor costs effectively.
Is there a template for Sólides DP employee attendance reports in Redash? ▼
Kondado does not provide pre-built report templates for Sólides DP, but you can easily create custom dashboards tailored to your specific business needs. Build visualizations that combine Daily Summary metrics with Employees data to track attendance patterns, monitor punctuality, and analyze workforce trends. These custom reports can be saved and shared with stakeholders across your organization.
How do I share Sólides DP dashboards with my team in Redash? ▼
Once you build your attendance dashboards in Redash, use the platform's native sharing features to distribute reports to managers and HR professionals. You can set permissions for different team members to view or edit specific visualizations, ensuring the right people have access to workforce insights. Since Kondado keeps the data updated automatically, your shared dashboards always display current attendance information.
Can I send Sólides DP data to other tools besides Redash? ▼
Yes, Kondado allows you to replicate Sólides DP data to multiple destinations simultaneously. You can send your attendance data to Power BI, Google Sheets, BigQuery, or PostgreSQL alongside Redash, enabling you to use different tools for different analytical needs while maintaining consistent data across platforms.

Try out all the features for free for 14 days