[billy_bitchtits]

dimensional modeling seems to be a waste of time in many cases, when the end user just wants a flat table they can drop into excel or into a data frame to do some eda/modeling.

if it makes it easier for the data warehouse team to build a kimball model and then put views on top of it to deliver the flat tables, or it works better to build a kimball model because you're going to set powerbi on top of it, fine.

for most data analysts, data scientists, etc. stopping at a dimensional model just leaves them needing to put the pieces together themselves.