A common hierarchy in business is an organization chart. However, there are other ways that hierarchies can help you visually analyze SQL data.
For example, you can use a hierarchy to examine how various ingredients contribute to each spending area in your business. You might also want to look at broad demographics for your sales and then see a breakdown of each demographic group's buying.
Hierarchies allow you to see data in groups and subgroups. There is no mathematical analysis comparing one group to another, but you can explore the constituents of any group.
Layout and Icon | Palette | Description |
---|---|---|
Cluster
graph
![]() |
Layouts | Displays data in a recursive and circular set of hubs with spokes. Each hub represents a data point; the spokes show the relationship between the hub value and its satellites. Cluster graphs automatically expand as the viewer of the layout zooms in. |
Organization
chart
![]() |
Layouts | Displays data in a tree structure that reads from top to bottom. Optional expander buttons allow users to expand or collapse levels of the chart. You can use the organization chart to show a cascading set of one-to-many relationships, such as a personnel hierarchy. |
Tree
chart
![]() |
Layouts | Displays data in a tree structure that reads from left to right. You can use the tree chart to show a cascading set of parent-child relationships. Levels on the tree chart can be manually expanded by clicking expander buttons. |