March 2022 Summaries

You've successfully added a dashboard to your React application using Recharts and Cube, a Headless BI tool that exposes your application's database via APIs. You used the Cube playground to design your data model, generate code for your dashboard, and customize it with various chart styles and dimensions. The combination of Cube and Recharts allowed you to create a production-ready dashboard quickly, saving hours of coding time. With this tutorial, you've learned how to build a custom dashboard integrated into a React application using the right tools, making analytics more accessible and user-friendly.

Cube has introduced an updated integration with dbt Metrics, allowing users to keep metrics definitions in dbt as the single source of truth while leveraging Cube's caching and access control capabilities. This integration enables users to expose dbt Metrics via SQL, REST, and GraphQL APIs, providing a seamless way to integrate their data applications. With this integration, users can also accelerate their data queries using pre-aggregations, which can improve performance by up to 8x, while implementing row-level security and multitenancy for secure access control. The integration is now available in Cube Cloud or locally with Docker, allowing users to get started quickly.

Apache ECharts is an open-source visualization library that offers twenty different types of charts and bundles several utility components to augment the charts. It prioritizes accessibility, is optimized for mobile devices, and can adequately display large quantities of data. The library has a large and active community behind it, ensuring continuous improvement. However, it lacks official libraries for various frontend web frameworks and mobile platforms, complicating integration. ECharts provides a more extensive list of chart types compared to other libraries like Chart.js, with greater customization capabilities. Integrating Cube with Apache ECharts in an Angular 13 app involves formatting query results into chart data, connecting the database to the Cube app, generating data schemas, building queries, and displaying the results using the ECharts library. The tutorial demonstrates how to create a dashboard that visualizes college majors data, including graduation rates by gender and major category, top majors in each group and category, and more.

The upcoming Advanced Pre-agregations workshop will take place on March 30th, 2022, where attendees can learn about various topics related to pre-aggregations in data modeling. The previous workshop on data modeling was well-received by a large number of attendees, including first-time participants, who actively participated in the Q&A session and have since watched the recording and downloaded the slides. The upcoming Advanced Pre-agregations workshop will build upon the community's feedback, with optional survey questions included in the registration form to ensure that topics are covered that matter most to the audience.