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”