Hands on analysing Ecuador fiscal data with Alphacast
By Milagros Ricchini (mricchini@alphacast.io) Read more Alphacast Highlights here In this hands-on guide, we will show you how to use Alphacast Pipelines to automatize Latin American economies' analysis. In this case, we are going to make a graph of Ecuador's fiscal result and calculate its primary expenditure, which is not a variable of the dataset. First, we look for the dataset which contains the variables we need: Fiscal - Ecuador - BCE - Non Financial Public Sector Operations. The data excerpt in the overview of the dataset shows it contains multiple entities, this is useful information for the next steps in this guide, where we are going to transform the data using pipelines and create the graphs we need. So, the next step is to transform de data by clicking on the right top button "Transform Data" Now it's time for action! As we saw the dataset has multiple entities, first we are going to filter the ones we are interested in, which are overall result, primary result, total expenditures and total revenue included into the entity "Totals": When we click "Save & Preview Data" we can see the dataset we have now: As the entities "Fist Level" and "Second...
