Business intelligence developers who want in-depth understanding and expert skill levels with OLAP will find that the book takes them significantly beyond product documentation and a wizard-based exposure to the technology. Pittsburgh, PA–August 22, 2009–Multidimensional analysis lies at the heart of modern business intelligence systems. The multidimensional approach to working with data yields user interfaces to slice-and-dice summarized data and to navigate up and down hierarchies. This translates into the ability to display business performance as a function of key drivers and to view results at selectable levels of detail. The Multidimensional Data Modeling Toolkit: Making Your Business Intelligence Applications Smart with Oracle OLAP is the only book that takes the developer under the covers to show exactly what happens inside of Oracle’s analytic workspaces where the multidimensional magic occurs.
Business intelligence developers who want in-depth understanding and expert skill levels with OLAP will find that the book takes them significantly beyond product documentation and a wizard-based exposure to the technology. The book puts the reader on a learning path beginning with a definition and explanation of the benefits of OLAP, and ending with a comparison of multidimensional analysis techniques to other the analytical approaches used in business intelligence applications: data mining and statistics. On this path the reader learns syntax and programming techniques, and discovers the information analysis principles that motivate its use.
The reader will gain a detailed knowledge of the Oracle OLAP DML programming language, they will see a plethora of analytical devices specific to the OLAP approach, they will learn the relationship between the tables in a relational data warehouse and the storage devices employed by OLAP cubes; the Oracle OLAP metadata will be examined. The presentation is couched in terms of practical examples that will benefit any application area, including sales and marketing, finance, customer analysis, and manufacturing.
The content of the book is based on the Oracle 10g database, however, most of the programming statements shown will work with other editions of the database, such as Oracle 9i and 11g, and even earlier editions of the technology found in stand-alone products such as the Express database, Oracle Financial Analyzer, and Oracle Sales Analyzer. So if you are developing business intelligence systems in Oracle or porting from one of these platforms this book gives you helpful information you will use to get the job done.
The analysis principles presented are universal and can be applied to any OLAP system, for example Essbase, Cognos, Business Objects, and Microsoft Analysis Services. So whether you are new to business intelligence or a seasoned practitioner, you should find The Multi-dimensional Data Modeling Toolkit with plenty of valuable insights to offer. The book is available on Amazon or directly from the publisher’s website; eBook also available from www.learn-oracle-olap.com.