Microsoft Power BI Training
- 18k Enrolled Learners
- Live Class
Metadata is data about data. Though the second term is used in the preview of types like technical, business and process. It maps the physical data structure to a more logical business model. In the video it has the domain model and the metadata terms.
The domain model has elements like Email, Person & Priority. The metadata terms include items like Subject, Receive Date, Sent Data, Sent From, Sent to, Priority Level and Priority Type. It is the data that describes Business Intelligence like:
Pentaho Metadata Editor Tool – It’s a tool for designing the metadata model. It maps the physical structure to the business model so that the business user understands it. This mapping between physical and logical data is stored in centralized repository.
It creates business-specific data dictionary that facilitates better understanding of the model. Here, the business terms is on top of the data terms in order to be understandable. One can also define what kind of access we can give to the user and what object we want to expose to. We can also localize the language.
We first have to assign to which database we must connect to and the data model has business terms. The sample metadata model contains customers and the order details.
The relationships are defined as one-to-many, many-to-one, many-to-many and so on.
Got a question for us? Mention them in the comments section and we will get back to you.