Hi experts,
I have a set of data which only have the snapshots of every quarter end, a simplified one as below:
COMPANY_NAME,
QUARTER,
TYPE,
#YTQ_ANP_USD,
#YTQ_TOTAL_NOP,
#CQ_ANP_USD,
#CQ_TOTAL_NOP
I need to do some analysis on the figures e.g. Year to Year, Quarter to Quarter for specific quarter end.
Should I build a calendar table or a simple hierarchy table e.g. Year, quarter
Any tips is welcomed.