Recapping our Data Modeling Workshop

Author avatarRay PaikMarch 8, 2022Events
Recapping our Data Modeling Workshop
Show Original

The next workshop in our series will be on Advanced Pre-aggregations on March 30th, 2022. You can sign-up for this workshop today!

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 and download the slides.

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 and compilation with demos to illustrate both 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.

You can also find the code snippets from the demo on this page. Next we showed how Cube allows schemas to be created on-the-fly using a special asyncModule function.

Another popular topic in the community is 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.

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 was shown to demonstrate this, and we encourage everyone to check out other recipes including ones focused on data schema.

Next: Advanced Pre-aggregations workshop in March

Based on the community feedback on post-event surveys, our next workshop topic will be Advanced Pre-aggregations and it will take place on March 30th, 2022! The registration for the Advanced pre-aggregations workshop is now open, so please feel free to sign up for the workshop 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.

Also, if you did not have a chance to attend the first pre-aggregations workshop back in August, you can find links to the slides and recordings on the event page.

We hope to see many of you on March 30th!

share this article