Skip to content
James Krape

Writing

Thinking out loud about leadership, analytics, SQL, systems, craft, and lessons learned along the way.

2 min read

Building Dashboards That Drive DecisionsPlaceholder

Most dashboards get built and then ignored. Starting from the decision instead of the data changes what you build.

  • Analytics / BI
  • Leadership

1 min read

Building a Workbench from ScratchPlaceholder

Building a workbench before you have a workbench, and why the first tool you make should be the one you work on.

  • Craft

1 min read

SQL Patterns I Use Every WeekPlaceholder

Window functions, date spines, and the handful of query shapes that cover most of my analytics work.

  • SQL
  • Analytics / BI

1 min read

Python Automations for AnalystsPlaceholder

Small scripts that remove the repetitive parts of an analyst's week, and how to keep them from becoming a second job.

  • Python
  • Systems

1 min read

The Systems Behind Good DecisionsPlaceholder

Good decisions are rarely one-off judgment calls. They come out of systems that make the right call the easy one.

  • Systems
  • Leadership