Hands-On: Calculating South America's population growth with Alphacast

Hands-On: Calculating South America's population growth with Alphacast

By Francisco Fernandez

Read more Alphacast Highlights here

South America - Demographics

Alphacast allows you to unlock the details of South America's demographics with ease. Uncover essential data and showcase trends through captivating charts, including insights into the region's most populous countries and those experiencing rapid population growth.. Data is from World Bank.

But that's not all. The World Bank data only shows you how population growth evolved in Latin America and the Caribbean as a whole. But not specifically in South America. That's not a problem because with Alphacast you can compile the data in a few steps by building South America's population growth.

Let's calculate South America's population growth with Alphacast

Step 1: Our starting point is Demographics - Global - World Bank - Demographics. Up to here, just press on Select columns and choose South American countries and the variables "Population, total" and "Population growth (annual %). Finally use the Transform Data option, that will direct you to create a pipeline.


Sin título.png


Sin título.png

Step 2: For the following calculations, it is necessary that each column represents a different country, so the Long to Wide option should be used. In the entity to convert just select "Country" and use the previously selected variables for the values in the columns.

Sin título.png

Step 3: To achieve the ultimate objective of determining the population growth in South America, it is essential to compute the aggregate. This aggregate is defined as the sum of the populations of each country that constitutes this subcontinent.

Calculation: use Calculate Variable to sum all the populations of the countries and get the total population of South America.

Sin título.png

Step 4: Now we are in a position to do the final step: calculate population growth of South America. To achieve this, you only need to utilize the Apply Transform step and select the "Year over Year" option.


Likewise, the previous process can be replicated to calculate the population of not only North America and Central America but also for any continent or subcontinent, including the world's rate.

And here's the final result!

Related insights