Overview of Advanced Analytical Features

In this section, we explain the complex data types supported by different connections, define dimension hierarchies to enable a smooth transition between the hierarchical levels, identify and manage segments for better insights into the data, and define events in a time-stamped dataset to sequence them chronologically.

For advanced analysis, you can create visual types, such as funnels, flows, correlation flows, and histograms, and use advanced visualization techniques, such as trellises, dual-axis line visuals, and hierarchical cross tabulations. On select connection types, Arcadia Data supports several analytic functions that examine overlapping groupings of data:

• Previous Value
• Difference from Previous Value
• Percent Difference from Previous Value
• Next Value
• Difference from Next Value
• Percent Difference from Next Value
• Row Number
• Rank
• Dense Rank
• Moving Average
• Percentage of Group
• Running Total

You can derive data from another report, build computed columns for re-use, and determine weighted averages and other, more complex calculations.

The advanced analytical features of Arcadia Data include:

1. Data modeling of dimension hierarchies, segments, and events.
2. Visual types for analytical analysis: funnels, flows, correlation flows, and histograms.
3. Advanced visualization techniques, such as trellis, dual-axis, dimension hierarchies and hierarchical cross tabulation, and adding highlights to visuals.
4. Analytic functions (on select connection types); see Analytic Functions.
5. Derived Data, which enables the 'stacking' of sub-query analytical results.

This section includes the following topics:

• Complex Data Types
• Dimension Hierarchies
• Segments
• Events
• Visuals for Analytics
• Advanced Visualization Techniques
• Analytic Functions
• Derived Data
• Making Visuals Interactive with Legends