Creating a pipeline dos and donts

With pipelines you can process the data within the platform. A pipeline is a sequence of steps, transformations and others to be applied to a particular dataset that has the characteristic of updating automatically every time a data is updated. There are two different ways to do this:

  • From scratch: click Create new on the upper right corner and then Pipeline.
  • From any dataset: you can create a pipeline from any dataset. When entering to the dataset view, on the right you will find the button Create Pipe

Both options will lead you to the Pipeline Engine. Here you will need to choose the repository where the pipeline will be stored and select a name for it. After that is where the fun begins! First, you will have to choose the dataset you want to work with. Once you save it, you will be able to choose different steps to modify and transform your data as you wish.

As an example we chose the following dataset: Inflation - Argentina - INDEC - Consumer Price Index - Groups - Monthly and we applied the following steps:

  • Rename columns: to change the name of one of the variables
  • Change Frequency: to rescale the frequency from monthly to quarterly
  • Select columns: to leave only the variable we were interested in and leave behind the other ones.

Remember to click the Save button each time you finish working on your step.

Once you finish working on your pipeline, you will need to click the default step called Publish to dataset to assign a name and repository to your new dataset. It will be automatically updated every time the original dataset is updated either by Alphacast or by yourself or when the pipeline is run. After that, you can save it and preview it or you can just go to the new dataset to start charting!


Luciano Cohan

Written by

Luciano Cohan

Co-Fundador de Alphacast. Ex Subsecretario de Programación Macroeconómica. Data Science. Creando una plataforma para el trabajo colaborativo en economías

Related insights

  •

    How to integrate Alphacast with Excel for Mac?

    You will need the complete URL for the dataset that you want to integrate, which you can find by clicking the Download button and then copying (not downloading!) the URL attached to a TSV file.


  • Read more... alphacast_logo_1.png

    8 amazing econdashboards you cannot miss!

    Stop spending your day copying & pasting data from sources that frequently change their formats, and get your charts updated right away.

    Dashboards are updated every day with the most recent data. Remember that you can copy and clone everything you see on those dashboards. Create your charts or pipelines to transform

  •

    How can I create a basic dashboard?

    Here you will find some examples that will be useful when building your own dashboard

    Saving charts on your clipboard

    Before you start creating your first dashboard, it's useful you preselect the charts that you want to work with using the clipboard. The clipboard allows you to have all the charts

  •

    A short guide to Argentina's Mutual Funds Industry Analysis

    In this short tutorial, we will guide you on calculating ranks of YTD Total Returns for different funds and management companies.

    Alphacast hosts a number of daily updated datasets of Argentinas Mutual Funds Industry. Two weeks ago we began publishing detailed datasets for based on CAFCI daily reports, mostly in

  •

    A short guide to Argentina's Financial and Monetary Data

    There are more than 2.000 datasets in Alphacast, and there are plenty of hidden gems. This is a short "Must see" guide for those interested in Argentina's financial and monetary data.

    **Would you like to know more?