Base tables with details

Databases 101

6 lessons, 15 minutes

Base/Detail is right when you have lots of raw data entries and need a summarized view, different stakeholders need different levels of detail, or you’re building dashboards that need to stay in sync with the underlying data without manual effort. User research synthesis, support ticket tracking, student grade aggregation — all good fits.

UP NEXT

Multidimensional

With the multidimensional schema, many tables (large and small) that are interconnected via relations and formulas. No one table acts as the base or overview.

Next lesson

Databases 101

Databases make your data accessible in different ways. In this course, you’ll learn all about how docs help you view your data where, and how, you want.

6 lessons, 15 minutes total

Was this helpful?

YesNo