All posts

Tag

#data-warehousing

2 posts tagged with “data-warehousing”.

Stylised illustration of a tea stall — Reena standing behind her counter looking at two paper schemas in front of her: a clean Customer→Sales 1:N schema with a green tick, and a messy Order↔Product *:* schema with a yellow warning. A calm woman holding an open hand-fan approaches from the left, and a slightly flustered man holding a tangled red ball of yarn approaches from the right.

Analytics

One-to-Many and Many-to-Many Walk Into a Tea Stall

Reena's Power BI report has thrown a yellow warning at her. One stranger arrives with an open fan. The other arrives with a tangled ball of yarn — and a small wooden plank.

Rani C 9 min read
Stylised illustration of a tea stall scene — Reena stands behind her counter looking down at a thick open notebook with redundant rows and loose pages spilling out, a question mark over her head; a man with a long receipt scroll trailing down to the floor approaches from the left, a woman with a neat stack of three books labelled CUST, ITEM, DATE approaches from the right.

Analytics

Fact and Dimension Walk Into a Tea Stall

Reena's notebook is bursting with repetition. Her cousin wants the data organised the proper way before he comes on Sunday. Two strangers know exactly how to split it.

Rani C 7 min read

Stay in the loop

Follow Yuvijen on LinkedIn.

New posts, research notes, and analytics tips — straight to your LinkedIn feed.

Follow on LinkedIn

linkedin.com/company/yuvijen · no signup needed