February 2022 Summaries

Building an analytics dashboard is crucial for organizations to make informed decisions. Open source charting libraries like Chart.js, Recharts, and Apache ECharts can help simplify big-data analytics. This tutorial will guide you through building an e-commerce analytics dashboard using React, Apache ECharts, and Cube. You'll learn how to integrate Cube with ECharts, which offers robust visualizations for data returned by Cube's API. By setting up a sample project, you'll create four charts displaying revenue growth, orders over time, orders by status, and orders by product category name. The tutorial also covers generating a data schema with Cube, combining measures and dimensions to ask questions about the data, and integrating ECharts with React. With this knowledge, you can build an analytics dashboard from scratch and add analytic elements to your existing applications using Cube's headless API layer.

Today, we're happy to announce that Cube Dev is now SOC 2 Type I compliant. This means that Cube Dev has implemented proper systems to ensure the security, availability, processing integrity, confidentiality, and privacy of its customers' data. The company's SOC 2 compliance enables customers to make informed decisions when entrusting external vendors with their data stack. To achieve this, Cube Dev underwent an audit process managed by the American Institute of CPAs (AICPA) that evaluates five Trust Service Criteria: security, availability, processing integrity, confidentiality, and privacy. This certification is considered reputable and helps customers understand Cube's commitment to data security and privacy. With SOC 2 Type I compliance in place, Cube Dev aims to continue investing in security training and oversight, hardening its systems, and growing a team that prioritizes customers' data safety. The company looks forward to complementing this with an SOC 2 Type II certification in the future.

The Bubble platform is an ecosystem of tools for easily creating applications, with a broad offering in terms of functionality and a comprehensive low-code app-building platform. It's suitable for admin panels, internal tools, and client portals. The Bubble API connector allows users to connect to external REST APIs, such as Cube's, to provide analytical capabilities. Cube is an open-source analytics tool that provides an API layer to connect data warehouses to front-end applications. By leveraging the power of Cube, developers can build metrics dashboards that aggregate data from relational databases and display it using Bubble. The dashboard app will display basic business information, such as orders received, customers who created the orders, and the quantity of items requested. The tutorial covers creating a simple metrics dashboard for displaying data extracted from a business database using Bubble, Cube, and PostgreSQL as the database.

If you're a web developer, you likely use bundlers like Webpack, Rollup, or Parcel which transpile JavaScript code with Babel under the hood. However, developers rarely transpile dependencies' code because everything seems to work fine without it, but this can lead to issues. The adoption of ES modules has improved, with native support in browsers and Node.js since 2020, allowing for tree-shaking and smaller bundles. To ensure compatibility with modern and legacy browsers, developers must transpile the code of dependencies, which can be done manually or using tools like optimize-plugin, a readily available tool that takes care of everything. Optimize-plugin provides faster bundling times and smaller bundle sizes by analyzing and bundling code once and then transpiling it for both modern and legacy browsers.

This tutorial teaches how to create a real-time dashboard using Vue.js and the open-source analytics API platform Cube, combined with Apache ECharts for charting and visualization. The process involves setting up Cube on a local machine, creating a new Vue.js project, installing the necessary packages, and generating schema files using the Cube Developer Playground. The tutorial then guides users through creating components to display data in tables and cards, as well as charts using Apache ECharts.

This tutorial provides a comprehensive guide on visualizing data using React Google Charts and Cube, an open-source API for building data apps. It demonstrates how to create a dashboard with charts that explore The Museum of Modern Art's (MoMA) collection data, which is available as a public dataset. Google Charts, a service that offers various visualization types with cross-browser compatibility, is featured alongside Cube, which simplifies accessing data via an API. The tutorial includes practical steps for setting up a Postgres database and creating a Cube app, culminating in the development of an interactive dashboard using TypeScript and React. The tutorial is inspired by previous works such as "A Nerd’s Guide To The 2,229 Paintings At MoMA" by FiveThirtyEight and encourages further exploration of React Google Charts and Cube for future projects.

KazanExpress is a Russian marketplace that offers free one-day delivery to over three million products across 20 categories, catering to both B2C and B2B customers. The platform's warehouse management system (WMS) enables efficient packaging and fast delivery to over 115 cities in Russia. To enhance its analytics capabilities, KazanExpress chose Cube as its solution, which provided insights into seller performance, revenue streams, customer search queries, and product demand. With Cube's support, KazanExpress was able to streamline its workflow, deploying the platform across three stages - feature, development, and production - and integrating it with multiple databases, including Postgres and ClickHouse. The implementation took approximately 3.5 weeks to complete, involving a team of three developers and designers. Looking ahead, KazanExpress plans to expand its analytics offering using Cube, adding more data sources and providing anonymous statistics on shopper behavior.