IO
8 blocksRead data from files, databases and apps, or type it in. Write results back out or send them to a dashboard.
Clean, combine and reshape data in your browser. Build a flow, inspect the results and run it again when your data changes.
Give me a file of refunded orders, including their order details. I'll match the refunds to their orders and add a CSV output. The refund file is ready. Your monthly sales report is unchanged.
This example could not load. Reload the page to try again.
Open Strata and start with your own file. No sign-up, nothing to install.
Spreadsheets, CSV and Parquet on your computer.
Combine database tables with your other sources.
Read records from your sales, finance and other apps.
43 blocks for reading, cleaning, joining and reshaping data. Use SQL, Python or R for anything they don't cover.
Read data from files, databases and apps, or type it in. Write results back out or send them to a dashboard.
Filter, sort and clean rows and columns. Fill gaps, remove duplicates and calculate new fields.
Bring tables together by stacking, joining or looking up rows, even when values are spelled differently.
Summarize and pivot tables. Calculate totals, running figures and changes over time.
Turn messy text, dates and JSON into clean columns, or split one column into several.
Add Python or R steps for anything the blocks don't cover, using the libraries you already know.
Add notes alongside your flow with the Documentation palette. Explore Documentation
Rename a column, change a rule or adjust a step. The results update as you work.
This example could not load. Reload the page to try again.
Every flow has a script you can read and edit, and the canvas stays in sync. Elara works with the same script when it edits your flow.
This example could not load. Reload the page to try again.
Write custom calculations right in your flow.
Use the packages your calculation needs.
Use data from earlier steps and send the results on.
This example could not load. Reload the page to try again.
Here, NumPy uses 12 months of fictional sales to estimate demand for the next three months.
Elara can build and edit flows, check calculations, help you interpret your results and work through errors.
Break down revenue by product category and rank the results. I'll group revenue by category, then put the largest categories first. The categories are grouped and ranked by revenue.
This example could not load. Reload the page to try again.
Elara turns joined data into a ranked breakdown without leaving the flow.
Try another approach without losing the one that worked. Your edits and Elara's share the same history.
This example could not load. Reload the page to try again.
Write out the data, build a dashboard or take the flow with you.
Save a file or write to a supported database.
Output destinationsSend a table to Vista and turn the result into a chart.
Explore VistaExport flows as Python and run them outside Oplema.
Read the Strata docsBuild and run flows locally for free. Pay for hosted runs, Elara and connector transfers when you use them, with no seat fees.
Work locally without an account. Sign up for free to get a one-time $10 of usage.
Billed monthly. Excludes tax.
$192 billed annually. Excludes tax. Usage resets every month.
Starter $20, Regular $60 or Scale $200 a month, each with monthly usage you can assign to your teams. You can also buy usage from $10 without a subscription.
There are no seat fees, and local work stays free. Larger machines and larger transfers are coming.
Open Strata and start with a file.