One Model Terms - Cheat Sheet

This is a cheat sheet reviewing general terms One Models will use in requirements gathering, data transformation, and data validation.

Metrics: quantitative measurements, e.g. number of hires, percentage of mature workers, termination rate of high performers. There is no limit to the number of metrics you can create in One Model, but typically, more data sources equals more metrics. We use recommended naming conventions, but customers have full control over naming and any changes are instant. Specific types of metrics include:

  • Table metrics: metrics that are built off of additional columns found in tables

  • Calculated metrics: metrics where other metrics are used in the metric definition as part of a calculation, or a single table-based metric is used simply to be filtered upon as opposed to a field.

     

Dimensions: attributes of your data used for grouping and/or filtering metrics, e.g. Work Location, Employment Type, Diversity. Dimensions are created and edited by One Model to your specifications. Again, there is no limit to the number of dimensions, and they can be one level (e.g. Gender = Male, Female, Other at same level) or multiple level (e.g. Location = region > country > city across three levels, e.g. North America > Illinois > Chicago).

  • Levels: hierarchical groupings within dimensions, where Level 1 is the highest level of a hierarchy and Level 2 would be subgroups within Level 1, Level 3 would be subgroups within Level 2, etc.

  • Nodes: selectable values in each level of a dimension.

 

Tables: structures in which data is organized as additional columns for various purposes. Specific types of tables include:

  • Fact: these tables are used for metric creation and will typically have the rawest level of data. Some fields in this table will link to dimension tables.

    • Period Based Metrics (prd_): These are for metrics that span time (i.e. Headcount, FTE, etc)

    • Event Based Metrics (evt_): These are for point in time metrics that accumulate across time (i.e. Terminations, Hires, etc.)

  • Dimension: Used for dimensions; In One Model, a dimension is needed if you want to filter the data; if not, you may be able to use an additional column in a fact or model table.

    • Dimension (dim_): these are the general dimension tables.

    • Time Dimensions (tme_): Time is a specific type of dimension table that allows us to dynamically report on data as of the specific time period.

    • SCD Dimensions (scd_): Specific type of dimension table that allows for tracking of hierarchical dimension changes overtime

  • Model (mdl_): for non metric tables that are defined by the create model command in the processing script. These tables are often used for places where there is a many to one join on a specific date to avoid duplication in the fact table.

 

Additional columns: columns or fields within a table which store information. Metrics and dimensions are built using additional columns. Additional columns are used to join different tables as well.

Was this article helpful?

0 out of 0 found this helpful

Comments

0 comments

Please sign in to leave a comment.