D8LooP - Practise Data Engineering

Preparing your workspaceloading the brief, studio & canvas…

buyersellerlistingorder

SCENARIO

You are modeling the event pipeline for PulseLoop, a product-analytics tool. Events are captured from a device before anyone logs in and must line up with the right person after they sign in — so events keep their anonymous identity and a person is resolved through a stitch mapping.

your ERD must answer

01Every event a device produced — anonymous, before and after login.
02Which person a device’s activity resolves to, once known.
03A user’s activity across all their devices, without double-counting.

out of scopeAttribution · funnels · experiments · PII governance

This exercise’s brief could not be loaded.The guided questions and their model answers come from the review service. It looks like it is not reachable — start it with pnpm dev:api and reload.The canvas below still works, so you can model now and run the review once the service is up.

Build starts here

The brief becomes the left drawer. The canvas stays the build surface.Study is done above. Build the tables here, hit review to validate, then use follow-ups to defend the model.

Practice studio

Ctrl/Cmd + C copyCtrl/Cmd + V pasteCtrl/Cmd + Z undoDelete remove

68%

You built the model in the Studio. Now defend it.Product analytics identity

Design review

The reviewer reads your model.

Preparing your workspaceloading the brief, studio & canvas…

buyersellerlistingorder

SCENARIO

your ERD must answer

01Every event a device produced — anonymous, before and after login.
02Which person a device’s activity resolves to, once known.
03A user’s activity across all their devices, without double-counting.

out of scopeAttribution · funnels · experiments · PII governance

Build starts here

The brief becomes the left drawer. The canvas stays the build surface.Study is done above. Build the tables here, hit review to validate, then use follow-ups to defend the model.

Practice studio

Ctrl/Cmd + C copyCtrl/Cmd + V pasteCtrl/Cmd + Z undoDelete remove

68%

You built the model in the Studio. Now defend it.Product analytics identity

Design review