product
From raw data to decisions, in one place
dotpy brings together what usually lives across several tools: data intake, transformations, reports, operations screens and the task board. Coming soon: an AI assistant that will do part of the work for your team.
Data sources and ingestion
Set up how to connect once and reuse the same source in as many ingestions as you need. Changing a password or an address doesn't mean redoing anything.
Spreadsheets, files and databases
CSV and Excel uploads, Google Sheets, PostgreSQL and MySQL, through a guided form.
Columns and types detected
dotpy reads a sample, suggests names, types and whether blanks are allowed, and shows examples for each column.
Documented catalog
A description for every table and column, versioned with the author. Columns with personal data get a privacy (LGPD) warning.
Full loads or only what changed
On a schedule or as soon as a file arrives. Passwords stay in your environment's vault, never in the console.
Transformation pipelines
Drag blocks onto a canvas and dotpy writes the SQL. If you know SQL, you can write your own on the same screen.
Blocks for everyday work
Join, filter, group, remove duplicates, calculated columns, pivot and unpivot.
Analytical calculations
Running totals, moving averages, rankings, top N, change and share of total, without writing formulas.
Mappings and calendar
Mapping tables maintained in the console and a calendar with national, state and city holidays.
Conditions, loops and email
Flows with if/then and email notifications, triggered on a schedule or when another table is updated.
Versions and approval
Every save becomes a version with its author. When an approver is set, only they can publish.
Runs, explained
Status, rows and duration, and when something fails, the cause and what to do.
Reports and KPIs
Build charts like a pivot table and organize the report into pages, the way your meetings need it.
Drag the fields
Pivot tables, bar, line, area and pie charts, and KPI cards, with filters per page.
Always up to date
On a schedule or when the data changes, with the history of every refresh.
Full screen
For meetings and for the screens on the factory floor, in the store or at the office.
Who sees what
A report for the whole company or only for the people in its RACI matrix.
dotpy Assistant coming soon
An AI agent that works inside the console: it shows every step, builds drafts and leaves the final call to your team.
The AI receives the structure of the tables (names, types and descriptions) and the text you write in the request, never the records. dotpy tries to block e-mails, CPFs, CNPJs and phone numbers in the most common Brazilian formats, but it does not recognize names or other personal data: do not write them in requests. Nothing is used to train models.
Builds pipelines and dashboards
Assign a task to the assistant. It picks the tables, builds the draft and waits for your review before publishing.
Finds opportunities
It reviews your sources and what already exists, and suggests the missing reports and analyses, with the reason and the steps.
One suggestion, one task
Each opportunity becomes a task in one click, for a person or for the assistant itself.
Questions to your KPIs
Explained answers about the reports each person can already see, citing the charts used.
Forms and screens
Replace scattered spreadsheets and email requests with your own screens, built by dragging fields onto a grid.
Fields for every case
Text, numbers, dates, tax IDs, dropdowns, scales and checkboxes.
Conditional pages
Pages that only show up based on earlier answers.
Public or internal
An open link for customers and suppliers or internal use by your team, with CSV export.
Answers that become tasks
Rules like “if it's urgent, create a task for the buyer due in two days”.
Tasks and alerts
Your team's work and your data work on the same board, with an owner, priority and due date.
Five views
Grouped table, Kanban, calendar, timeline and workload by person.
Data alerts
A rule on your numbers opens a task when something goes off track and closes it when it recovers.
Data tasks
A task can be an ingestion, a transformation or a dashboard, and publishing the result completes the task.
Nothing slips
The owner gets an email, and every task keeps its comments and full history.
Governance and access
A clear owner for every process, and each person seeing only what they need.
How we protect your dataRACI matrix
Responsible, approver, consulted and informed on every pipeline and report, with people or whole teams.
Access by page
Admin, editor or viewer, plus a choice of which console pages each person sees.
Two-step verification
A code from an authenticator app on top of the password.
History of everything
Every change is logged with the date and author.
Usage and billing
No servers to hire and no infrastructure to maintain. A monthly plan with data volume included and one invoice a month, item by item.
Questions about contracts and billingThis month's usage
Storage and processing measured day by day, with the forecast for the month.
Payment in the console
Invoices are paid by Pix, boleto or card, without leaving dotpy.
Start with your tenant
Tell us a bit about your company. The dotpy team will reach out to set up your data environment.