Audience and level
Analysts, controlling, IT-adjacent roles with strong Excel backgrounds. SQL and Python beginners welcome. Intermediates who want maintainable scripts. No data-science hype, office reality instead.
Duration and format
1 to 2 days, optionally SQL focus day one and mix on day two. Blocks of 90 to 120 minutes, exercises on anonymised CSV/export samples. Remote with a second monitor or in-house, 4 to 12 participants recommended.
Topics
- SQL: SELECT, JOIN, aggregates, data quality checks
- Python: light pandas (no overkill), import, cleanup
- Pitfalls: types, duplicates, missing keys
- Export back to Excel or for reports
- Documentation and reproducible runs
- Boundary: when Excel, Power Query, SQL, Python fit
Sample agenda (2 days)
- Day 1: Understand the data model, read and write SQL queries
- Day 2: Python script for import and validation, handover
Typical issues we address
Common symptoms: spreadsheets hitting their row limit or taking minutes to open. Copy-paste chains between sheets where nobody knows which version is current anymore. Tutorial scripts that worked once and nobody has touched since. We build traceable, repeatable workflows instead of one-off scripts.
Request data workshop
Sketch sources, target report, and team size. I will suggest 1 or 2 days.