BIAnalytix Tip Summary: Master Data Integration

A corporate data warehouse for a Media BI Analysis system should have all business subsystems contributing. This will normally mean that different subsystems will contribute their own master data for common business dimensions such as Agencies, Advertisers, Sales Offices, etc. However common reporting across these separate operational transactions needs to bring together totals for the same business member (e.g. Ford …). Sometimes, the data supplied from each operational system can include a mapping to a common identifier for all required master records supplying the data for consolidation. Alternatively, the mapping can be defined by directly loading mapping information separately into the data warehouse. These mapping issues and other data management issues for the Master data are often called Master Data Management (MDM) and are implemented in a set of data warehouse tables. Either solution requires that the master tables of each operational system are merged and mapped into a common corporate master table by data management techniques and the resulting mapping loaded into the data warehouse on an ongoing basis.

The corporate mapped record is defined as an additional attribute for the dimension so that analysis occurs over the common identifier which can unify all of the measures from the different operational systems. This is often put into a dimension hierarchy so that the individual operational contributions can be obtained by a drill down from the common consolidated record. Another benefit of Master Data Management as a valuable data cleansing process, is the collecting together of the multiple accounts for the same business member that arise in an operational system over time.

BIAnalytix is an advanced Data Warehouse and Business Intelligence system that supports Master Data Management by either sourcing the record mapping from the incoming data or loading the mapping directly into the data warehouse to provide consolidated reporting across independent media sources.

© Copyright 2011, Decentrix Inc. All rights reserved.
Decentrix Inc. 1200 17th Street, Suite 200, Denver, Colorado, 80202 Phone: 303-899-4000  
 
Decentrix Website Solution & Collaborative Intranet Tools   |   DishOnTheWeb.com by Decentrix, Dish Network Retailer Solutions
Afftraq Affiliate Sales Tracking Solution   |  HotDesk, Superior Website & Intranets for Small to Medium Size Business

Home Products Website Solution Collaboration NetAnalytix e-Commerce Technology Overview Architecture Quickcentrix Quickcentrix Integration Kit Consulting Web Analytics Consulting e-Commerce Consulting Business Intelligence Analytics Decentrix Process Online Marketing Site Visitors Search Engines Register With Yahoo Register With Google Search Engine Ranking Becoming Visible Online Collecting Prospect Lists Checklist Target Market Tours Website Solution Tour Collaboration Tour NetAnalytix Tour BIAnalytix Tour Clients News Press Releases e-Newsletters Contact Support Sales Company Vision Management Team Careers