Comment on page
Build Your First Workflow
New users can leverage the Cascade Canvas Tutorial in their workspace for a hands-on experience discovering Cascade.
%20Intro%20Cover.png?alt=media&token=74d27601-f9e6-47cc-8310-9a15f1b3520d)
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.
%20New%20Workflow_Build%20Your%20First%20Workflow.png?alt=media&token=4f762580-622d-4486-9444-1407538b665f)
Every workflow must begin with a data source; thus, drag and drop a tool from the Import tool group onto the canvas.
%20Import%20File_Build%20Your%20First%20Workflow.gif?alt=media&token=4ed0f734-ce97-4145-8729-aa19ec2fbb94)
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.
A wrench icon displayed atop a tool is indicative of the fact that it needs to be configured.
Flat files such as CSVs and XLSXs can be imported to the Cascade canvas by selecting the Import File tool. In addition to these formats, the canvas also accepts SAV and HYPER files.
Integrations 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 Import from API tool to bring datasets to your canvas.
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.
%20Prep%20and%20Cleanse_Build%20Your%20First%20Workflow.png?alt=media&token=7b310f43-44fb-41a3-8380-27187244c123)
Cleanse tools are ideal for cleaning and standardizing messy data before analysis. Utilize the Text to Columns feature, familiar to anyone who has worked with a spreadsheet. Alternatively, you can deploy the Find Replace functionality to substitute values from a specified column.
Transform tools provide insight into data. The Edit Columns tool possesses an expression builder in the style of a spreadsheet, allowing for the insertion of new calculations. Additionally, you can incorporate a Pivot tool to total and aggregate data. The Filter tool is also useful for singling out rows based on a given criteria.
Don't let your insights remain locked in your data. Transform your findings into visuals to share with your colleagues. Utilize the Chart tool to create bar charts, line graphs, scatter plots, and more.
%20Visualize%20and%20Share_Build%20Your%20First%20Worklfow.png?alt=media&token=2136e393-c874-4c1e-ae92-7b09f02d2902)
Deliver your tabular data with the Publish to Integration tool. This feature pipes a dataset back to your data warehouse. Alternatively, use the Embed tool to host the dataset at a public URL, or the Publish via Email 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 Data App Gallery or take a peek at Build Your First Data App.
Last modified 10mo ago