Key data concept – dimensional hierarchies
Data will often contain intrinsic dimensionality. The most common example is a date. Dates are usually entered as single values, such as 12-May-2005, but if you think about it, there is an intrinsic dimensional hierarchy you might find useful when building visualizations: year > month > day, for example, but also year > quarter > month > day. Include time and you have additional dimensions.
Independent data attributes, or columns, can also be arranged in a hierarchy. A common example is geography (region > country > province > city). The order of the hierarchy can vary depending on your exact needs for a given situation. Do you want to arrange your music collection as artist > year > album > song or
Get TIBCO Spotfire – A Comprehensive Primer now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.