February 2019 Summaries

This tutorial series is about building an analytical web application with Cube.js, a popular open-source data analytics platform. The application will collect and store event data from users, display data about its own usage, and provide features such as dashboarding, ad hoc analysis, funnel analysis, retention analysis, A/B tests, real-time events monitoring, and serverless deployment. The project uses Snowplow Cloudfront Collector and Javascript Tracker to collect data, Athena for querying the data, and Cube.js for building analytics reports. The application will be built using React as the frontend framework and will include a full-featured open-source event analytics system with various features such as data collection, dashboarding, ad hoc analysis, funnel analysis, retention analysis, serverless deployment, A/B tests, real-time events monitoring, and more.

The MongoDB connector for BI was released to bridge existing aggregation mechanisms to the MySQL protocol, allowing standard MySQL clients to connect and issue SQL queries on top of MongoDB data. This allows users to leverage modern SQL RDBMS and Data Warehouses associated with aggregation pipeline and MapReduce practices, reducing the need for custom knowledge of how to build and maintain these systems.