Reduce the amount of unneeded data returned in a workbook query by using filters at the dataset level. Filters cut out irrelevant data without being restrictive. Surfacing only the most relevant data makes the process of discovering insights much quicker. When combined with materialization, it also means queries run faster.
Create dataset parameters and use them in worksheets to ensure that the data filters to only the necessary data. For more information see Dataset parameters.
Materializations allows you to write datasets and workbook elements back to your warehouse as tables which can reduce compute costs. Materialization enhances query performance by allowing your data warehouse to avoid recomputing the dataset when it's used by an element or a in descendant Sigma analysis. For more information see Materialization.
Some cloud data warehouses (CDW) have a query results cache that Sigma can use to retrieve query results without incurring additional compute costs. This leads to better performance. For more information see Set a cache duration.
Excessive joins, repeated logic, unused data, and filter overload can slow down your workbook. For performance tips, see How to improve workbook performance in the Sigma Community.
Updated about 2 months ago