In this article
Summary
The sc_nrf_date view helps users utilize the standard National Retail Federation (NRF) breakdown for dates as opposed to a general calendar breakdown that is the default when querying with SQL. This view contains information about a given date and corresponding NRF classifications for day, week, period, quarter, and year.
- View Grain: Day
- Primary (Composite) Key(s): date
- Foreign Key(s): N/A
The main purpose of this view is to help retailers perform period-over-period analysis with standardized dates.
Supported Use Cases
The following use cases are examples and only provide a subset of all potential use cases that can be addressed with data found in sc_nrf_date and other views. This list should not be assumed to be comprehensive.
- I want to see overall profitability for the third week in February over the past 5 years.
- I am interested in seeing how my sales for a given day in a specified quarter compares to the same day in the previous 3 quarters.
When not to use the view
This view is a dimensional view that serves to classify a specific date based on NRF definitions. It should not be used unless this type of analysis is required. Note that the period-over-period analysis afforded by this view will likely differ from the period-over-period analysis when using the default Google BigQuery or Snowflake SQL syntax.
Return to SoundCommerce Retail Modules
Comments
0 comments
Please sign in to leave a comment.