Exploding Data
Exploding data is converting horizontal (pivot-style) data to a vertical record set using an Unpivot command.
- sometimes data is given to you in a cross tab or pivot format
- it is not in the style of a vertical record set
- e.g., data set for product sales performance for each month of the year
- months are set as the first row of the data set
- each value of the products sales for that month appear under the appropriate month column and product row
- can use the pivot to transpose data from horizontal data set to a vertical data set
- makes the data easier to analyze and visualize
Transpose is to reverse the direction of data.
- Unpivot command transposes the values into a vertical record set by converting the month field to an attribute and then listing the actual value in a field labeled “value”