📄️ Star schema
A star schema is a widely used modeling method in data warehouses.
📄️ Dimensions
For the context.
📄️ Facts
For the events.
📄️ Keys
The key to connect dims and facts. And to make sure things are integer.
📄️ Considerations
Try to model as basic as possible. You probably don't need the following:
📄️ Yaml or JSON
The examples in the documentation are primarily written in YAML (Yet Another Markup Language). This is on purpose, Easy Tabular is meant for a wide variety of Power Users, data engineers and developers. I've seen alot of discussion around using YAML or JSON. We support both, but most users that we have worked with find it easier to learn Yaml than going through the hassle with {} and "" and so on. When you have never used JSON or YAML, JSON can be overwhelming at first, due to all the extra stuff. I know the benefits of using those things, but that's not for everyone. So feel free to use JSON if you want.
📄️ Why a dataplatform
Explanation why one dataplatform with a star-schema in the gold layer is a good idea.