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.
New workflow
From your workspace, click 'New Workflow'. Instantly, you will be redirected to the canvas located within a new workflow file.
Import File
Every workflow must begin with a data source; thus, drag and drop a tool from the Import tool group onto the canvas.
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.
Connect to Flat Files
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.
Connect to your Data Warehouse
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.
Connect to APIs
APIs, both public and private, can be accessed with the Import from API tool to bring datasets to your canvas.
Prep and Cleanse
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.
Cleanse
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
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.
Combine
Merge tools combine multiple downstream datasets. Connect multiple datasets to the Append tool, for a seamless union of rows. Alternatively, join two datasets using the Join tool, based on a shared column.
Publish and Visualize
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.
Publish to your Warehouse
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.
Build a Data App
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.
