March 2023 Summaries

Sigma Computing has introduced a new feature to its business intelligence platform: metrics, which allow users to encapsulate aggregate calculations like profit margin or churn rate into reusable fields in their spreadsheets. This feature, now in Beta, is a significant addition to Sigma's interface, which is built on live cloud-scale data and has been widely adopted by companies such as DoorDash, US Foods, and Blackstone. Unlike traditional BI tools, Sigma did not initially require predefined metrics, focusing instead on a spreadsheet interface that appealed to over a billion spreadsheet users globally. The introduction of metrics aims to make data analysis more consistent and scalable, as metrics can be easily created using formulas and updated globally across workbooks without breaking content. This development allows subject matter experts to define metrics, enhancing the platform's usability and enabling analysts to trust and efficiently use shared business logic.

At the Gartner Data & Analytics Summit 2023 in Orlando, discussions centered around the challenges and opportunities in the analytics industry, with a particular focus on overcoming skill gaps, talent shortages, and resistance to change. The event highlighted the critical importance of bridging technology with the people who use it, as emphasized in the inaugural keynote and echoed throughout the summit. AI and machine learning were key topics, with Gartner noting that 80% of companies plan to use "augmented analytics" by year-end, though trust and evaluation hurdles remain significant. Sigma Computing showcased its spreadsheet interface for non-SQL users and engaged with over 300 business professionals, emphasizing the importance of accessible support and real-time interaction. The summit also revealed ongoing issues with data management, such as on-premise storage and inefficient data workflows, underscoring the need for innovative solutions in the evolving analytics landscape.

Sigma presents itself as a modern alternative to traditional data analytics platforms like Domo by emphasizing its cloud-native architecture and real-time interaction with data warehouses. Unlike Domo, which requires data to be extracted, transformed, and loaded into its own infrastructure, Sigma operates directly on data stored in cloud data warehouses, streamlining the process and providing real-time access. This approach reduces management overhead and complexity, enabling both technical and non-technical users to explore and analyze data with a familiar spreadsheet-style interface, thus enhancing user adoption across organizations. Sigma's architecture supports flexible data curation, enhanced security by keeping data within its original warehouse, and integration with other tools, making it a more efficient, secure, and scalable solution for modern data teams seeking to derive insights without the constraints of legacy models.

Sigma's new Fivetran Usage Template, built on Fivetran's Quickstart data models, offers a streamlined approach to monitor Fivetran's cost and performance by transforming and visualizing Log Connector data without the need for coding. This template helps users easily track metrics related to Fivetran's monthly active rows (MAR), allowing for a detailed breakdown of connector costs and identifying anomalies that may lead to unnecessary MAR generation. The setup process is efficient, requiring configuration of the Fivetran Log Connector and Quickstart before deploying the template in Sigma, which provides prebuilt analysis with key performance indicators and detailed cost breakdowns. Users can leverage the template's capabilities, such as identifying days and connectors with an unusual number of active rows and using conditional alerting to catch high spend or performance issues early. While the template serves as a robust starting point, further customization is encouraged, and both Sigma and Fivetran offer free trials to explore these tools.

Evaluating business intelligence tools in 2023 involves navigating a diverse landscape that includes variations in deployment models, expertise requirements, and support packages, with each vendor offering unique approaches. Sisense, founded in 2004, is a notable all-in-one BI, ETL, and DBMS tool, praised for its robust data source connectors and embed capabilities, making it suitable for midsize businesses without existing data warehouses or ETL tools. However, the increasing data volume, prevalence of cloud data warehouses, and demand for self-service analytics challenge the single-tool approach, particularly as the speed of data accessibility becomes crucial. Sisense's on-premise and cloud deployments illustrate the challenges of scalability and cost management, contrasting with cloud-native tools like Sigma, which offer greater flexibility and scalability without the need for physical servers. Key considerations for businesses include their cloud data warehouse strategy, support for all-in-one solutions, and the prioritization of time to value against technical integration requirements.

In a landscape of rising prices and economic uncertainty, financial leaders are increasingly reliant on business intelligence (BI) tools to make real-time data-driven decisions. With the cost of poor-quality data estimated at $12.9 million annually, optimizing BI strategies is crucial for improving efficiency and the bottom line. Sigma, a BI tool designed for Cloud Data Warehouses, empowers non-technical business users to explore massive datasets directly, eliminating the traditional back-and-forth between finance analysts and business users, thus speeding up decision-making. The case of Cowen Inc., a financial services firm, illustrates Sigma's impact, as it significantly accelerated report creation times, eliminated ad hoc requests from analysts, and enabled the analysis of large datasets without data extracts, streamlining compliance and operations.

Cloud-native business intelligence (BI) platforms are increasingly essential for modern data management, offering advantages in compliance support, deployment flexibility, and innovative capabilities. Although Tableau is renowned for its data visualization quality, it lacks true cloud-native capabilities, limiting its deployment options to AWS and its compliance support to HIPAA alone. In contrast, cloud-native platforms like Sigma, which can be deployed on multiple cloud services, support a broader range of compliance standards and enable live querying of cloud data warehouses (CDWs) such as Snowflake without creating data extracts. This approach allows organizations to fully leverage the scalability, performance, and governance of their CDWs, avoiding the inefficiencies and security challenges associated with managing data extracts. As cloud-native solutions foster more efficient, secure, and scalable data handling, organizations should consider pairing cloud-native BI tools with their CDWs to optimize data management and enhance their analytical capabilities.

As March Madness approaches, Sigma offers a customizable workbook designed to help users create informed NCAA tournament brackets by analyzing statistics from every Division I men's basketball tournament game since 2013, alongside current season data. Users can adjust the importance of various statistics such as field goal percentage, points per game, or historical performance, allowing the platform to generate bracket predictions based on individual preferences. Sigma emphasizes its role as a data gateway, enabling users to interact directly with data without needing coding skills, and provides tools like the "Matchup Comparison" and "Bracket Builder" tabs to facilitate deeper analysis. Additionally, the platform hosts a webinar with ESPN Bracketologist Joe Lunardi to guide users on which statistics are most impactful, and encourages participation in both men's and women's bracket competitions, highlighting the opportunity to explore trends and make data-driven predictions.

International Women's Day serves as a powerful reminder of the progress made towards gender equality while also highlighting the ongoing challenges women face globally and in the workplace. This celebration provides an opportunity to acknowledge the unique contributions of women within organizations, particularly in male-dominated fields like technology. Insights from women working at Sigma underscore the significance of pivotal career opportunities and supportive leadership, emphasizing the importance of authenticity, mentorship, and advocacy in professional growth. The narratives shared by Sigma employees reveal the impact of influential leaders and mentors on their leadership styles and career trajectories. The day also prompts reflection on the need for more women in leadership roles and the importance of supporting female colleagues to foster a more inclusive and equitable work environment. Stories of inspiration, empowerment, and resilience from Sigma employees highlight the collective effort to create a supportive and diverse workplace culture that encourages women to succeed and thrive.

ThoughtSpot's promise of using natural language search for business data analysis is critiqued for being ineffective, as it requires extensive training to handle private data unlike Google or ChatGPT which excel in public domain information. Instead, ThoughtSpot uses a "keyword search" similar to a simplified SQL dialect, which can be limiting for complex business questions. In contrast, Sigma, a business intelligence platform, is praised for its intuitive spreadsheet-like interface that allows users to manipulate data as they would in Excel, but on a much larger scale and integrated with cloud data warehouses like Snowflake. Sigma's approach enables users to work live with both clean and raw data, easily incorporate external data sources, and leverage familiar Excel functions like vlookup, fostering a seamless transition for users familiar with spreadsheets. This method provides a unified source of truth without the need to extract data to spreadsheets, and its straightforward governance ensures that data remains live and consistent across the organization.