Understand a Semantic Model's Requirements
Before you can begin modeling data, you must understand the business rules, business logic, and business reporting requirements so that you can build a semantic model that fulfill stakeholder needs.
When creating a semantic model, the key objective is to design a model so that users can get the data they need without a complete understanding of the entire business structure, but instead by the specific domains they understand, for example a production manager's understanding of supply chain. A well designed semantic model allow users to query data in the same way that they would ask business questions.
Use this list of questions to help you analyze a semantic model's requirements:
-
What kinds of business questions are business analysts trying to answer?
-
What are the measures required to understand business performance?
-
What are all the dimensions the business operates under? Or, in other words, what are the dimensions used to break down the measurements and provide headers for the reports?
-
Are there hierarchical elements in each dimension, and what types of relationships define each hierarchy?
Answering these questions makes it easier to identify and define the semantic model's objects.