Determine attributes Dimension tables group related attributes that provide context to business processes. Attributes can be used to describe the “what,” “when,” “where,” “who,” and “how” for any given business process. Analyzing the entity relationship model (ERM) of line of business (LOB) applications Carrying out discovery sessions with business users and subject matter experts Review existing reports and dashboards Analyze forms and instruments that are used to track certain business processes The next step is to group related attributes into dimension tables . Grouping related attributes into dimensions facilitates data filtering, slicing, and dicing. Implement dimensions After you determine attributes and group them into dimensions, you can define the dimension tables in your data warehouse. Each attribute becomes a column in the dimension table and holds specific data type values. Four main types of dimension co...
Comments
Post a Comment