Data Modeling

Data modeling is surely not a new concept, but it is a key one, especially in the age of big data.  Data modeling emphasizes what data is needed and how it should be organized. Let’s talk about everyone’s favorite topic, Slowly Changing Dimensions.

 

When designing a Power BI, SQL Server Analysis Service Tabular or Azure Analysis Services data model, what are the pros and cons for using Import vs DirectQuery storage mode?