Short, practical write-ups on SQL, Power BI, and finance data analytics
I regularly share short technical notes on LinkedIn — a query pattern that solved a real problem, a Power BI trick that saved me an hour, a concept explained the way I wish someone had explained it to me. This page collects every one of them in a single place, and gets a new entry each time I publish.
What the EXISTS operator does, how it differs from IN, and when to reach for it in analytical queries.
Read the full post →Combining result sets with UNION and UNION ALL — the difference, the performance trade-off, and when each applies.
Read the full post →A practical approach to pivoting more than one value column in Power Query without losing row-level detail.
Read the full post →If you'd like to discuss how I can help with your financial analytics, reporting, or data strategy, I'd love to hear from you.