What is Strata?
Strata is Oplema's browser app for data prep. Open it and you'll see an empty canvas with the block palette above it. You clean, combine and reshape tables in a flow, on the canvas or in a script. Local work runs in your browser, and you don't need to sign up to start.
Follow a table through a flow
A flow is a chain of blocks that takes a source table and produces the table you need. Each step stays on the canvas, so you can see how every result was made.
The flow holds the steps, and the output is the data they produce. To change a result, edit the block that produces it.
One flow, two ways to edit it
The canvas shows the flow as connected blocks. The script shows the same flow as text. Edit either one and the other updates, because there's only one flow.
Use the canvas to follow the connections between blocks. Use the script when you'd rather read or edit the steps as text.
Each block does one operation
A block is one step in the flow, such as filtering rows or totaling by group. Data comes in through its input ports, its settings say what it does and its output ports pass the result to the next block. A source block, such as Input, starts the flow and needs no incoming table.
Connections decide which result feeds the next block. A filter before a grouped total changes which rows go into the total. A filter after it picks from the finished groups. The order of the blocks is part of the calculation.
Use the result
A prepared table can feed a Vista dashboard or go elsewhere through an Output block. To get a different result, change the flow.
To learn Strata on a real job, take the first course, Build a report from a CSV export. Its hands-on lessons start from one shop's export, and the courses after it build up to a dashboard someone else can rerun.
Pick your first block
Choose a palette for the task you need: IO, Prep, Combine, Transform, Parse, Developer or Documentation.
See the blocks that bring data into a flow and send results out. Start with Input.
About Strata FAQs
- Do I need to write code to use Strata?
- No. Build a flow by connecting blocks on the canvas and filling in their settings. The script is another way to edit the same flow. Use expressions or a Python or R code block only when you need them.
- Are the Strata canvas and script separate flows?
- No. The canvas and the script are two editors for the same flow. A change in one shows up in the other.
- What is the difference between a flow and its output?
- A flow is the list of steps. Its output is the data those steps produce. Edit the flow to change how the output is calculated.
Prepare your data. Build it in Strata.
Strata opens in your browser, with no account.