Although Data Warehousing has been around for over 20 years. I do believe that some basic understanding such as dimensional modelling are essential. New technologies such as JSON and cheaper hardware for storage did have certain impact. However, when we are using SQL to extract data, there are still some constraints to be taken into account, as SQL is declarative language.
One of the most common problem is that the SQL result set is mathematically a set and no order is implied, and calculation based on multiple rows are not supported. The advanced expression such as lag(), lead(), rank(), row_number() try to eliminate this weakness.
However, with a proper modelling, such expressions are not needed and the data model can still be exaplanatory.
On this website I would try to elaborate more on data related technologies and the experience I have gained over the last couple of years.