analytical_pattern

`analytical_pattern`

SQL table: MASTER.ANALYTICAL_PATTERN Reference table of all analytical patterns available in the platform. Each row represents a distinct type of analysis that can be completed, such as Position, Comparison, Composition, Correlation, and so on. Patterns are grouped into families (e.g. descriptive, diagnostic) and identified by a short code and slug. This table is the anchor for future links to personas, question groups, and example questions, enabling users to discover which analyses are relevant to their context.

Dimensions

Name	Type	Key	Description
`pattern_id`	string	✓	Unique URI identifier for the analytical pattern (primary key).
`pattern_code`	string		Short uppercase code for the pattern (e.g. POS, CMP, CMS). Used for compact references and internal lookups.
`pattern_slug`	string		URL-safe slug version of the pattern name (e.g. position, comparison, composition).
`name`	string		Full display name of the analytical pattern (e.g. Position, Comparison, Composition).
`description`	string		Short one-sentence description of what the analytical pattern does.
`description_long`	string		Long-form prose description explaining the pattern in detail, including when to use it.
`pattern_family`	string		High-level grouping of the pattern (e.g. descriptive, diagnostic). Used to cluster related pattern types together in navigation and filtering.
`example_question`	string		A representative natural-language question that this pattern answers. Intended to help users recognise when to apply the pattern.
`typical_inputs`	string		Description of the data inputs typically required to execute this analytical pattern.
`typical_outputs`	string		Description of the outputs or results that this analytical pattern produces.
`typical_output_shape`	string		Suggested chart or table shape for the pattern’s output (e.g. “Parallel bars or comparison table”, “Scatter plot with a fitted line”).

Measures

Name	Type	Description
`count`	count	Total number of analytical patterns matching the current filter context.

Getting Started

Entities

National Atlas

National Capability

National Research

Sovereign Speech

National Developments

Rubrics

Core

analytical_pattern