In this module, we will explore several solutions for handling dates in order to provide accurate representations of the data in your analysis.
Learning Objectives:
- Handle dates using a master calendar
- Create a link table to handle multiple date fields
- Create a date island to handle multiple date fields
- Create a canonical date field to handle multiple date fields
- Learn the value of adding load script flags
- Define a custom fiscal calendar timeframe
- Generate more complex custom calendars (4-4-5 calendar)