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 [...]
Good Business Intelligence depends on a good Data Warehouse
Good BI, Good DW There are certain components that are essential for a successful Business Intelligence implementation and in this post I want to emphasize the importance of the data warehouse. It’s obviously a foundational component and doing it right requires choosing the right DW model and implementing a quality design. My Baseball Woes I [...]
Core Principles of Data Warehouse Design #5 – 8
Last year I started a sequence of blog posts to discuss what I believe are the core principles you should adhere to when developing a data warehouse. I meant to post them over a period of several weeks, but I only made it through the first half. In order to complete what I start, this [...]
Welcome to my blog! I write mostly about Business Intelligence. I'm speaking at SQL Rally in Dallas on May 10-11.
