Practical thinking on
data, dashboards & automation.

How to Build Row-Level Security in Power BI Using a Bridge Table Pattern

Most RLS tutorials show you the simple “filter by email” approach. But what happens when one user
needs to see 12 departments, and another just sees 2? Here’s the bridge table method we use at
scale — with dynamic filters based on the logged-in user, no hard-coding, and no
“email me when you change teams” maintenance headaches.

Step-by-step guide to creating the compact triangle KPI card layout — the one execs actually stop to read in Monday meetings.

How we replaced a 3-hour Monday morning manual process with a Python script that runs in 90 seconds and emails results automatically.

How to tag 5,000 verbatim responses by sentiment in Python — and turn the output into an exec-ready theme summary without reading every response.

Window functions, running totals, period-over-period comparison, dynamic date filters, and the pivot trick — the five queries I reach for every week.

The setup guide that doesn’t exist anywhere else. Every driver conflict, authentication issue, and DSN config error — documented from a real troubleshooting session.

Merging sheets with mismatched headers, unpivoting transactional exports, and cleaning finance data without touching the source — all in M language.

A practical guide to injecting custom CSS into Qualtrics — hover tooltips, branded layouts, progress bars, and mobile-friendly end-of-survey pages.

How we structured a 5-tab LMS dashboard for a higher-ed client — from course completion funnels to at-risk student flagging — with a tab layout that actually makes sense.

The real story of building Insights Chronicle alongside a day job — first clients, pricing, scope creep, and what I wish I’d known before sending that first cold email.