When did the spreadsheet quietly become a database - and why that's a problem
Nobody decided to build a database out of that 80-tab workbook - it ended up doing a database's job without any of a database's guarantees.
SQL
// 6 postsTutorials, tips, and deep dives on SQL — every post from bianca.codes tagged SQL.
SQL posts
-
-
Stop Treating SharePoint as a Database - It Will Eventually Bite You
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.
-
What I Wish Someone Had Told Me About Working With Data in a Small Team
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 Not the Right Tool for Every Data Problem
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: The Aggregation That Hands You Back a Table
Table.Group in Power Query returns a table of tables, unlocking complex multi-level analysis you can't get anywhere else.
-
Why 'Just Learn SQL' Is the Wrong Advice for Most Excel Users
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…