D8LooP - Practise Data Engineering

Preparing your workspaceloading the brief, studio & canvas…

buyersellerlistingorder

SCENARIO

You've joined LendCore, a platform for revolving credit lines. Borrowers draw and repay repeatedly, and interest accrues daily on the outstanding balance — so a partial prepayment cuts future interest but not the maturity date. Fees are charged per drawdown and sometimes waived retroactively.

your model must answer

01The current outstanding balance, available credit and accrued interest for a given credit line?
02The daily interest charge for a line on any past date, given the drawdowns, repayments and waivers known as of that date?
03By origination month, total drawn, average utilization and interest income over the first 12 months of each line?

out of scopeCredit decisioning · collections · syndication · covenants · statements

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

Start with the data model, then layer system context

Use entities and relationships for the real ERD. Add notes, containers, or curated cloud shapes only when they sharpen the story you are architecting.

68%

You built the model in the Studio. Now defend it.Loans, drawdowns, and partial prepayments

Design review

The reviewer reads your model.

Preparing your workspaceloading the brief, studio & canvas…

buyersellerlistingorder

SCENARIO

your model must answer

01The current outstanding balance, available credit and accrued interest for a given credit line?
02The daily interest charge for a line on any past date, given the drawdowns, repayments and waivers known as of that date?
03By origination month, total drawn, average utilization and interest income over the first 12 months of each line?

out of scopeCredit decisioning · collections · syndication · covenants · statements

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

Start with the data model, then layer system context

Use entities and relationships for the real ERD. Add notes, containers, or curated cloud shapes only when they sharpen the story you are architecting.

68%

You built the model in the Studio. Now defend it.Loans, drawdowns, and partial prepayments

Design review