# Project 57 Analytics deep dive with ClickHouse

### Task 1: Organization activity

Arc_2025-09-17_13-33_LsmhZisM@2x.png
### Task 2: User activity

We can found what user is most active but we don't know how to see what he actually do

image copy 13.png
### Task 3: Content & feature usage

We don't found the way to find this information in ClickHouse

### Task 4: Onboarding efficiency

image copy 15.png
### Task 5: Explore configiration usage from redocly.yaml

Arc_2025-09-17_15-10_tfNz7Z7u.png
## What made you smile?

- We need some time to undestand that database schema and how to search information in it


## What did you find confusing?

- Some event have organization slug equals '' So data looks wierd
- Some event have strange names


image copy 12.png
image copy 14.png
- Some user is are Identyty id like `auth0|622b662747f4880068fc4ef5`
and sime event have `ann_01D778KQYZ2B7ME52C74RYV2M8` or `usr_xxxxxxx`
This make it hard to agreggate data since one user can have 3 or more ids
- Some data are stored in reunite schemaa and some in default this is explained in docs but lead us to confusion
Since we don't got any results becose we use wrong schema.
- Our Webview not work thrue entire training


Arc_2025-09-17_14-37_VoYnVLZf@2x.png