User experience
- Tabular Model vs Multidimensional Cubes
- Excel on SQL 2016 vs SQL 2019
- Adding Measures in Power BI
Query performance
- Engine: Tabular vs Multidimensional
- BI client: Power BI vs Excel
- Limitations: too many columns or too many slicers
Processing performance
- Engine: Tabular vs Multidimensional
- Source: Rowstore vs Columnstore
- Azure Analysis Services (DEV, B1,B2, S)
Data size (compression)
- Data transformation patterns
- Key parameters affecting memory data size