This is the two part article series on designing and implementing online analytical processing (OLAP) architecture. In the part-1 of this article series, you learned OLAP database design, options for data warehouse schema design, and key considerations for designing relational data warehouse schema for OLAP applications.

Checkout the part-2 of this article series here, in which I discussed the key considerations for designing facts and dimensions for your OLAP solution. Then, I discussed the guidelines for designing time dimension table. Finally, I discussed about changing dimensions.

This article is published on SSWUG.org.