OLAP enables users to access information from multidimensional data warehouses almost instantly, to view information in any way they like, and to cleanly specify and carry out sophisticated calculations. Although many commercial OLAP tools and products are now available, OLAP is still a difficult and complex technology to master. Substantially updated with expanded coverage of implementation methods for data storage, access, and calculation; also, new chapters added to combine OLAP with data warehouse, mining, and decision support tools Teaches the best practices for building OLAP models that improve business and organizational decision–making, completely independent of commercial tools, using revised case studies Companion Web site provides updates on OLAP standards and tools, code examples, and links to valuable resources
| ||||||||||||
 Trade In this Item for up to £1.05
Trade in OLAP Solutions 2E w/WS: Building Multidimensional Information Systems for an Amazon.co.uk gift card of up to £1.05, which you can then spend on millions of items across the site. Trade-in values may vary (terms apply). Learn more
|
Book Description
Frequently Bought Together
Product details
Would you like to update product info or give feedback on images?
|
More About the Author
Discover books, learn about writers, and more.
Product Description
From the Back Cover
A complete, practical, hands–on guide to mastering OLAP technology "I was awestruck by the range, depth, and quality of this book." –Rick Crandall, OLAP Council Spokesman and Comshare Board Chairman Written in a clear and engaging style by one of the leading experts in the field, this book takes you on a comprehensive and richly illustrated journey from the most basic concepts to the most advanced areas of OLAP technology. The book describes both logical OLAP features, such as dimensions and hypercubes, and physical features, such as storage and access methods, using real–life case studies to illustrate concepts. You can follow these case studies, step–by–step, using the OLAP software provided on the accompanying CD–ROM. Inside this comprehensive resource you′ll find:
∗ An overview of OLAP and its relationship to data warehousing
∗ Complete coverage of multidimensional features, including dimensions, hypercubes, hierarchies, data, links, and formulas
∗ Thorough treatment of how to visualize multidimensional data sets
∗ Practical steps for designing multidimensional information systems
∗ Case studies covering such topics as global planning for sales and marketing, portfolio analysis, air transportation, and cost–benefit analysis for infrastructure projects
∗ Guidelines for evaluating OLAP products, with OLAP vendor and product descriptions
On the CD–ROM you′ll find:
∗ A copy of the OLAP software package used to create the book′s case studies
∗ A functional version of each case study covered in the book
∗ A copy of the product used to create the book′s visualizations
∗ A functional version of the visualizations created in the book
∗ A full listing of major OLAP vendors and tools
Visit our Web site at: http://www.wiley.com/compbooks/ --This text refers to an out of print or unavailable edition of this title.
∗ An overview of OLAP and its relationship to data warehousing
∗ Complete coverage of multidimensional features, including dimensions, hypercubes, hierarchies, data, links, and formulas
∗ Thorough treatment of how to visualize multidimensional data sets
∗ Practical steps for designing multidimensional information systems
∗ Case studies covering such topics as global planning for sales and marketing, portfolio analysis, air transportation, and cost–benefit analysis for infrastructure projects
∗ Guidelines for evaluating OLAP products, with OLAP vendor and product descriptions
On the CD–ROM you′ll find:
∗ A copy of the OLAP software package used to create the book′s case studies
∗ A functional version of each case study covered in the book
∗ A copy of the product used to create the book′s visualizations
∗ A functional version of the visualizations created in the book
∗ A full listing of major OLAP vendors and tools
Visit our Web site at: http://www.wiley.com/compbooks/ --This text refers to an out of print or unavailable edition of this title.
About the Author
ERIK THOMSEN (ethomsen@dsslab.com) is Chief Scientist at DSS Lab, Inc., where he consults on the design and implementation of OLAP–based decision support systems, teaches at corporations and universities, and conducts research in the field of unified information systems. He also writes the "Analytic Solutions" column for Intelligent Enterprise. He is a coauthor of Microsoft OLAP Solutions (Wiley).
Inside This Book
(Learn More)
First Sentence
Before you can appreciate or attempt to measure the value of a new technology, you need to understand the full context within which the technology is used. Read the first page
Front Cover | Copyright | Table of Contents | Excerpt | Index | Back Cover
Before you can appreciate or attempt to measure the value of a new technology, you need to understand the full context within which the technology is used. Read the first page
Explore More
Concordance
Browse Sample PagesConcordance
Front Cover | Copyright | Table of Contents | Excerpt | Index | Back Cover
Sell a Digital Version of This Book in the Kindle Store
If you are a publisher or author and hold the digital rights to a book, you can sell a digital version of it in our Kindle Store.
Learn more
What Other Items Do Customers Buy After Viewing This Item?
Customer Reviews
Most Helpful Customer Reviews
9 of 9 people found the following review helpful
By A Customer
Format:Paperback
A book which gives you a comprehensive theoretical foundation together with useful, pratical techniques to design Olap solutions.
In the first half of the book the author explains you all you need to think clearly in N dimensions, in the second half he guides you through the design of a rather complex application, stepping into the purchasing process, the material inventory analysis, sales & marketing, and activity-based management. He teaches you using maieutics, Socrates' way of teaching, via a dialogue between two designers. This way, a lot of questions that usually arise during real-life development are examined and solved.
Whilst the examples in the first edition of this book were based on TM1, in this second edition they are written using a vendor-independent language, called LC (Located contents), which provides you with a solid, logically based foundation to multidimensional design.
The vendor languages, like those used by Microsoft Analysis Services (MDX), Applix TM1, Oracle Express and Hyperion Essbase, are kind of Plato's shadows in the cavern of this ideal language (which is sort of a tautology for MS Plato...), so if you start thinking in LC, you'll be able to work with all of these products.
Ideal complements to this book, if you use Microsoft Analysis Server, are "MDX Solutions" by George Spofford, and "Microsoft Olap Solutions", by Thomsen (again!), Spofford and Chase.
In the first half of the book the author explains you all you need to think clearly in N dimensions, in the second half he guides you through the design of a rather complex application, stepping into the purchasing process, the material inventory analysis, sales & marketing, and activity-based management. He teaches you using maieutics, Socrates' way of teaching, via a dialogue between two designers. This way, a lot of questions that usually arise during real-life development are examined and solved.
Whilst the examples in the first edition of this book were based on TM1, in this second edition they are written using a vendor-independent language, called LC (Located contents), which provides you with a solid, logically based foundation to multidimensional design.
The vendor languages, like those used by Microsoft Analysis Services (MDX), Applix TM1, Oracle Express and Hyperion Essbase, are kind of Plato's shadows in the cavern of this ideal language (which is sort of a tautology for MS Plato...), so if you start thinking in LC, you'll be able to work with all of these products.
Ideal complements to this book, if you use Microsoft Analysis Server, are "MDX Solutions" by George Spofford, and "Microsoft Olap Solutions", by Thomsen (again!), Spofford and Chase.
Format:Paperback
I was impressed by the quality of this book; this is probably the most complete book on OLAP theory and is a fundamental reading for professionals involved in the design of olap systems. In most cases it gives all the details and information needed to master this technology. It also contains some practical examples that are very useful to see how the theory can be applied in the real world.
I didn't read the first edition, but the second edition contains new sections and many updates, like a description of SQL-99 OLAP extensions.
The author chose to be vendor-independent, so all practical examples are based on a multidimensional language that he created, called Located Contents (LC). However, when I read it I had already used a couple of OLAP tools (Microsoft Analysis Services and Microstrategy), and I think that this helped me understand many of the concepts contained in the book.
I didn't read the first edition, but the second edition contains new sections and many updates, like a description of SQL-99 OLAP extensions.
The author chose to be vendor-independent, so all practical examples are based on a multidimensional language that he created, called Located Contents (LC). However, when I read it I had already used a couple of OLAP tools (Microsoft Analysis Services and Microstrategy), and I think that this helped me understand many of the concepts contained in the book.
3 of 13 people found the following review helpful
By A Customer
Format:Paperback
OLAP technology enables a data analyst to view information in multiple dimensions, e.g., sales by territory by saleperson, by quarter. This is the definitive book on how OLAP works.
Would you like to see more reviews about this item?
›
Go to Amazon.com to see all 21 reviews
4.2 out of 5 stars
Were these reviews helpful?
Let us know
Customer Discussions
|
This product's forum
Search Customer Discussions
|
Related forums
|
Listmania!
|
|
Look for similar items by category
- Books > Business, Finance & Law > Management > Information Management
- Books > Business, Finance & Law > Management > Management Skills > Decision Making
- Books > Computing & Internet > Databases > Data Storage & Management > Database Management Systems
- Books > Computing & Internet > Digital Lifestyle > Online Shopping > Amazon
- Books > Computing & Internet > Software & Graphics
- Books > Science & Nature > Engineering & Technology
Feedback
- Would you like to update product info or give feedback on images?
- I am the Author, and I want to comment on my book.
- I am the Publisher, and I want to comment on this book.
|
