Skip to content

Data Analysis Bible

A searchable wiki for data analysis. DAP (Data Analysis Process), Python, SQL, visualization, AI tooling, soft skills.

Understand the problem before jumping into analysis. Solve the right problem with the right answer and right data.

Quick navigation

  • DAP — Data Analysis Process — six-phase framework, metrics, A/B testing.
  • Python — EDA, pandas, numpy, matplotlib, snippets.
  • SQL — fundamentals, optimization (EXPLAIN), data modeling, snippets.
  • Visualization — chart selection, design principles, dashboard architecture.
  • AI for DA — tools, prompt framework, safety.
  • Tools — tech stack, spreadsheets, git, comparison tables.
  • Templates — SOW, DAF, DASF 2.0 links.
  • Soft Skills — stakeholders, meetings, email format.
  • Resources — cheatsheets, books, tutorials, datasets, practice guide.
  • Glossary — full term glossary, searchable.

Use this site

  • Search anything in the top bar (e.g. "SMART questions", "EXPLAIN ANALYZE", "IQR").
  • Each section has an Overview page, then specific topics.
  • Code blocks have copy buttons.
  • Pages end with References linking authoritative sources.

Source

Long-form notes maintained at github.com/jack2000-dev/DAB, distilled and cross-referenced with primary sources (pandas, PostgreSQL, From Data to Viz, etc.).