Dashboards in minutes

Connect Sólides DP to Looker: 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 Looker

Kondado helps you replicate data from Sólides DP directly into Looker without any technical setup or coding requirements. You simply select Sólides DP as your data source and Looker as your destination, then choose which attendance and employee information to visualize. Your team can then build custom reports showing worked hours, employee attendance patterns, and productivity metrics that refresh on a configurable schedule.

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 connects Sólides DP to Looker through a direct connection that requires no intermediate databases or complex configuration, allowing business teams to analyze attendance data with automated updates every 5 minutes, 15 minutes, hourly, or daily.

By eliminating manual data exports and spreadsheet management, Kondado ensures your workforce analytics in Looker always reflect the latest time clock records. Operations managers and HR teams can track overtime trends, monitor absenteeism rates, and optimize staffing decisions using visualizations that update automatically on your chosen schedule without requiring IT support or technical expertise.

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 Looker

Each item below is automatically replicated by Kondado from Sólides DP into Looker — 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

With Kondado, you can unlock powerful workforce insights by combining Sólides DP’s Daily Summary and Employees pipelines in Looker. The Daily Summary pipeline brings in worked hours, paid hours, and holiday information, while the Employees pipeline provides essential details like job roles and admission dates. Together, these datasets enable you to create comprehensive attendance dashboards that correlate employee demographics with productivity patterns.

Business teams can analyze compensatory hours across departments, track turnover trends using admission dates from the Employees pipeline, and identify attendance anomalies through the Daily Summary records. This combination helps HR managers make data-driven decisions about scheduling, overtime allocation, and workforce planning without manually consolidating time clock data.

Try out all the features for free for 14 days

How to create Sólides DP dashboards in Looker

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

1
Add Sólides DP as data source

Log into Kondado and select Sólides DP from the available data sources, then enter your credentials to establish the connection. Choose the specific pipelines you want to replicate, such as Daily Summary and Employees, to begin importing your attendance data.

2
Select Looker as destination

Select Looker as your destination platform to receive the Sólides DP data, or alternatively send data to Power BI, Google Sheets, or BigQuery if you prefer other visualization tools. Kondado will handle the data formatting automatically for your chosen destination.

3
Configure refresh and build reports

Set your preferred update frequency, choosing from every 5 minutes to daily refresh, then start building custom attendance dashboards in Looker. Your reports will stay current automatically based on the schedule you selected, ensuring your team always has the latest employee time clock data for decision-making.

Access Sólides DP data in Looker 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 Looker automatically

How do I connect Sólides DP to Looker using Kondado? ▼
Start by adding Sólides DP as a data source in your Kondado account, then select Looker as your destination. You will authenticate your Sólides DP credentials and choose which pipelines to replicate, such as Daily Summary or Employees, without needing any database setup or technical configuration.
What Sólides DP attendance reports can I build in Looker? ▼
You can build custom reports showing overtime trends, absenteeism rates, and departmental productivity by combining the Daily Summary and Employees pipelines. These visualizations help HR teams identify scheduling inefficiencies and track compensatory hours across different teams and time periods.
How often does Sólides DP data update in Looker? ▼
You can configure the update frequency to match your business needs, choosing from every 5 minutes, 15 minutes, hourly, or daily refresh schedules. This ensures your attendance dashboards reflect recent time clock entries without manual data exports or spreadsheet updates.
Which employee KPIs should I track when visualizing Sólides DP data? ▼
Focus on metrics like worked hours versus paid hours from the Daily Summary pipeline, employee turnover trends using admission dates from the Employees pipeline, and holiday versus regular attendance patterns. These KPIs help optimize workforce allocation and identify potential retention issues.
Can I share Sólides DP dashboards with my team in Looker? ▼
Yes, once you build your attendance and productivity reports in Looker, you can share them with operations managers, HR staff, or executives through Looker's built-in sharing features. Your colleagues will see the same updated data based on the refresh schedule you configured in Kondado.
Can I send Sólides DP data to other tools besides Looker? ▼
Absolutely, Kondado allows you to replicate Sólides DP data to multiple destinations simultaneously. You can send attendance information to Power BI, Google Sheets, or BigQuery while maintaining your Looker connection for comprehensive analytics across different platforms.
Do I need a pre-built template to visualize Sólides DP data in Looker? ▼
No template is required, you can build completely custom dashboards tailored to your specific workforce analytics needs. Using the available pipelines like Daily Summary and Employees, you create visualizations that match your company's unique attendance tracking requirements and KPIs.

Try out all the features for free for 14 days