Part 1. Filtering and basic transforms

Step by Step Guide: How to Transform Data with Pipelines

This video will teach you about pipelines and how they can process data in Alphacast without requiring any coding

Pipelines are the most powerful feature of the platform, allowing you to process data within it. They consist of a sequence of steps that transform data in a variety of ways.

01. You can choose different ways to start creating a pipeline:

• The long road involves click on Create new Pipeline in the top right corner of the screen, then choose the repository and the desired pipeline name, finally click on the 'create' button.

• The quick way to do it is by clicking on Transform Data directly in the dataset view

02. Fetch Alphacast Dataset
in the example, we will be using the external trade of Brazil

03. Add the Select Columns step in the filters category and then select which variables you want to use
In this case, exports and imports

04. Add the Rename Columns step in the reshaping category and pick a new name for the variables

05. Add the Apply Transform step and select sum last 12 months on the drop-down menu and which variable you want to transform.

This step enables you to modify the original data based on its frequency and combine different transformations according to your requirements. To view all transformation options, click here (opens in a new tab)

The transformation used in the video, Sum last 12 months, refers to adding the values of a particular variable for the past 12 months. It is a common analytical calculation used to track trends and performance over time.

06. Add the step Publish to dataset and choose a name. The dataset will be created in the same repository as the pipeline. Click here (opens in a new tab) for more information

07. If you do not wish to publish the datasets, you can create a Data Snapshot which takes a snapshot of the data up to that step and provides you access to it through a link. More information is available by clicking here (opens in a new tab)

In the next video, you will learn how to change the frequency, perform data interpolation, and modify the units.