Fact and Dimension Tables

In data management, **fact tables** and **dimension tables** are used to organize information. A **fact table** contains measurable data, like sales amounts or quantities sold, which can be analyzed. It captures the "what" of business activity. On the other hand, **dimension tables** provide context to the facts by describing the "who," "where," and "when." For example, a dimension table might include customer details or product information. Together, they allow for comprehensive analysis of data, helping organizations make informed decisions by connecting quantitative measures with qualitative context.