A nice document from @Enrique Colomer
I would like to add a few more points -
1. Try and use Mapping Load wherever possible avoiding Left Joins. It adds a new field and automatically drops the mapping table from data model.
2.Use Preceding Load instead of Resident Load. It is faster.
3.Use set analysis replacing complex or nested if-else expressions on the UI.
4. Avoid using expressions like Aggr( ) on the UI unless it is absolutely necessary. Take most calculations and aggregations to script and back end as much as possible.
5. Optimize your charts to avoid duplication of information in multiple places.
6. Under general tab, use calculation condition if users only wants to view the data against some pre-decided filters.
Pallav
