Our fourth workshop was on advanced pre-aggregations use-cases. It was great to see a large turnout and we were again especially impressed with a lot of first-time workshop attendees (> 70%) to this event.

Once again, we want to thank everyone's active participation with your questions throughout the session, even though we went over the 90-minute mark by several minutes. We hope you didn't mind!

If you missed the workshop, you can watch the recording on our YouTube channel and download the slides.

We began the workshop with an overview of what pre-aggregations are and what we covered in our first pre-aggregations workshop back in August. You can find links to the slides and recordings from the first workshop on the event page.

We then jumped into the main part of the workshop by explaining how to use non-additive vs. additive measures with pre-aggregations. From there we moved on to explaining how to use pre-aggregations with large queries that span across multiple joined Cubes. The most important part of the workshop was showing how to structure and optimize pre-aggregations by using an export bucket. All the examples had demos to illustrate the topics. Similar to previous workshops, demos were done on Cube Cloud, but all features discussed during the workshop are available in the open-source version of Cube.

After a short mid-session Q & A, we continued to talk about refresh tuning and how to pick the best refresh strategy for your use-case. We then moved on to the topic of rollup-joins which is when you join pre-aggregation rollups instead of the Cubes themselves. Lastly, we covered pre-aggregations best practices with multi-tenancy.

Next: Building Data Applications with Cube in May

Our next workshop topic will be Building Data Applications with Cube and it will take place on May 18th, 2022! The registration for the Building Data Applications with Cube workshop is now open, so please feel free to sign up for other events 🚀

As with previous workshops, we have a few optional survey questions in the registration form (including topics you want to see addressed). We encourage you to answer these questions to help ensure that we cover the topics you care about.