Home Data Projects Writing Featured Shop Services FAQ About Contact

Featured Work

Here, you’ll find a curated collection of my most impactful pieces, from technical guides that simplify SQL and dashboards, to essays on Medium exploring work, creativity, and everything in between. I’ve also highlighted content from LinkedIn, where I share short-form ideas and career reflections that spark conversation in the data community.

Bringing these pieces together shows the range of my work: practical resources for analysts, thought pieces that reach beyond data, and writing that connects across platforms. Whether you’re here for clear how-tos, deeper reflections, or fresh perspectives on careers and creativity, you’ll find them all in this space.

Explore the features below, and if you’re interested in collaborating or commissioning work, let’s connect.

Data With Sarah •

Power Query for Excel and Power BI: A Practical Guide for Data Analysts

Without Power Query, you’d spend your weeks doing the same manual work over and over. You’d be copy-pasting the same data each week, relying on VLOOKUPs that break every time a column moves. You’d end up rewriting the same cleaning steps in every new workbook and constantly fixing human errors from manual data entry. Most of your time would go toward just preparing the data instead of actually analyzing it.And you don’t need to be technical or know how to code to use Power Query. You just need t...
Data With Sarah •

SQL Dialects Explained: How to Translate Between Different Database Systems

But that leads to a big problem a lot of data analysts and data scientists have to deal with. You learn SQL once, switch companies or tools, and suddenly the code you’ve always used doesn’t run. I used BigQuery in my previous role, and now I use SQL Server, and I had to pick up a few new tricks to get my queries to work. They are not big differences, mind you, but tiny discrepancies that get annoying to have to constantly google.That’s why I made my SQL Dialect Cheat Sheet. I actually made this...