Data Warehouse Functions

Comparing Business Intelligence and Data Integration Best-of-breed ...

by Lyndsay Wise ... issue the organization should deal with is identifying how it will manage data cleansing and data integrity functions within the data warehouse over time. ... http:/.../ResearchHighlights/BusinessIntelligence/2006/03/research_notes/TU_BI_LW_03_07_06_1.asp - 19k Summary: There are two types of extract transform and load (ETL) vendors. Business intelligence (BI) vendors integrate ETL functionality into their overall BI framework, while best-of-breed data integration vendors, who provide enhanced ETL functionality, have an increased focus on data cleansing and integrity.

Oracle Warehouse Builder: Better Late than Never?

by M. Reed ... Functions include modeling and design, data extraction, movement and ... and integration of analysis tools are all part of Oracle Warehouse Builder's easy-to ... http:/.../Research/ResearchHighlights/DataWarehousing/2000/04/news_analysis/NA_DW_MFR_04_04_00_1.asp - 7k Summary: Close to a year behind schedule, Oracle released Warehouse Builder to the market. Oracle, in an interesting contradiction in terms, has stated that the product is “already in production at nearly 20 beta sites.” But is it too little too late?

Distilling Data: The Importance of Data Quality in Business ...

by Anna Mallikarjunan ... Data quality functions fall into three categories: data profiling, to analyze ... the transformed records into the destination (typically a data warehouse or data ... http:/.../ResearchHighlights/BusinessIntelligence/2008/10/research_notes/TU_BI_AM_10_20_08_1.asp - 19k Summary: As an enterprise’s data grows in volume and complexity, a comprehensive data quality strategy is imperative to providing a reliable business intelligence environment. This article looks at issues in data quality and how they can be addressed.

Distilling Data: The Importance of Data Quality in Business ...

by Anna Mallikarjunan ... Data quality functions fall into three categories: data profiling, to analyze ... the transformed records into the destination (typically a data warehouse or data ... http:/.../ResearchHighlights/BusinessIntelligence/2009/07/research_notes/TU_BI_AM_07_17_09_1.asp - 21k Summary: As an enterprise’s data grows in volume and complexity, a comprehensive data quality strategy is imperative to providing a reliable business intelligence environment. This article looks at issues in data quality and how they can be addressed.

Using Business Intelligence Infrastructure to Ensure Compliancy ...

by Lyndsay Wise ... and that any key stroke errors and the like are cleansed as they enter the data warehouse, before financial analyses and reporting functions are performed to ... http:/.../ResearchHighlights/BusinessIntelligence/2006/04/research_notes/TU_BI_LW_04_06_06_1.asp - 18k Summary: The 2002 Sarbanes-Oxley Act (SOX) has affected organizations, their data, and their reporting processes, putting a strain on how their financials are managed. Business intelligence solutions provide answers to these issues, allowing organizations to address SOX compliancy.

ERP and WMS Co-Existence: When System Worlds Collide

by Joseph J. Strub ... As shown on the outbound processes chart, there are functions such as order taking ... Inventory data, such as quantity on hand and warehouse location, must be ... http:/.../Research/ResearchHighlights/Erp/2003/06/research_notes/TU_ER_SC_XJS_06_17_03_1.asp - 19k Summary: You are currently using enterprise resource planning (ERP) software. You want to improve your warehouse management and operations and are considering a warehouse management system (WMS) solution. However, there is significant overlap between ERP software and a WMS regarding inventory-related functionalit

Metadata Standards in the Marketplace – Why Do I Care? (And ...

by M. Reed ... DCOM only functions in a Microsoft Windows environment. ... A universal data format for interchange of metadata between data warehouse and business intelligence ... http:/.../Research/ResearchHighlights/DataWarehousing/2000/05/research_notes/MN_DW_MFR_05_16_00_1.asp - 18k Summary: Metadata (“data about data”) is essential for data warehousing. Metadata standards allow different products to interact. Without standards, different vendors’ tools cannot work together seamlessly and the customer’s warehousing effort is greatly complicated.

How to Solve Your Warehouse Woes

by Sherry Fox ... By having access to real-time data, all departments are ... to what’s happening in the warehouse at any ... less important than other business functions, such as ... http:/.../Research/ResearchHighlights/SCM/2008/02/research_notes/TU_SC_SF_02_29_08_1.asp - 16k Summary: Today’s manufacturers and distributors are under immense pressure to ensure their warehouse and supply chain activities are continually operating at peak performance. But before any improvements can be made, they must first develop a warehouse management improvement strategy.

Business Intelligence: Its Ins and Outs

by Mukhles Zaman ... The process of populating data into data warehouse is done through extract transfer load or ETL, which is a set of three separate functions—extract, transfer ... http:/.../ResearchHighlights/BusinessIntelligence/2009/04/research_notes/TU_BI_MZ_04_29_09_1.asp - 24k Summary: In today's highly competitive business climate, the quality and timeliness of business information for an organization is not only a choice between profit and loss, it is a question of survival or bankruptcy. No business organization can deny the inevitable benefits of business intelligence.

Business Intelligence: Its Ins and Outs

by Mukhles Zaman ... The process of populating data into data warehouse is done through extract transfer load or ETL, which is a set of three separate functions—extract, transfer ... http:/.../ResearchHighlights/BusinessIntelligence/2005/04/research_notes/TU_BI_MZ_04_26_05_1.asp - 25k Summary: In today's highly competitive business climate, the quality and timeliness of business information for an organization is not only a choice between profit and loss, it is a question of survival or bankruptcy. No business organization can deny the inevitable benefits of business intelligence.