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](https://youtu.be/JxedV_zI7W4) and download the [slides](https://cube.dev/events/data-modeling-workshop.pdf).**

<div><div style={{position: 'relative', paddingTop: '56.25%'}}><iframe src="https://www.youtube.com/embed/JxedV_zI7W4" style={{position: 'absolute', top: 0, left: 0, width: '100%', height: '100%'}} frameBorder="0" allowFullScreen></iframe></div></div>

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](https://cube.dev/events/pre-aggregations/). 

We then jumped into the main part of the workshop by explaining how to use [non-additive vs. additive measures with pre-aggregations](https://cube.dev/docs/recipes/non-additivity#top). 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](https://cube.dev/docs/caching/using-pre-aggregations#pre-aggregation-build-strategies-export-bucket). All the examples had demos to illustrate the topics. Similar to previous workshops, demos were done on [Cube Cloud](https://cube.dev/cloud/), but all features discussed during the workshop are available in [the open-source version of Cube](https://github.com/cube-js/cube.js). 

After a short mid-session Q & A, we continued to talk about [refresh tuning](https://cube.dev/docs/caching/using-pre-aggregations#refresh-strategy) and how to pick the best refresh strategy for your use-case. We then moved on to the topic of [rollup-joins](https://cube.dev/docs/caching/using-pre-aggregations#joins-between-pre-aggregations) which is when you join pre-aggregation rollups instead of the Cubes themselves. Lastly, we covered [pre-aggregations best practices with multi-tenancy](https://cube.dev/docs/product/configuration/advanced/multitenancy).

## 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](https://cube.dev/events/building-data-app/) is now open, so please feel free to [sign up for other events](https://cube.dev/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.

Adnan Rahic

Events

Recapping our Advanced Pre-aggregations Workshop

Our third workshop was on data modeling and it was great to see a large number of atteendees and we were especially impressed with a lot of first time attendees to our workshop. Once again, we want to thank everyone's active participation with your questions throughout the 90-minute session. **If you missed the workshop, you can watch the recording on [our YouTube channel](https://youtu.be/L1FKLBzujvA) and download the [slides](https://cube.dev/events/data-modeling-workshop.pdf).**

<iframe width="888" height="430" src="https://www.youtube.com/embed/L1FKLBzujvA"
title="YouTube video player" frameborder="0" allow="accelerometer; autoplay;
clipboard-write; encrypted-media; gyroscope; picture-in-picture" allowfullscreen></iframe>

We began the workshop with an overview of data schema design, which is a starting point for modeling your data in Cube. Code examples were used to show ways to simplify SQL expressions in your cubes and to simplify your cubes and for reusing code. 

We then discussed data schema [versioning](https://cube.dev/docs/config#options-reference-schema-version) and [compilation](https://cube.dev/docs/schema/reference/execution-environment#context-symbols-transpile) with demos to illustrate both topics. Similar to previous workshops, demos were done on [Cube Cloud](https://cube.dev/cloud/), but all features discussed during the workshop are available in [the open-source version of Cube](https://github.com/cube-js/cube.js). 

Next we showed how Cube allows schemas to be created on-the-fly using a special [asyncModule](https://cube.dev/docs/schema/advanced/dynamic-schema-creation) function. 

Another popular topic in the community is [Joins](https://cube.dev/docs/schema/fundamentals/joins) and after going over basics of Joins in Cube, there was a discussion on where to join data, directionality of joins (with a demo), and [many-to-many joins](https://cube.dev/docs/schema/fundamentals/joins#many-to-many-joins).  

Finally, there was a quick discussion on query-dependent data schema and how you shouldn't let your queries reshape your data in Cube. An example from a [recipe](https://cube.dev/docs/recipes/passing-dynamic-parameters-in-a-query) was shown to demonstrate this, and we encourage everyone to check out [other recipes including ones focused on data schema](https://cube.dev/docs/recipes#recipes-data-schema). 


Ray Paik

Recapping our Data Modeling Workshop

After our successful pre-aggregations workshop in August, the Cube community got together again for a hands-on 
workshop on [multitenancy](hhttps://cube.dev/docs/product/configuration/advanced/multitenancy). We want to thank everyone who attended the 
workshop and also actively participated with your questions and followed the hands-on lab to setup multitenancy in Cube.
**If you missed the workshop, you can watch the recording on
[our YouTube channel](https://www.youtube.com/watch?v=cJUa-D7tVuA) and download the
[slides](https://cube.dev/events/multitenancy-workshop.pdf).**

<iframe width="888" height="430" src="https://www.youtube.com/embed/cJUa-D7tVuA"
title="YouTube video player" frameborder="0" allow="accelerometer; autoplay;
clipboard-write; encrypted-media; gyroscope; picture-in-picture" allowfullscreen></iframe>

We also want to thank everyone who completed the post-event survey and again, I'm heartened that many people were 
willing to spend the time to share your feedback. Your feedback not only let us know how we did with the multitenancy 
workshop, but will also help guide our future events. Hopefully you'll receive your thank you gifts soon! 😊

## Multitenancy Workshop Recap

About half of the registrants didn't have experience with multitenancy in Cube, so we spent the first part of the workshop
discussing key multitenancy concepts (for both front-end and back-end) in Cube and different configuration options
for multitenancy. As we did for the pre-aggregations workshop, we then used [Cube Cloud](https://cube.dev/cloud/) as a lab 
environment for the attendees to get hands-on experience in setting up multitenancy.

We covered the following three scenarios during the lab session: 

1. Filtering queries per tenant using `queryRewrite`. 
2. In multiple databases, using `contextToAppId` to tell which tenant is making the current request and `scheduledRefreshContexts` for building pre-aggregations for all tenants. 
3. Tenant-specific schema and dynamic `scheduledRefreshContexts`

During the hands-on session, you also got a glimpse of how key Cube features such as pre-aggregations support multitenancy. 
Although Cube Cloud was used as it provides a convenient environment for the lab, all features discussed during the workshop are 
available in [the open source version of Cube](https://github.com/cube-js/cube.js).

If you missed the hands-on lab, you can find the code and our front-end app that were used during the workshop in the
[multitenancy workshop directory](https://github.com/cube-js/cube.js/tree/c73db864ad5a4d9610598030deeb01fb304c60f8/examples/multitenancy-workshop) in the Cube.js repo.

Finally, there was a quick review of multitenancy resources that are available for the community including [our documentation](https://cube.dev/docs/product/configuration/advanced/multitenancy) and the growing [recipes](https://cube.dev/docs/recipes). If you have any questions or suggestions for improving our documentation or recipes, please feel free to start a discussion on [Slack](https://slack.cube.dev).

## Next: Data Modeling Workshop in January

Based on the community feedback on post-event surveys for the first two workshops, our next workshop topic will be Data Modeling and
it will take place on January 19, 2022! The registration for the
[Data Modeling workshop](https://cube.dev/events/data-modeling/) is now open, so please feel free to [sign up for events](https://cube.dev/events)
today. 🚀

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.

We hope to see many of you on January 19!

Recapping our Multitenancy Workshop

We had our first Cube community event on August 18th, and I'm excited to report that
the event exceeded our expectations in many ways, including numbers of
registrations (181) and attendees (96) plus the level of interactions with the attendees.
We selected [pre-aggregations](https://cube.dev/docs/caching/using-pre-aggregations) as
the topic for our first workshop based on how frequently it is discussed on our Slack
and in our conversations with community members. So we were pretty confident that this
would be a popular topic, but the level of participation was still beyond what we expected.
**If you missed the workshop, you can watch the recording on
[our YouTube channel](https://www.youtube.com/watch?v=1_BP3B_wbec) and download the
[slides](https://cube.dev/events/pre-aggregations-workshop.pdf).**

<iframe width="888" height="430" src="https://www.youtube.com/embed/1_BP3B_wbec"
title="YouTube video player" frameborder="0" allow="accelerometer; autoplay;
clipboard-write; encrypted-media; gyroscope; picture-in-picture" allowfullscreen></iframe>

Before the event, I was a little concerned that attendees may not ask many questions,
but I was proven wrong in the first 5 minutes as Q&A and Chat tabs were very active from
the beginning. It was definitely nice to see that people were engaged and asked a lot of
good questions throughout the workshop. The level of community engagement was also evident
in the post-event survey, as we heard from nearly half of the attendees. In general,
you're doing pretty well if you reach a 25% response rate on these surveys, so I'm
heartened by how many people were willing to spend the time to provide us with feedback.
In particular, there was some excellent open-ended feedback that will help us with our future events.

## Pre-Aggregations Workshop Recap

We had a good mix of beginners and experienced Cube users in the workshop, so we thought
it made sense to start off with some overview of pre-aggregations before diving into the
hands-on lab. Our soon-to-be-released [Cube Cloud](https://cube.dev/cloud/) provided a
nice lab environment for the attendees, and it was great to see many following along and
getting hands-on experience with pre-aggregations.

![](https://cubedev-blog-images.s3.us-east-2.amazonaws.com/0b6c6cb0-ad99-40cf-b187-f2e7fec02c76.png)

After a quick set up of pre-aggregations on our sample e-commerce database with about 30
million rows of data, we demonstrated the query time go down from about 9 seconds to about
0.1 seconds after pre-aggregations. We then delved into topics such as partitioning,
refresh policy, and rollup joins that you need to consider when you use pre-aggregations.
Finally, we discussed the production checklist that you can use as a reference if you are
deploying your own Cube instance.

The Q&A sessions during the workshop were extremely valuable to us as they helped guide
our discussions. In addition, many of these questions gave us a lot of good ideas on how
we can improve our documentation and provide potential topics for future
[recipes](https://cube.dev/docs/recipes) or
[tutorials](https://cube.dev/docs/examples#tutorials), so please stay tuned for some
great content coming soon.

## Next: Multitenancy Workshop in October

On the post-event survey, more than 70% of people requested
[multitenancy](https://cube.dev/docs/product/configuration/advanced/multitenancy) as a future workshop topic, so that 
will be the workshop topic on October 27th! The registration for the
[workshop](https://cube.dev/events/multitenancy/) is now open, so please feel free to
[sign up for other events](https://cube.dev/events)
today.

As with the pre-aggregation workshop, we included
some 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.

We hope to see many of you on October 27th!

Events

Recapping our Advanced Pre-aggregations Workshop

Recapping our Data Modeling Workshop

Get Cube updates to your inbox

Recapping our Multitenancy Workshop

Looking back on our Pre-Aggregations Workshop

Upgrade your data stack today