Build Your First Workflow
Last updated
Was this helpful?
Last updated
Was this helpful?
New users can leverage the Cascade Canvas Tutorial in their workspace for a hands-on experience discovering Cascade.
Everything in Cascade starts with a workflow, which serves as the backbone of the data logic. Within minutes, the cards and dots located in the tool menu allow you to quickly formulate your logic into a visual representation.
From your workspace, click 'New Workflow'. Instantly, you will be redirected to the canvas located within a new workflow file.
Most of the Import tools must be set up before they can be connected to subsequent tools. To do this, click on the tool and follow the prompts in the tool configuration.
Having imported data to your canvas, it's time to hone in on crafting a data-logic flow. Connect your input data to one (or numerous) of the following tool types: cleanse, transform, merge.
Every workflow must begin with a data source; thus, drag and drop a tool from the tool group onto the canvas.
Flat files such as CSVs and XLSXs can be imported to the Cascade canvas by selecting the tool. In addition to these formats, the canvas also accepts SAV and HYPER files.
can be configured from your workspace to facilitate the transfer of data from a warehouse to the canvas. To do this, select the Import from Integration tool.
APIs, both public and private, can be accessed with the tool to bring datasets to your canvas.
tools are ideal for cleaning and standardizing messy data before analysis. Utilize the feature, familiar to anyone who has worked with a spreadsheet. Alternatively, you can deploy the functionality to substitute values from a specified column.
tools provide insight into data. The tool possesses an expression builder in the style of a spreadsheet, allowing for the insertion of new calculations. Additionally, you can incorporate a tool to total and aggregate data. The tool is also useful for singling out rows based on a given criteria.
tools combine multiple downstream datasets. Connect multiple datasets to the tool, for a seamless union of rows. Alternatively, join two datasets using the tool, based on a shared column.
Don't let your insights remain locked in your data. Transform your findings into visuals to share with your colleagues. Utilize the tool to create bar charts, line graphs, scatter plots, and more.
Deliver your tabular data with the Publish to Integration tool. This feature pipes a dataset back to your data warehouse. Alternatively, use the tool to host the dataset at a public URL, or the tool to send a CSV to a designated email address.
Construct a Data App to showcase your discoveries, like a notebook-style microsite. Create a narrative to share with a client. Develop a tools dashboard. Or design a data integration portal for your partner-clients. Interested in exploring Data Apps? Check out our or take a peek at .