Folder:
108 Data Analysis
File:
108.30.10 Data Analysis - Structural analysis

Structural Analysis

What is the structural analysis?

The "structural analysis", or "level set", is a backwards looking analysis which outputs primarily cohort triangles for overall data and important segments for multiple metrics (Counts, Revenue, AOV, ARPU, etc). Each cohort has summary rows.

Structural analysis was called the "Level Set" at Lucky8 Capital.

In 108.20 Data Analysis - Customer analysis we are always going to do a structural analysis because the segmentation and LTV and cohorts are vitally important.

Purpose of the structural analysis

The structural analysis is done for every job because it gives us an important understanding of the business, drivers, growth, churn, strengths and weaknesses. Most of the data contained in the structural analysis is probably already known to certain individuals inside the client company, but it puts us on the same level so we can provide value. We need to answer the question:
- Are cohorts getting better or worse? Can you quantify that? Can you tell why this is happening?

108.30.10.40 Data Analysis - Structural analysis steps

Inputs

108.30.10.30 Data Analysis - Structural analysis data required

Outputs

108.30.10.20 Data Analysis - Structural analysis outputs

Structural analysis best practices

Segmentation is ultra important

108.30.10.10 Data Analysis - Segmentation is used on every project

Consistency of data across outputs is vital

108.40.30.10 Data Analysis - Data output validation is vital


Source:
  • Me
Graph: