The Pentaho Metadata Editor allows you to build metadata models and domains. There is sample data available if you want to test Metadata Editor before importing your own data. This sample data is included in the Pentaho download.
To use the Pentaho Metadata Editor, you must have database administrator (DBA) skills. You need to know how to perform the following tasks: import tables, create relationships between tables, assign aggregations, add categories, and assign security. You should have an extensive knowledge of your databases, and know what type of data your business users want. These skills will allow you to map a business user model (logical model) to a complex relational database. This lets your users create Pentaho reports without a DBA's assistance.