Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.