Practical Multidimensional Oracle
by Burleson Consulting
* Learn online analytical
processing (OLAP), data warehousing and data mining.
* Understand SQL for multidimensional databases.
* Construct a data model.
* See Oracle Multidimension (IRI’s "Express").
At last, a concise and understandable course to learn
about multidimensional databases and OLAP without all of the
theoretical jargon and double-talk. This seminar teaches you about
multidimensional databases from the ground-up. Using real-world
examples, and in-class exercises, the student builds a firm
foundation that can be applied to any data warehouse project,
regardless of the complexity. This course is indispensable for
anyone faced with the challenge of using a multidimensional
database for data warehousing, data mining, or Online Analytical
Today more than ever, the
IS professional is expected to provide platforms for analytical
processing of large databases. While academia mires in their
theories of data warehousing, the working professional must
struggle with the real-world application of data warehousing, and
create systems that can be directly translated into working
warehouse and OLAP databases.
Today's IS professional
must insure that they are empowered with the skills to quickly
identify and focus on the salient features of this exciting new
technology. This seminar is indispensable for showing how this new
paradigm fits into the traditional areas of decision
You Will Learn
seminar will introduce the basic concepts of multidimensional
databases and provide a strong foundation for understanding the
plethora of vendors offerings.
Makes this Seminar Unique?
other "overview" seminars, this session explains a complex and
difficult subject in plain English. In addition to being a
practicing academic, the instructor is a seasoned DBA who has
struggled firsthand with this new technology.
Included in the Seminar
intensive approach that insures a complete understanding of data
warehousing, multidimensional database theory and OLAP.
This seminar is indispensable for any IS
professional who is charged with creating and implementing data
warehouses, OLAP systems, and system that require multidimensional
This course was designed by Donald K.
Burleson, an acknowledged leader in Oracle database
administration. Burleson was chosen by Oracle Press to write
five texts, including the authorized edition of Oracle
High-Performance SQL tuning. Burleson Consulting instructors offer decades of
real world DBA experience in Oracle features, and they will share
their Oracle secrets in this intense Oracle MDB
(c) 2007-2013 by Don
Unlike other theoretical courses on data
warehousing, this course emphasizes the pragmatic application of
real-world techniques. Through numerous in-class exercises, the
attendees will understand the overall architectures of
multidimensional databases understand how to predict the
ramifications of using specific vendor products. The course also
covers the issues involved in designing a enterprise-wide data
warehouse and how to effectively manage data redundancy in a
This course has been specifically
designed to be a practical, way to learn about
multidimensional databases, data warehousing and OLAP
It is indispensable for database
professionals who want to objectively explore how to leverage their
investment in this exciting new technology.
9:00 - 10:15 Introduction
Historical overview of decision support
General concepts review
Levels of aggregation
10:30-11:45 Uses for multidimensional
Online analytical processing (OLAP),
1:00-2:15 Accessing the
4 GL tools
SQL for multidimensional
2:30-3:45 Modeling and design
Time series analysis
Constructing a data model
4:00-5:00 Review of major product
Oracle Multidimension (IRIs
Red Brick Warehouse
Forest & Trees (Trizinic)
DSS agent (Microstrategy)