Calendar Dimension
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…
Read article