Excel to SQL: the slowest, surest career pivot

If your working day lives in spreadsheets — sales reports, inventory, accounts — you are closer to a data role than you think. The bridge has a name: SQL. This is the four-week path I give operations people who want to move into analyst work, using the data they already understand.

Why SQL first

Spreadsheets teach you the concepts already — filtering is WHERE, sorting is ORDER BY, pivot tables are GROUP BY. SQL is those same ideas in a more powerful, more employable form. Nothing else on a data job posting appears as reliably.

Week 1: Query one table

Install a free tool (DB Browser for SQLite is enough), load an export from your actual work, and learn to ask questions of it:

SELECT product, SUM(amount) AS total
FROM sales
WHERE order_date >= '2026-01-01'
GROUP BY product
ORDER BY total DESC;

Week 2: Grouping and aggregates

Translate five reports you currently build by hand into queries. Count, sum, average, min, max — with GROUP BY doing the heavy lifting. By Friday of week two, rebuilding a familiar report in one query instead of forty minutes of clicking is the moment the pivot feels real.

Week 3: Joining tables

Split your data into two tables — orders and customers — and put it back together with JOIN. This is the week concepts click or wobble; go slow, draw the tables on paper, and keep every query you write.

Week 4: Put it to work

1. Rebuild one real recurring report as a saved query and use it at work this week.
2. Write a short note describing what the query does — your first portfolio artifact.
3. Skim ten analyst job posts and note how many mention SQL. (Nearly all of them.)
4. Then — only then — consider a structured SQL or analytics course to go further.