Best practice metadata modeling
The new Data Profile Panel, which is activated by clicking on the binned data at the top of each column (thumbnail chart), displays four types of information.
A Chart Tab visually reflects the number and distribution of records profiled, a Values Tab provides statistics on the values within each column (such as minimum, maximum, median, average, empty and distinct values or outliers), a Usage Tab displays field usage statistics (indicates whether the field is referenced by calculated fields or added to reports) and a
Suggested Actions section dynamically proposes best practice metadata modeling solutions based on the specific data profiled within each column (see below screenshot).
Types of transformations available include the ability to perform numeric and date grouping; apply filters, formatting, Case Statements and Calculated Fields; append, standardize or remove incomplete or inaccurate values; translate values held in the data source into business-friendly terminology (Reference Codes); and assess a data set for attributes (such as zip or post code data) that would enable users to enrich data by adding a Yellowfin GeoPack.
Be empowered to perform repeatable data preparation processes – and deliver more trustworthy and insightful reports throughout the business in less time – with Yellowfin’s best practice metadata modeling.