May 2024 Summaries

Hex, a data science and analytics toolkit, has introduced end-to-end workflows without the need for coding. The platform now supports spreadsheet-style functions, making it more accessible to non-technical users. Additionally, new features such as the no-code Data Browser, Endorsed Statuses, and faster AI have been added. These updates aim to create a collaborative, connected frontend of the data stack where anyone can explore, analyze, and ask questions with ease.

Snowflake's Cortex ML functions enable users to build machine learning models using only SQL, making it easier for large enterprises to adopt ML models. These functions are easy to use and provide security while being accessible to anyone with basic SQL knowledge. Currently, four Cortex ML functions are available, including the forecasting function. Using Hex, a data analysis platform, users can implement these functions by connecting to Snowflake and writing SQL code. The Forecast function automatically uses relevant columns for training and excludes NULL values. Partitioned model training is also possible with an additional line of SQL code in Cortex ML functions.

The text discusses how to build machine learning (ML) models using only SQL through Snowflake's ML functions. These functions are easy to use, provide security, and can be utilized by anyone with basic SQL knowledge. There are currently four available ML functions, including a forecasting function that allows users to train models without specifying individual columns or handling null values. The text also explains how to partition model training for more complex datasets using only one additional line of SQL code. Overall, the integration of Snowflake's ML functions with Hex provides an efficient and accessible way for both ML engineers and SQL analysts to develop models quickly and easily.

ClickUp, a project management software company with over 100,000 paying customers, faced the challenge of adapting to market demands for efficiency in late 2022. The company used data to drive decision making and identified churn as a key focus area. To gain insights into churn, ClickUp moved from ad hoc analysis to operational analytics using Hex, an interactive dashboard tool that allowed various teams across the organization to derive actionable insights specific to their areas of focus. By democratizing data insights and empowering teams with actionable information, ClickUp saved more than a million dollars in churn-related costs and built a more operationally efficient business, driving growth while maintaining profitability.