Building Dimensional Models met fig - 1 Building Dimensional Models 1 Matrix Method for Getting Started 1.1 Build the Matrix 1.2 Use the 4-step method

Building Dimensional Models met fig - 1 Building...

This preview shows page 1 - 4 out of 14 pages.

Building Dimensional Models 1. Matrix Method for Getting Started 1.1. Build the Matrix 1.2. Use the 4-step method to design Fact Tables 2. Managing the dimensional Modelling Project 2.1. Data Warehouse Bus Architecture Matrix 2.2. Fact Table Diagram 2.3. Fact Table Detail 2.4. Dimension Table Detail 2.5. Steps for the dimensional Modelling Team 2.6. Identifying the Sources for each Fact Table and Dimension Table 2.7. Using a Data Modelling Tool 1
Image of page 1
1. Matrix Method for Getting StartedTo decide which dimensional model to build, we begin with a top-downapproach we call the Data Warehouse Bus Architecture matrix. The matrixforces us to name all the data marts we could possibly build and to name allthe dimensions implied by those data marts.Once we have identified all the possible data marts and dimensions, we canget very specific about the design of individual fact tables within these marts.For each fact table we apply the four-step method described earlier.1.1Build the Matrix The rowsfor the Data Warehouse Bus Architecture matrix are the data martsand the columnsare the dimensionsList the Data Marts (rows in the matrix)To start building the matrix, we list a series of single-source data marts. A single-source data mart is deliberately chosen to revolve around a single kind of data source. In a second step, we propose multiple-source data marts that combine the single-source designs into broader views of the business.Example: Data marts for a large telephone companyPossible candidate set of single-source data martsfor the telephone company:customer billing statementsscheduled service and installation orderstrouble reportsyellow page advertising orderscustomer service and billing inquiriesmarketing promotionscall detail from the billing perspectivecustomer inventorynetwork inventory (switches, lines, computers)real estate inventory (poles, rights of way, buildings,…)labor and payrollcomputer system job processingpurchase orders to suppliersdeliveries from suppliersMultiple-source data martsfor the telephone company might include:combined field operations tracking (service orders, trouble reports, customer/network inventory)customer relationship management (customer billing, customer inquiries, promotion tracking)customer profitability . 2
Image of page 2
Image of page 3
Image of page 4

  • Left Quote Icon

    Student Picture

  • Left Quote Icon

    Student Picture

  • Left Quote Icon

    Student Picture