Hi all,

I've been working as a BI analyst/dev/architect for 2 years now and it seems that I still know little of this world.

I've just read the post that a few people mention the SCD (slowly changing dimention) and the temporal tables. This is something so simple and useful but I've never heard about it until today.

So, I'm wondering what else I've been missing out. Do you guys have any tip for me to study on these more "advanced" functions/practices in SQL that can help me on ETL, data management, data integrity, etc?

I'm currently working on the reestructure/re-creation of the whole DW of the company, so, any advice or tip that would help me on that is welcome.