Master the Date Dimension Like a Time Lord
Recorded on [recording date in 13 Feb 2014 format] at PASS Data Warehousing and Business Intelligence Virtual Chapter (PASS DW/BI VC)
Master the Date Dimension Like a Time Lord
[ll data warehouses need a Date dimension to enable analysis by date. Most DW designers will just use a default one provided by the tools, but what if you need to set up custom holidays or want different calendars, such as Fiscal or Julian? You can have any Date dimension you want by using a single SQL script that can be modified and rerun as necessary to update the dimension. By the end of this session, you'll be a Time Lord in your own company!
Speaker:
Steve Wake is a Sr. BI Consultant at Pragmatic Works with more than 20 years of experience in various IT organizations. Steve has experience in Manufacturing, Retail, Charities, Telecommunications and Financial Services organizations. Steve is also very involved in the local community, blogging at blog.wakebi.com, speaking at events across the country and is currently President of the Denver SQL Server User Group. Steve was also awarded the Outstanding PASS Volunteer for November 2013 by PASS.
Join PASS DW/BI Virtual Chapter at http://bi.sqlpass.org
Follow us on Twitter @PASSBIVC