Phone: 303-899-4000  A division of Decentrix Inc.
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.

Subscribe
Schedule a webcast
About BIAnalytix
About Decentrix
© Copyright 2001-2010, Decentrix Inc. All rights reserved.
Decentrix Inc. 1200 17th Street, Suite 500, Denver, Colorado, 80202 Phone: 303-899-4000

Privacy Policy | Decentrix Website Solution & Analytic Tools | DishOnTheWeb.com by Decentrix, Dish Network Retailer Solutions
Afftraq Affiliate Sales Tracking Solution | HotDesk, Superior Websites for Small to Medium Size Business

Home Why Business Intelligence Why Data Warehouse Products BIanalytix Toolset Media/Advertising Data Warehouse Best of Breed Products KPIs Dashboards and Portal BIanalytix Features Consulting Industries Advertising Agency Cable MSO Cable Network Radio Satellite Operator Television News FAQ Contact Company