Lookup, Lookup!
Blog post from Sigma
Sigma has introduced Lookups and Rollups, new features that allow business users to perform complex data operations in their Workbooks without needing SQL knowledge. Lookups enable users to connect related data elements using spreadsheet-like formulas, allowing for powerful SQL-like joins. Rollups extend this capability by enabling data aggregation across multiple elements, handling tasks that would typically require pivot tables or complex SQL queries. These features operate at cloud scale, handling vast amounts of data, and are designed to be intuitive for users familiar with Excel's VLOOKUP function, offering a familiar yet more powerful experience. The implementation focuses on simplicity and expressiveness, providing a seamless and scalable way for users to conduct ad-hoc analyses directly within Sigma's interface.