Recently I was invited by Microsoft to write to Portuguese Knowledge Base on SQL Server, more specifically in the Business Intelligence (BI) area. It was an honour and extra motivation for me, despite I’m being increasingly busier and with difficulty to contribute with my BI perspective in the various communities I am currently involved. This is also a challenge to test my capability for manage my time.
My articles on Microsoft's KB will follow a structure of "from theory to practice" in the BI area and they can be less or more detailed and addressing various issues on Data Warehousing, OLAP and Data Mining using tools such as Microsoft SQL Server R2, Excel 2010 , Power Pivot and Sharepoint 2010. This first article focuses on an approach that I typically use to design the date dimension. I hope this article is useful and also contribute for more complex approaches on date dimensions that you may need to implement on your BI System.
Take a look at my first KB article (KB2293691) here and follow this link or press on the image below to download the files refered on the article!
