April 2023 Summaries

Sigma has introduced a new Grid Layout system for its workbooks, designed to provide a more efficient and visually balanced data storytelling experience. Previously, Sigma's layout system allowed for independent element sizing, which often led to difficulties in managing object dimensions and unpredictability across different viewports. The new Grid Layout organizes elements into a responsive grid of rows and columns, enhancing clarity, precision, and spatial symmetry across various screen sizes. This system includes usability features such as multi-select, auto-align, and drag-and-drop capabilities, allowing users to easily modify element positions and layouts. The Grid Layout is available for upgrade during its Beta period, replacing the Classic Layout later in the year, with future updates to include additional functionality such as grouping elements and reordering them within the Page Overview panel.

In 2023, despite advancements in cloud data warehouses, companies continue to rely on spreadsheets for data-driven decision-making due to their simplicity and familiarity. To bridge this gap, input tables have been developed as a user interface enabling users to create and manage tables directly within the data warehouse, thus harnessing the power of cloud technology. These tables allow for seamless data entry, what-if analysis, and context capture, facilitating live collaboration while ensuring performance exceeds that of traditional warehouses. With input tables, data governance is enhanced through built-in security controls and audit capabilities, maintaining data integrity within the warehouse. Currently available for Snowflake connections, input tables offer a scalable solution for integrating user-managed data within a governed framework, with plans to expand compatibility to other data warehouses.

During my tenure as a Snowflake Sales Engineer, I faced two primary challenges from customers establishing new data environments: governing data access and assigning costs to users. At Sigma, we've introduced a solution to streamline these issues. Snowflake's existing security framework includes row-level and column-level security policies, aligning with role-based access control and the Principle of Least Privilege to ensure minimal data exposure. However, cost attribution, linked to virtual warehouses, becomes complex with shared resources. Sigma's User Attributes, launched in January 2023, allows dynamic assignment of Snowflake roles and warehouses to users, thus simplifying cost attribution and resolving concurrency issues by designating specific roles and warehouses to user groups. This feature enables organizations to leverage Snowflake's security policies effectively, allowing distinct teams to access only pertinent data, while also optimizing performance and cost management by distributing workloads across multiple compute clusters. This advancement offers significant benefits, particularly for organizations using BI & Analytics platforms, by improving security, cost visibility, and operational efficiency.

Embedded analytics, as described in Gartner's 2023 Market Guide, is transforming with the rise of low-/no-code interfaces, enabling non-developers to create standalone analytic applications and extending the reach of analytics and business intelligence (ABI) through automated insights like anomaly detection and forecasting. This technology integrates analytics tools directly within applications or websites, allowing users to access insights and make data-driven decisions without leaving the platform, thereby streamlining workflows and enhancing productivity in data-reliant sectors like finance and healthcare. Sigma leverages this approach by offering an easy-to-use spreadsheet interface for its embedded analytics solution, enabling businesses like Greenwich.HR and Slope Software to enhance efficiency and revenue while minimizing the need for additional training. As businesses strive to become more efficient and competitive, embedded analytics is expected to gain traction, offering advantages such as cost-effectiveness, improved customer satisfaction, and simplified data stacks, with Gartner predicting that by 2026, half of all organizations will evaluate analytics, business intelligence, data science, and machine learning platforms as a unified, composable platform.

The Databricks Lakehouse for Manufacturing offers a unified data analytics platform that combines the scalability of a data lake with the performance of a data warehouse, providing manufacturers a centralized solution to manage data from various sources like sensors and ERP systems. By integrating Databricks with Sigma, manufacturers can leverage real-time data insights to address challenges such as supply chain disruptions, quality control issues, and production delays, ultimately enhancing operational efficiency and competitiveness. Key applications include predictive maintenance to prevent equipment failures, inventory optimization to balance stock levels, and quality control improvements by identifying defect patterns early. Sigma's user-friendly interface facilitates self-service analytics, enabling rapid data-driven decision-making without relying on data teams for reports. Together, Databricks and Sigma empower manufacturers to improve productivity, reduce costs, and stay competitive in an ever-evolving market, with Sigma also participating as a Gold Sponsor at the Databricks Data + AI Summit.