Tall data

Tall data describes a structure in which each distinct measure in a row is contained in a single column. Tall data often results in more rows and fewer columns.

Consider the following table, which represents the same data as earlier, but in a tall structure:

Country Name

Year

Population

Afghanistan

1960

8,774,440

Afghanistan

1961

8,953,544

Afghanistan

1962

9,141,783

Afghanistan

1963

9,339,507

Afghanistan

1964

9,547,131

Australia

1960

10,276,477

Australia

1961

10,483,000

Australia

1962

10,742,000

Australia

1963

10,950,000

Australia

1964

11,167,000

Now, we have more rows (a row for each year for each country). Individual years are no longer separate columns and population measurements are no longer spread across those columns. Instead, one single column gives us a dimension of Year and another single column gives the measure of Population. The number of rows has increased while the number of columns has decreased. Now, the measure of population is at the same level of detail as the individual row, and so visual analysis in Tableau will be much easier.

..................Content has been hidden....................

You can't read the all page of ebook, please click here login for view all page.
Reset
18.118.12.50