One-dimensional tables and two-dimensional tables are really easy to distinguish, believe it or not!

Understanding one-dimensional tables and two-dimensional tables

Mastering and familiarizing with the difference between one-dimensional tables and two-dimensional tables is the right way to open learning Excel.

I. What is a one-dimensional table?

A one-dimensional table is a table composed of attributes and values.

Attributes are also called dimensions.

So, what are attributes? Simply understood, they are the same category, or dimension!

A one-dimensional table can have more than one attribute (dimension) and more than one value, such as a sales table, where date, branch, product, unit of measure, salesman is the attribute, unit price, quantity, amount is the value.

Often the system exports basic data is basically a one-dimensional table.

Second, what is a two-dimensional table?

The two-dimensional table is not designed according to the attributes and values of the table on the two-dimensional table. Usually we often see all kinds of reports are basically two-dimensional table.

Three, the advantages and disadvantages of one-dimensional tables

Advantages:

1. One-dimensional tables are convenient for storing data

2. easy to calculate, analyze

3. data can be reused

Disadvantages:

Poor readability

Four, the advantages and disadvantages of two-dimensional tables

Advantages:

Easy to read and clear at a glance

Disadvantages:

Poor re-utilization of data.

It is more difficult to calculate and analyze the data at a later stage.

Fifth, what occasions with a one-dimensional table, what occasions with a two-dimensional table

A one-dimensional table is usually used to collect raw data, basic data, record flow, and other reason for detailed information.

The two-dimensional table is usually used as the final report, provided to the report user to facilitate the report reader to quickly grasp the important information, summarize or categorize the information, analysis or decision-making information.