What is a mini dimensions? This short video describes mini dimensions and provides examples.
What is a Fact Table? What is a Dimension? This video introduces these key dimensional modeling objects.
Agile software development has become the preferred methodology of countless teams worldwide. The principles behind the agile manifesto serve as the rule book for those of us who claim to be part of this paradigm shift. A quick read through these 12 principles will make it very obvious that agile is about much more than tools. Agile […]
What is a junk dimensions? This short video describes junk dimensions and provides examples.
Data warehouses provide organizations with a knowledgebase that is relied upon by decision makers. ETL (extract, transform, load) is the process that is responsible for ensuring the data warehouse is reliable, accurate, and up to date. This post presents a design pattern that forms the foundation for ETL processes. What are the goals? Before jumping […]
What is a degenerate dimensions? This short video describes these degenerate dimensions and provides examples.
Building anything from houses to software applications requires that we make decisions about how to efficiently convert raw materials into the desired product. Building a home in 1492 started by cutting down raw trees. Today builders use dimensional lumber or prebuilt partitions. Efficiency is gained by streamlining many of the tasks related to building with […]
What is a snowflake dimension? What is an outrigger dimension? This short video describes these two dimension types and provides examples.