When you run the queries and load your data into Excel, you can then aggregate, sort, and filter subsets of data to see different views. Excel allows you to insert various types of charts and graphs to view graphical data relationships.
The following Trillium repository metadata can be retrieved and imported into Excel:
Project, entity, and attribute summary metadata (single run and over time, as available within the repository)
Row level data, such as business rule fail rows and business rule group rows
Entity and attribute business rule elements and rule results
Numerical and statistical analysis, including Mean, Total, Median, and Standard Deviation metadata
Analysis data, such as joins, keys, dependencies, and word/phrase analysis
Trillium Quality process metadata, such as values and null distribution, uniqueness, top values, and accuracy