Transforming and Enriching Data

Last updated: June 11, 2026

Tier Deployment
Launch     Grow    Enterprise Cloud     On-Prem

Data transformation and enrichment are critical steps in the analytics workflow, ensuring that raw data is accurate, consistent, and ready for insightful analysis. Sisense provides a range of tools to manipulate, enhance, and augment data before it reaches dashboards or reports. Properly transforming and enriching data allows organizations to deliver cleaner, more actionable insights while maintaining flexibility in handling complex datasets.

The following topics introduce the essential capabilities for transforming and enriching data:

  • Editing Field Formulas — creating calculated fields or modifying existing fields to derive new metrics or apply transformations directly within your data model.

  • Adding a Custom Table — inserting additional tables to complement existing data, supporting new relationships and enriching the dataset.

  • Editing SQL Statements — refining queries to select, filter, or transform data at the source before it enters the data model, ensuring efficiency and accuracy.

  • SQL Reference — comprehensive reference for SQL syntax and functions supported within Sisense, providing guidance for writing effective queries.

  • Previewing Results — validating transformations and queries by previewing the output before committing changes to the data model.

  • Reformatting Data — standardizing formats such as dates, numbers, and text to ensure consistency and usability across dashboards and reports.

  • Enhancing Data — augmenting datasets with additional computed columns, enriched metadata, or external sources to provide deeper analytical context.

  • Augmented Text Deduplication — applying advanced text-processing techniques to identify and remove duplicates or near-duplicates in textual datasets, improving data quality and reliability.

Together, these capabilities allow analysts and administrators to clean, enrich, and transform data, making it ready for accurate reporting, insightful visualizations, and actionable business decisions. By leveraging these tools, organizations can ensure that their datasets are not only complete and consistent but also optimized for advanced analytics.