September 2024 Summaries

The shift towards a universal semantic layer promises significant benefits for organizations, but managing the accompanying changes is crucial for success. Key factors in this process include establishing a clear vision and communicating it effectively, securing executive sponsorship, assembling a cross-functional team, conducting a thorough needs assessment, developing a comprehensive training program, implementing incrementally and iterating, and monitoring progress and measuring success. By focusing on these organizational change factors, enterprises can fully realize the potential of a universal semantic layer and avoid pitfalls often associated with large-scale data and analytics initiatives.

Cube has released Playground 2.0 in Cube Core, allowing data professionals to build and validate their data models by executing queries and previewing results in a BI-like interface. Additionally, Chart Prototyping is now available in Cube Core, enabling users to create a minimal front-end application that queries Cube via its REST API and visualizes data on charts. Playground 2.0 and Chart Prototyping are available starting from v0.36 of Cube Core.

Cube, an AI-driven data management platform, has been recognized as a fast-moving Leader for GigaOm's 2024 Sonar Report on Semantic Layers and Metrics Stores. The company is dedicated to providing a universal semantic layer that enables consistency, context, and trust in the next generation of data experiences. Cube Cloud, its flagship product, offers a hosted SaaS platform built on an open-source foundation with strong support for various APIs, including AI, MDX, REST, SQL, and GraphQL. The platform's code-first approach allows users to apply software engineering best practices to data management, while its analytics pre-processing features optimize query performance and reduce cloud computing costs. Cube will continue innovating around the universal semantic layer to help organizations unify and deliver trusted data across diverse endpoints.

Cube has introduced support for fiscal and custom time dimension granularities, allowing users to define granularities such as a fiscal year, a fiscal quarter, or a week starting on Sunday for any time dimension. This feature extends the data modeling syntax to support custom granularities and enables their use in queries via all supported APIs. Custom granularities can be used to support various business needs, including weeks starting on specific days, fiscal periods relevant to an industry or accounting policies, and grouping time series data into arbitrary-sized buckets.

Organizations are facing challenges in managing growing data volumes from diverse sources and ensuring consistent analytics across teams. Databricks' Lakehouse provides a unified storage platform for structured, semi-structured, and unstructured data, while Cube offers a universal semantic layer that simplifies data access and interpretation. By integrating Cube with Databricks, businesses can improve collaboration between data and business teams, gain real-time insights at scale, achieve faster time to insight, lower costs, establish governance and compliance, and unlock the full potential of their data for better decision-making.

Cube has partnered with Google to launch Cube Cloud for Sheets, a Google Sheets Add-on that enables users to connect and perform live queries on governed data from any Cube Cloud supported data source. This integration streamlines complex data transformations and allows analysts to focus on deriving insights. Additionally, Cube Cloud is now available on the Google Cloud Marketplace, offering benefits such as speedier procurement, consolidated billing, and simplified EULA terms. The partnership also includes deep integrations with many data and analytics services on Google Cloud Platform, including BigQuery, Dataproc, and various relational database engines within GCP.

Cube Cloud has introduced native support for Google Sheets, allowing users to build reports based on metrics defined in their semantic layer. This integration is available as a public preview and enables users to use Google Sheets as their primary data exploration tool or alongside existing BI tools. The add-on provides a familiar drag-and-drop interface for manipulating metrics, columns, rows, and filters. Cube Cloud for Sheets is available to Premium plan users and can be installed from the Google Workspace Marketplace.

The integration of Cube's universal semantic layer with Google Cloud Platform (GCP) offers businesses a unified, trusted, and scalable analytics experience across the organization. By centralizing data definitions, KPIs, and metrics, Cube ensures that all teams access consistent, accurate, and performance-optimized data. This combination simplifies complexities in data storage and accessibility, streamlines collaboration between data and business teams, provides real-time insights at scale, reduces time-to-insight with optimized costs, and enforces governance and compliance across the entire data stack.

A semantic layer is crucial in a data ecosystem, even with a well-built data model. It ensures consistency by making metric definitions explicit, reducing errors that can occur when writing SQL queries. The abstraction offered by the semantic layer simplifies data retrieval and speeds up development, as users don't need to be proficient in SQL. Semantic layers also improve AI readiness by allowing complex queries to be expressed in plain language, making it easier for AI systems to interact with and analyze data accurately. Security is enhanced through well-defined entities that provide a checkpoint for enforcing access policies. Performance and cost efficiencies are significant benefits of adopting semantic layers, as they increase cache hit probabilities and enable sophisticated caching mechanisms. Overall, the semantic layer offers substantial advantages in consistency, user interface, AI readiness, security, and performance, making it an indispensable component for data-driven organizations.

Organizations are facing challenges in managing growing data volumes, diverse sources, and increasing complexity in their analytics needs. While Snowflake's Data Cloud offers a highly scalable and powerful solution for managing and analyzing data, ensuring consistent data definition, accessibility, and governance across the entire organization is crucial. Cube's universal semantic layer simplifies how data is accessed, queried, and interpreted, providing one place to define business metrics, dimensions, and KPIs in a consistent way. By integrating Cube with Snowflake, companies create a centralized semantic layer where business definitions, metrics, and KPIs are standardized, improving collaboration between data and business teams, enabling real-time insights at scale, achieving faster time to insight and lower costs, and establishing governance and compliance without compromise. Together, Snowflake's Data Cloud and Cube's universal semantic layer provide a reliable, scalable, and consistent data foundation for all an organization's needs.

Cube is hosting its first in-person user event, Cube Rollup, with two geographically convenient locations - London on September 16, 2024, and San Francisco on October 15, 2024. Attendees will learn about the latest innovations in Cube's universal semantic layer, gain exclusive access to new features, receive free product advice from Cube experts, and connect with other Cube enthusiasts. The event aims to inspire, educate, and build connections among data professionals.