Normalization of data required for DX
【What you need to use data】
What is essential for automation by AI is to make it data-driven
That is.
Data served by the server or created locally
(Individual Excel data) is data-driven.
The necessary items are scattered among other data,
In many cases, it is not in a form that can be used immediately.。
In particular, in the case of local data, it is connected by key items,
It is important to aggregate it in a data table and make it usable.
【Data standardization (normalization)】
Data standardization (normalization)
To normalize it in general, you need to unify the items and use the master
Standardization is necessary, and manual work takes a lot of time and effort.
In addition, while it is called DX, it is originally the most important and mainly used.
There is a situation where the normalization of the lower end data is not progressing.
Even if the upper data can be normalized, the lower end data can be normalized
If we dont make progress, the gap between ideal and reality will not be bridged,
and the result will be unrealistic.,
Therefore, normalization of terminal data and standardization of master are recommended.
After doing so, using the normalized data,
Create trend data (automatic creation).
