The Data Warehouse Toolkit: The Complete Guide to Dimensional Modeling (Second Edition) by Ralph Kimball |
The Data Warehouse ETL Toolkit: Practical Techniques for Extracting, Cleanin by Ralph Kimball |
by Ralph Kimball
|
Mastering Data Warehouse Design: Relational and Dimensional Techniques by Claudia Imhoff |
by W. H. Inmon
|
First, the authors outline the promise--and potential hurdles--of data warehousing. They thoroughly explain the idea of dimensional data, which is used to represent the quantities or attributes that can be queried in a data warehouse. The authors argue that data warehouses need to adapt to changing business conditions and often must be more flexible than planned. They advise building the Enterprise Data Warehouse (EDW) as a series of interlocking data marts (which contain different dimensions). Developers can build part of a solution and add new data marts later. The result is a more adaptable approach to warehousing data.
The heart of Data Warehouse Design Solutions is the descriptions of data warehouses tailored to specific industries--sales, marketing, fulfillment, production, inventory, and capacity--using real-world businesses. The authors offer business models, sample dimensions, database schema, and sample reports for each business area.
Later chapters discuss more advanced areas for data warehousing, including budget tracking, financial reporting (and managerial accounting), and even how to look at profitability and intellectual capital. The authors round out their nuts-and-bolts tour of today's businesses with a summary of the various measures that fit each type of organization. Finally, the authors come back to theory, with some ideas on building effective systems that are fast and that generate easy-to-read reports. The last chapter argues convincingly that their incremental approach to building data warehousing has some distinct advantages. --Richard Dragan
Product Description
"Each chapter is... a practice run for the way we all ought to design our data marts and hence our data warehouses."-Ralph Kimball, from the Foreword.
Let the experts show you how to customize data warehouse designs for real business needs in Data Warehouse Design Solutions.
To effectively design a data warehouse, you have to understand its many business uses. This guidebook shows you how business managers in different corporate functions actually use data warehouses to make decisions. You'll get a rich set of data warehouse designs that flow from realistic business cases. Two top experts show you how to customize your data warehouse designs for real-life business needs including:
* Sales and marketing
* Production and inventory management
* Budgeting and financial reporting
* Quality control
* Product delivery and fulfillment
* Strategic business analysis such as determining market share, rates of return on investment, and other key analytic ratios.
CD-ROM includes
All sample data warehouse designs with accompanying preformatted reports in HTML for specific business uses such as marketing, sales, and financial analysis.
See all Editorial Reviews
Product Details
Would you like to update product info or give feedback on images?
|
|
![]() |
51% buy the item featured on this page: Data Warehouse Design Solutions $52.10 |
![]() |
17% buy Mastering Data Warehouse Aggregates: Solutions for Star Schema Performance $48.65 |
![]() |
15% buy The Data Warehouse Toolkit: The Complete Guide to Dimensional Modeling (Second Edition) $53.15 |
![]() |
10% buy The Data Warehouse ETL Toolkit: Practical Techniques for Extracting, Cleanin $39.85 |
Tags Customers Associate with This Product(What's this?)Click on a tag to find related items, discussions, and people.
|
|
Share your thoughts with other customers:
|
|||||||||||
Most Helpful Customer Reviews
Share your thoughts with other customers: Create your own review
|
|
|
This product's forum
(0 discussions)
Ask questions, Share opinions, Gain insight
Active discussions in related forums
|
||||||||||||||||||||||
|   |   |   |   | |||||||
|
|
You have no recently viewed items or searches.
After viewing product detail pages or search results, look here to find an easy way to navigate back to pages you are interested in. Look to the right column to find helpful suggestions for your shopping session. |
|
| ||
| ||
| ||
| ||