Data Modeling In Sigma

Data modeling can be performed in Sigma using a document type called datasets. Sigma’s datasets are a flexible way to build centralized data definitions and guide data exploration. Sigma balances administrative control with the freedom to find, add, and trust new data. Datasets function as sources of data for workbooks.

Workbooks built on datasets will inherit all changes to the underlying dataset. The benefit of creating a workbook from a dataset is that there is then a single data source that people can build from in a way that ensures that metrics will always be calculated the same way. If there are changes to the calculations, they just need to be updated in the dataset, and all worksheets built on it will inherit that change.