Dates are the integral part of any data analysis. They help in analyzing the impact of something over a period of time. Thus, it becomes important to handle dates effectively to get actionable business insights. When there is only one date field in the data model, you don’t need to worry, because a single master calendar can serve the requirement, but when there are multiple dates involved in data model, depending on business requirements, you can use one of the following two options:
- Create a separate master calendar for each date: When the business requirement doesn't want to have a common calendar for multiple dates, you should use the separate master calendar for each of the dates. Because you do not have a common master calendar, users may get confused between the master calendars of different dates. Consider the following case:
You can see...
