What is a Dimensional Model?

This article introduces the concept of a dimensional model, a key idea in data warehousing and analytics. It starts by explaining that data consists of measurements and their descriptions. The author then deconstructs the term 'dimensional model' by first defining 'model' as a representation of data that captures general concepts in an ideal way for understanding patterns. Next, 'dimension' is explored, drawing parallels to geometric dimensions and extending to characteristics or qualities of data. The article sets the stage for understanding how dimensional models help organize data for business intelligence, focusing on the distinction between facts (measurements) and dimensions (context). It is a foundational piece for anyone learning about data modeling, particularly in IT and technology contexts.