Dashboards in minutes

Connect Sólides DP to Looker Studio (now Data Studio): 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 Studio

How to visualize Sólides DP data in Looker Studio? Start by connecting your Sólides DP account to Kondado, then select Looker Studio as your destination. Within minutes, your employee attendance information flows into visual reports without any technical setup or intermediate databases. Business teams can immediately track worked hours, monitor attendance patterns, and analyze workforce productivity through intuitive charts and metrics that update automatically.

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 Looker Studio, replicating your Daily Summary and Employees data on a configurable schedule ranging from every 5 minutes to daily updates, with no coding required and no separate database infrastructure needed.

You control exactly how often your data refreshes, ensuring your HR dashboards always reflect current attendance records and employee information. This automated approach eliminates manual data exports while giving operations teams the visual insights needed to optimize scheduling, manage labor costs, and improve workforce planning decisions without waiting for technical resources.

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 Studio (now Data Studio)

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

Combine your Daily Summary and Employees pipelines in Looker Studio to build comprehensive workforce analytics dashboards. The Daily Summary pipeline delivers worked hours, paid hours, and compensatory time data that helps managers identify overtime trends and attendance anomalies, while the Employees pipeline provides essential details like admission dates and job roles for accurate headcount analysis.

By blending these datasets, you can create visualizations that correlate staffing levels with actual time worked, track employee tenure against productivity metrics, and generate automated attendance reports for payroll verification. These insights enable operations teams to make data-driven decisions about shift scheduling, identify departments with higher absenteeism rates, and ensure labor compliance through clear visual evidence rather than spreadsheet hunting.

Try out all the features for free for 14 days

How to create Sólides DP dashboards in Looker Studio (now Data Studio)

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

1
Connect Sólides DP as data source

Authenticate your Sólides DP account in Kondado to activate the available pipelines including Daily Summary and Employees data.

2
Select Looker Studio destination

Choose Looker Studio as your destination to enable direct data replication without intermediate databases or complex configuration steps.

3
Build dashboards and configure refresh

Create your attendance visualizations in Looker Studio and set your preferred update frequency to keep reports current automatically.

Access Sólides DP data in Looker Studio (now Data Studio) 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 Studio (now Data Studio) automatically

How do I connect Sólides DP to Looker Studio without technical expertise? ▼
Simply authenticate your Sólides DP account in Kondado to establish the data source, then choose Looker Studio as your destination. The platform handles the data replication automatically, so you can start building charts immediately without writing code or managing database connections.
What attendance KPIs can I track by visualizing Sólides DP data? ▼
You can monitor worked hours versus paid hours, track compensatory time balances, and identify holiday attendance patterns using the Daily Summary pipeline. Visualizing these metrics helps operations managers spot overtime trends and ensure accurate payroll processing through clear graphical representations.
How often does Sólides DP data update in my Looker Studio dashboards? ▼
Kondado replicates your Sólides DP data on a configurable schedule that you set, with options ranging from every 5 minutes to daily updates. This ensures your Looker Studio reports reflect recent attendance entries without manual intervention while respecting your preferred refresh frequency.
Can I build custom HR reports combining employee and attendance data? ▼
Yes, you can blend the Employees pipeline containing admission dates and job roles with the Daily Summary pipeline showing worked hours. This combination allows you to create visual analyses correlating tenure with productivity or analyzing attendance patterns by department or position.
How do I share Sólides DP attendance dashboards with my team? ▼
Once you build your dashboard in Looker Studio, use the native sharing features to distribute view or edit access to managers and HR staff. Your colleagues will see the same updated Sólides DP data you do, ensuring everyone works from consistent attendance information.
What specific employee metrics from Sólides DP work best in charts? ▼
The birthdate and admission date fields from the Employees pipeline work excellently for tenure analysis and age demographic charts, while employeeid connections help you visualize individual attendance histories. These metrics create meaningful workforce planning visualizations when combined with time clock data.
Can I combine Sólides DP data with other business tools in Looker Studio? ▼
Absolutely, you can blend your Sólides DP pipelines with data from Google Sheets, BigQuery, or PostgreSQL within the same Looker Studio report. This enables comprehensive analyses that correlate employee attendance with sales figures, project timelines, or financial data stored in other platforms.

Try out all the features for free for 14 days