Posts about SQL.
SharePoint Lists are brilliant for what they're designed for and actively dangerous past that scope - and the limits bite when your solution has been accumulating data that matters.
In a small team, you're the analyst, the engineer, the dashboard designer, and the person who explains what a p-value is at the all-hands.
Power Query is a brilliant transformation tool. Most of the M code in production is doing things that belong in DAX, SQL, or Python - and the models are slow and the code is unmaintainable.
Table.Group in Power Query returns a table of tables, unlocking complex multi-level analysis you can't get anywhere else.
The advice is everywhere: if you're serious about data, you need SQL. But for most analysts already working in Excel and Power BI, the gap isn't SQL knowledge - it's data modelling instinct. Here…