Data Warehousing Fundamentals: A Comprehensive Guide for IT ProfessionalsGeared to IT professionals eager to get into the all-important field of data warehousing, this book explores all topics needed by those who design and implement data warehouses. Readers will learn about planning requirements, architecture, infrastructure, data preparation, information delivery, implementation, and maintenance. They'll also find a wealth of industry examples garnered from the author's 25 years of experience in designing and implementing databases and data warehouse applications for major corporations. Market: IT Professionals, Consultants. |
From inside the book
Results 1-3 of 57
Page 68
... cost by balancing the risks against the benefits , both tangible and intangible ? How can you calculate the ROI and ROA ? How can you make a business case ? It is not easy . Real benefits may not be known until after your data warehouse ...
... cost by balancing the risks against the benefits , both tangible and intangible ? How can you calculate the ROI and ROA ? How can you make a business case ? It is not easy . Real benefits may not be known until after your data warehouse ...
Page 277
... cost of products is available from two systems . In the standard costing appli- cation , cost values are calculated and updated at specific intervals . Your order processing system also carries the unit costs for all products . There ...
... cost of products is available from two systems . In the standard costing appli- cation , cost values are calculated and updated at specific intervals . Your order processing system also carries the unit costs for all products . There ...
Page 357
... Cost Cost Variable Indirect Sales Direct Profit Sales Margin Jan 340 110 230 320 100 Feb 270 90 200 260 100 TIME Multidimensional Domain Structure PRODUCT METRICS Mar 310 100 210 270 70 Apr 340 110 210 320 80 Jan Fixed Cost May 330 110 ...
... Cost Cost Variable Indirect Sales Direct Profit Sales Margin Jan 340 110 230 320 100 Feb 270 90 200 260 100 TIME Multidimensional Domain Structure PRODUCT METRICS Mar 310 100 210 270 70 Apr 340 110 210 320 80 Jan Fixed Cost May 330 110 ...
Contents
The Compelling Need for Data Warehousing | 1 |
The Building Blocks | 19 |
Review Questions | 37 |
Copyright | |
26 other sections not shown
Other editions - View all
Data Warehousing Fundamentals: A Comprehensive Guide for IT Professionals Paulraj Ponniah Limited preview - 2004 |
Data Warehousing Fundamentals: A Comprehensive Guide for IT Professionals Paulraj Ponniah No preview available - 2004 |
Common terms and phrases
aggregate algorithms analysis applications architecture attributes backup business dimensions changes cluster columns complex components create data cleansing data elements data extraction data loading data marts data mining data model data quality data sources data staging data structures data transformation data warehouse environment data warehouse project data warehousing database DBMS decision deployment dimension table dimensional model end-users example fact table Figure files functions incremental loads information delivery integrated interface marketing MDDB methods metrics MOLAP multidimensional OLAP system OLTP online analytical processing operational systems options package diagram performance physical model pilot platform primary key product dimension programs project team queries and reports records relational ROLAP selection server source data source systems specific staging area standards STAR schema strategic information summary techniques tion types usage users values vendors ware Web-enabled data warehouse