SSD designed for Power BI and Tableau [v0.7 | Draft | 14/11/23] The SSD definition and design has worked towards minimised storage requirements, but where needed has applied limited de-normalisation in order to simplify some queries and improve performance; specifically using flattened tables with pre-calculated fields to maintain/reduce reporting overheads. PowerBI is one of several powerful tools that local authorities increasingly look to for actionable insights; one that we therefore anticipate being harnessed in maximising potential of SSD structured data. This document contains a summarised overview towards relevant discussion points or concerns regarding the powerful combination of SSD and such as PowerBI and Tableau. Contents Indexing:............................................................................................................................................... 2 Data Types: ........................................................................................................................................... 2 Aggregated Tables: ............................................................................................................................... 2 Partitioning: ......................................................................................................................................... 2 Specific to Power BI ................................................................................................................................. 2 Star Schema: ........................................................................................................................................ 2 Avoid Complex Relationships: ..............................................................................................................