An e-commerce data architecture

Every data source an online business already has, unified in one lakehouse it owns, powering the outputs the team actually uses. This is a worked example, not a template. Every setup is tailored to the business.

Online shop, marketplaces and paid channels.

Accounting & finance

Your Business plans & goals

Inventory

Market & competitor data

Sales Channels

· incl. marketplaces

+ more

CRM

Marketing Performance

+ more

Web tracking

Data Lakehouse

Your central source of truth

Investor & fundraising materials

Board decks, data rooms, metrics

Dashboards

Live KPIs across the business

Custom reports, forecasts & more

Ad-hoc analysis, projections

+ 6 more sources: web tracking, CRM, inventory, market data, your business plans, accounting

How to read this

Left: the sources. Middle: the lakehouse (one place, one definition per number, owned by you). Right: what the business gets out of it. The sources change from client to client; the shape rarely does.

See the hospitality example →

Curious what yours would look like?

I usually sketch the target architecture in the first two weeks, before anything gets built.

Let’s talk

Schedule a call

Curious what yours would look like?

I usually sketch the target architecture in the first two weeks, before anything gets built.

Let’s talk

Schedule a call

Curious what yours would look like?

I usually sketch the target architecture in the first two weeks, before anything gets built.

Let’s talk

Schedule a call