Query a Star Schema for Trends over Time
A data mart in the form of star schema provides us with a powerful but easy way to develop SQL for metrics and reports. The typical query will get data from a fact table, join to one or more dimensions, and perform some grouping and aggregations. Very quickly the foundation for a new report can [...]
