КНИГИ ПО АНАЛИЗУ ДАННЫХ

Mark Whitehorn, Mary Whitehorn
Business Intelligence: the IBM Solution
Datawarehousing and OLAP
Издательство: Springer

Цена: DM 120,00 (в мягкой обложке, с компакт-диском)

Coverpage "Business Intelligence" (Бизнес-разведка) является собирательным термином, относящимся к процессам извлечения ценной бизнес-информации из массы данных, существующей на любом предприятии.

В данной книге внимание сосредоточено на двух аспектах "Business Intelligence" и соответствующих программных продуктах компании IBM:
1) хранение информации ("Data Warehousing") - Visual Warehouse (IBM);
2) анализ в реальном времени (OLAP "On-Line Analytical Processing") - DB2 OLAP Server (IBM).

Разобрав понятие хранения информации ("Data Warehousing") и рассмотрев задачи, которые решаются с его помощью, авторы показывают, как установить, проверить и использовать эту программу, чтобы построить пример хранилища информации. Попутно рассматриваются такие темы как

Затем авторы переходят к глубокому рассмотрению OLAP. Они проводят читателя сквозь весь процесс инсталляции, используя тестовые приложения, и демонстрируют, как построить небольшой, но четко формализованный многомерный OLAP-куб.

Таким образом, если Вы - менеджер, испытывающий потребность в сведениях о хранении информации и OLAP, или практик, которому надо научиться понимать и пользоваться этими инструментами, то данная книга снабдит Вас всей информацией, необходимой для получения максимальной отдачи от "Business Intelligence".

Contents:
Acknowledgements
Contents
Introduction
Who are you?
What this book does
Our approach
Your previous experience
So do you need this book?
Disclaimer
Backup
Yo IBM (or `Nobody was ever fired for buying IBM')
Versioning
Who should you be?
Chapter 1 Do you need Business Intelligence?
Do you need Business Intelligence?
What we think you have
Problems addressed by Business Intelligence software
So what is Business Intelligence?
Visual Warehouse
DB2 OLAP Server
Terminology
The ``proof of concept'' (POC) concept
What do you need?
Communications
Overview
What next?
Chapter 2 Installation
Where to install all the bits
First steps
Databases and connectivity
Metadata
Creating the control and target databases
And...
Finally...
The installation
Checking that everything is OK
Recap/overview
Chapter 3 Creating a data warehouse
Overview of what you are about to do next
Which data source to use?
Building a test source
Defining the target database for the warehouse
Business Views
Building a Business View
Running a Business View
Solving problem one
Summary
What do you do next?
Chapter 4 Making a connection to the data warehouse
Making a connection to the data warehouse
Chapter 5 Business Views
Your starting point
Business Views
Status
Status summary
Deleting your work
Scheduling - why schedule?
Time-based scheduling
Testing a schedule
Cascade scheduling
Recap of the Business View story so far
Chapter 6 More about Business Views
Business Views are clever
Business Views can act as sources for other
Business Views
Tree Views
Editions
Setting the number of editions
Chapter 7 Business Views for data transformation
Data transformation
Creating a Business View to transform data
Transformers
Summary
Subjects
Visual Warehouse programs
More summary
Chapter 8 The Work in Progress Window
The Work in Progress Window
Status
Work in Progress
Log
Progress
Summary
Chapter 9 Data from disparate sources
Solving problem two
What are we going to use for demonstration purposes?
What do you need to know before we get started?
Recap
Fundamental information and recursion
The practical bit
Creating a source for the text file
Creating a Business View to pull data together
A totally different recap
Potential problems
Chapter 10 Security
Security
Chapter 11 DataGuide
DataGuide a.k.a. Visual Warehouse Information Catalog
So what is DataGuide?
DataGuide components
Where do we go from here?
How do we move information about the contents of the data warehouse into DataGuide?
Metadata
Getting ready to export to DataGuide
Exporting
DataGuide Administrator
How do we add associated objects?
Creating an object
Adding an object from outside the warehouse
Looking for objects
Help
Further organizational controls
A few other snippets
Summary
Chapter 12 Overview of Visual Warehouse components
Visual Warehouse components
Visual Warehouse Manager
Visual Warehouse Agent
Visual Warehouse Administration Client
Data Warehouse Administrator
Chapter 13 OLAP concepts and terminology
OLAP concepts and terminology
What does OLAP mean?
Dimensions and members
Developing a hierarchy
What about more dimensions?
A cubic perspective
The database grows...
Sparse and dense dimensions
Data collection
Why is this so important?
Summary
Chapter 14 Installing DB2 OLAP Server
Setting the scene
Before starting to install DB2 OLAP Server
Installation
Starting Essbase for the first time
Post-installation tweaks
Troubleshooting
Progress
Chapter 15 Using the ready-built samples
Where you are
Creating the samples
Starting Essbase
Running sample.exe
Starting the Application Manager
Outline Editor
Viewing data
Using Excel
Help
Recap
Closing everything down
Chapter 16 More about the Outline Editor
Where you are
More about the Outline Editor
Dimension types
Hierarchy descriptions
Consolidation objects
Formula objects
What's next?
Chapter 17 Creating your first cube
Creating your first cube
Creating an application
Creating a database
Creating an outline
Adding consolidation objects
Adding dimension types
Saving an outline
Adding data
Recap
Calculating data
Checking the data is present
DB2 tables
Sparse and dense dimensions
Recap
Chapter 18 Data load rules
Rules files
Editing the outline
Building a rules file
Selecting records
Validating a rules file
Saving a rules file
Loading data with a rules file
Summary
Solving problem three
Chapter 19 Anchor dimensions and a few more concepts and pointers
Anchor dimensions
A few more concepts and pointers
Dynamic calculations
Partitioning
Calculating size
Calc Script Editor
Reports
Chapter 20 Visual Warehouse and DB2 OLAP Server symbiosis
Bringing it all together
Last words
Appendix 1 Overviewof data warehousing
Data warehouses
Background
Challenges
Solutions
Summary so far, plus some additional information
Appendix 2 IBM's Business Intelligence solution
Visual Warehouse & DB2 OLAP Server DataJoiner
ETI*Extract
Vality Integrity
Intelligent Miner for Data
Intelligent Miner for Text
Net.Data
DataPropagator Relational & DataPropagator NonRelational
Data Refresher
Appendix 3 The software. Sample files
Appendix 4 Overview of data warehouse components
Index

1999, 289 стр., ISBN 1-85233-085-6, на английском языке

TVP logo