To GoodData homepage

Topics started by michal

5 Topics

M
GoodData Employee
michalGoodData Employee
published in Data models - KB articles

Logical Data Model - Five Pro-Tips for Data ModellingLDM Series

Five Data Modeling Pro-Tips We are continuing in our series of articles about Logical Data Model in GoodData, in previous articles you’ve learned first what Logical Data Model in GoodData is, then what objects it consist of and previous article what are the basic rules for creating a viable model. If you have missed any of the articles, please read them before continuing with this one. Today we will show you a few tips you should always follow when designing a Logical Data Model. Here are some more tips to work with LDM in GoodData like a pro: Tip 1: Not all datasets have to be connected. It is possible to have several unrelated “silos” in one data model. You will just not be able to combine the unrelated datasets in a single insight.   Tip 2: The arrows (references) go from Primary Key to the Foreign Key in GoodData (opposite than in most other tools). So do not get confused by this. Each arrow means a one-to-many relationship (with the  tip of the arrow pointing to the “many” side).W

10601
Steve Perkins
1 year ago
M
GoodData Employee
michalGoodData Employee
published in Data models - KB articles

Logical Data Model - Performance ConsiderationsLDM Series

Logical Data Model and Performance This is the final article of the Logical Data Model Series. Today we will focus on impact of the logical data model design to performance. We are continuing in our series of articles about Logical Data Model in GoodData, in previous articles you’ve learned first what Logical Data Model in GoodData is, then what objects it consist of followed by what are the basic rules for creating a viable model and most recently some pro-tips for great models.  If you have missed any of the articles, please read them before continuing with this one. The Logical Data Model does not only affect which insights you can build, but also their performance. And since cost depends on the data volumes loaded into GoodData  as well as the usage, the LDM also affects the cost. So it is good to be smart when designing the data model. Here are some tips to make sure your reports will perform well. Most of these tips are about creating balance between comfort and performance. In g

6220
M
GoodData Employee
3 years ago
M
GoodData Employee
michalGoodData Employee
published in Data models - KB articles

Logical Data Model - Basic Rules of Data ModellingLDM Series

Basic Rules of Data Modeling in GoodData We are continuing in our series of articles about Logical Data Model in GoodData, in this article you will learn basic rules for creating a viable Logical Data Model in GoodData.If you have not done it yet, you should also read the previous articles in this series, starting with: Logical Data Model - Introduction, and continue to Logical Data Model - Objects of the Logical Data Model. Modeling data in GoodData is easy, you just need to follow five simple rules: Model based on your reporting requirements You can filter and slice against the direction of the arrows If an Attribute in the same role belongs into multiple datasets, make it a shared dataset References are mandatory Do not create multiple paths between datasets  Let’s discuss each of these rules now: Model based on your reporting requirements Before jumping into the modeling, you should know your data and you should have an idea about what kinds of reports you want to build on

15131
N
3 years ago
M
GoodData Employee
michalGoodData Employee
published in Data models - KB articles

Logical Data Model - Objects of the Logical Data ModelLDM Series

Objects of the Logical Data ModelWe are continuing in our series of articles about Logical Data Model in GoodData, this time we will describe what objects you can find in the model.If you have not done it yet, you should also read the previous article in this series: Logical Data Model - Introduction where we have explained what Logical Data Model is and why it is important to understand it. Logical Data Model consists of a handful kinds of objects: DatasetDataset is an object in a Logical Data Model. It is a collection of related facts, attributes and references. You can imagine a dataset as a table. (It can physically consist of multiple tables, but on a logical layer, a table is still a very good approximation). Datasets hold the data loaded into them.In the tool for creating Logical Data Models in GoodData, a dataset is displayed as a box. For example, here is a dataset “Product”: AttributeIf you think of a dataset as a table, think of an attribute as a column - more precisely, a c

7691
N
3 years ago
M
GoodData Employee
michalGoodData Employee
published in Data models - KB articles

Logical Data Model - IntroductionLDM Series

Logical Data Model in GoodData - Introduction With this article, we are starting a series about Logical Data Model in GoodData. In several articles, you are going to learn what it is, why you should care about it, how to read it, and how to design it. This is the first part of the series.Logical Data ModelPart 1 - IntroductionPart 2 - Objects of the Logical Data ModelPart 3 - Basic Rules of Data ModelingPart 4 - Five Pro-Tips for Data ModelingPart 5 - Performance Considerations The role of the Logical Data ModelEach Workspace has a Logical Data Model (LDM) which defines what data is available for analysis in that workspace and what the relationships of different data entities (datasets) are. This model defines, structurally, what metrics can be created using MAQL and whether it will be possible to slice and filter them - therefore which insights it will be possible (and not possible) to create. For this reason, you should start building your LDM with reporting requirements in mind.In G

16111
M
GoodData Employee
3 years ago
Welcome to the GoodData Community!Cookie settings