Calendar tables are possibly my favorite topic in the world of data modeling. I am obsessed with the pursuit of the perfect calendar. Perhaps this is because time is such a powerful and sometimes difficult dimension to master. Just when you think you have it all figured out, some intrepid user throws you a curve ball like deciding they need reporting with all Tuesdays aligned. One thing I know for certain is a good calendar table can solve a lot of problems, and it will be much easier for members of a team to work on each others reports if everyone uses the same calendar and follows some standard practices.