Technical Deep Dive2 min read
Star Schema or Snowflake? The Dimensional Modelling Decision
Kimball's classic debate is still meaningful today: star versus snowflake schema and what actually changes in the cloud era.
Tag
Posts tagged SQL Server
Technical Deep Dive
Technical Deep Dive3 min read
dbt Best Practices: Modular Data Transformations
dbt has become the de-facto standard for analytics transformations. Nine practices that turn it from a SQL preprocessor into a sustainable engineering discipline.
Banking & Finance2 min read
Banking Data Warehouse: Critical Architecture Decisions
Data warehouse projects in banking succeed more through architectural discipline than technology choice. Five decision areas that decide the outcome, distilled from BIART's large-bank engagements.