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.
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.
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.
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.
Stay in the loop
Connect with Dr. C. Rani on LinkedIn.
New posts, research notes, and HR-analytics tips — straight to your LinkedIn feed.
Connect on LinkedIn