Rani C Educator · Business Intelligence
All posts Rani C — Yuvijen

Author

Posts by Rani C

7 posts from this author.

Stylised illustration framed on a large laptop screen seen over Reena's shoulder as she stands small at the bottom of the frame. The left half of the screen shows a data grid of many rows, with a man in indigo holding a long metal ruler that has a single slot cut in it, the slot framing one row so that all of its columns show through. The right half shows a matrix visual of categories against months, with a woman in magenta laying stacked translucent coloured sheets over it so that only one cell stays clear.

Analytics

Row Context and Filter Context Walk Into a Tea Stall

Reena writes two formulas. One refuses to run at all. The other runs, returns the same number on all 1,248 rows, and ignores every slicer she owns. Two strangers explain the two kinds of context in DAX, and why each formula was missing one of them.

Rani C 12 min read
Stylised illustration of a tea stall with two oversized props dominating the frame. On the left, three sheets labelled JAN, FEB and MAR are skewered one above the other on a tall metal receipt spike, a downward arrow beside them and a label reading 1,248 rows by 6 columns, taller. On the right, two sheets sit edge to edge joined at the seam by a long-arm stapler, the left sheet labelled SALES and the right labelled PRODUCTS, with a label reading 1,248 rows by 8 columns, wider. Reena stands small in the centre behind her counter looking between the two. A hanging sign above her reads HOME, COMBINE.

Analytics

Merge and Append Walk Into a Tea Stall

Reena has three monthly sales files and a product lookup table. Her cousin wants one dashboard by Sunday. The Power Query ribbon offers two buttons side by side, and picking the wrong one either loses her February or silently doubles her revenue.

Rani C 12 min read
Stylised illustration of a tea stall — Reena stands centre behind her counter looking up at a chalked flowchart on the back wall titled `TWO WAYS TO COPY A QUERY`. The flowchart shows an ORIGINAL chain of three step-boxes (Source, Cleaned, Output), a DUPLICATE chain below it that copies all three boxes identically in plum, and a single REFERENCE box on the right that says `= "Original"` with a curved live-link arrow pointing back up to the ORIGINAL's Output. On the far left a woman in plum holds a thick photocopied folder labelled `ALL STEPS`. On the far right a woman in soft grey holds a small slip with a curved string trailing offstage.

Analytics

Duplicate and Reference Walk Into a Tea Stall

Reena needs two new summary tables off her cleaned sales query. Power BI offers two options that look identical on the right-click menu — and her cousin warns that one of them will quietly break tomorrow.

Rani C 11 min read
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 — Reena standing at her counter in the centre, a tired-looking woman on the left at a small writing desk piled with papers and pre-written profit numbers, a calm man on the right with a small handheld calculator in one hand and a glass of tea on the counter.

Analytics

Calculated Column and Measure Walk Into a Tea Stall

Reena needs a Profit number for Sunday. Two strangers turn up — one who writes it into every row, one who keeps only the formula and presses a calculator when asked.

Rani C 8 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
Stylised illustration of a tea stall scene — a wall-mounted chalk slate shows Reena's weekly tea and samosa numbers with Tuesday struck through; Reena is chalking on it; a woman with a tea strainer is approaching from the left and a man with a wooden menu board is approaching from the right.

Analytics

Slicer and Filter Walk Into a Tea Stall

Reena is preparing her slate for her cousin's visit. Some numbers should never be seen, some should be flipped through — and the difference is the difference between a filter and a slicer.

Rani C 6 min read