Introduction
Overview and how to use the Know-how section
Introduction
This Know-how section is a growing reference for data analysts. It covers tools, domains, and practices I use day to day.
How to use it
- Look up — Use as a reference when you need a pattern or reminder (e.g. SQL, metrics).
- Explore — Browse categories to see what’s covered and where to go deeper.
- Build on it — Content is meant to be extended; add your own notes and examples.
Categories at a glance
| Category | What you'll find |
|---|---|
| SQL | Queries, patterns, and best practices |
| Tableau | Dashboards and viz in Tableau |
| Power BI | Dashboards and modeling in Power BI |
| Marketing Analytics | Campaigns, attribution, and marketing metrics |
| Web Analytics | GA, tracking, and web metrics |
| Payments Analytics | Cards, Stripe, and payments data |
| Data Pipelines | ETL, orchestration, and pipeline design |
| dbt | Data modeling and transformations |
| Python | Pandas, analysis, and data workflows |
| AI & Agents | LLMs, agents, and AI for analytics |
| Building Evals | Evaluation frameworks and metrics |
| Startup Metrics | North Star, KPIs, and growth metrics |