This type of data can be a pain to convert to a proper data set. As is is now, it’s really hard to do anything with it. If this data was in a proper tabular format, it would be easy to summarize it in a similar manner with pivot tables and pivot charts. Salesperson and product should also be in their own column. The year should feature as a piece of data too in its own column. In this example, the sales amounts are scattered over 4 different ranges when they should all be in one column with a descriptive column heading like Sales Amount. It’s usually created by someone who doesn’t know what data should look like and thinks that the data should live in a summarized format because that’s how they want to view it.
You’ve probably come across data that looks something like this before.
0 kommentar(er)
