Data Modeling

Data Modeling explores how teams structure information to make it usable, consistent, and insightful. Posts under this tag cover schema design, entity relationships, normalization, and modeling techniques that help translate complex workforce data into clear, actionable insights.

Latest

Diagram showing an organizational hierarchy with layers of employees reporting upwards

Data Modeling · Nov 11, 2025

How Recursive CTEs Unlock Practical, Scalable Navigation of Organizational Hierarchies in SQL

Learn how to use recursive CTEs in SQL to navigate organizational hierarchies, from simple manager–employee trees to full reporting paths, span-of-control views, and headcount rollups.

Richard Feith