data analyst starter pack

Jun 24, 2025

💻 DENV

core

• term
• shell
• OS pkg mgmt

handling Windows 🔗 https://grok.com/chat/af5cec64-d9e7-4ee7-ad7e-e56b189378e4

dev environment on a microsoft surface. my background btw is as a macOS user, homebrew for system package mgmt and pyenv/pipx for python package mgmt, VS Code / Neovim for editing, use a lot of CLIs (litecli) and TUIs (visidata), iTerm for terminal. don't know much about Windows dev, know that WSL is a thing and that Python version mgmt on Windows seems to be in flux. https://peps.python.org/pep-0773/

Python

• version mgmt
• pkg mgmt
• CLI pkg

🔢 DATA

SQL

IN BROWSER SQL

• https://github.com/Spyyy004/SQLPremierLeague-Frontend
• https://selectstarsql.com
• https://pgexercises.com/gettingstarted.html
• https://sql-playground.wizardzines.com/
• https://www.crunchydata.com/developers/tutorials https://sqlime.org/

tools

DATABASES

• DuckDB
• SQLite
• Postgres

CLI

• iPython
• litecli
• pgcli
• sqlite-utils

TUI

• visidata
• Datasette

DATAFRAMES

• Polars
• Pandas

GUI

• DB Browser
• Jupyter
• Marimo
• Data Wrangler

sets

🗄️ analytics.md canonical

• Spotify 2024 https://www.kaggle.com/datasets/nelgiriyewithana/most-streamed-spotify-songs-2024 https://huggingface.co/datasets/vishnupriyavr/spotify-million-song-dataset
• Great Tables https://posit-dev.github.io/great-tables/reference/#built-in-datasets
• housing https://www.zillow.com/research/data/
• Sakila https://github.com/jOOQ/sakila