........ 2 Avoid Complex Relationships: .............................................................................................................. 2 Specific to Tableau ................................................................................................................................... 2 Extracts: ............................................................................................................................................... 2 Hierarchies and Joins: .......................................................................................................................... 2 Calculated Fields: ................................................................................................................................. 2 General Best Practices ............................................................................................................................. 3 Data Cleaning: ...................................................................................................................................... 3 Incremental Refreshes| Data Refresh Periods: .................................................................................... 3 Documentation: ................................................................................................................................... 3 Indexing: Indexing on FK and fields expected to underpin key use cases, e.g. date fields. Data Types: Used appropriate data types to reduce storage and improve performance. Avoided use of string type for dates given that a great deal of the SSD is based around date types. Aggregated Tables: Pre-aggregate data at various levels (daily, monthly, etc.) to reduce the amount of data processed during analysis. Partitioning: Though not yet implemented, we’r