COURSE Code: ISDV 545
3 Credits
Course Description
In this hands-on course, students learn how to use the features of OLAP to derive critical information from multidimensional data stored in the Oracle Database, Release 10g. This includes learning OLAP concepts, building an analytic workspace and multidimensional objects with the Oracle Database 10g Analytic Workspace Manager (AWM10g) toolkit, enhancing analytic content, and using tools for OLAP analysis. Students will also learn concepts and terminology, and create dimensions and cubes with the AWM10g. Analytical reports that access the multidimensional data in the analytical workspace will be built using Oracle Discoverer Plus OLAP. Students will learn how to use Discoverer Plus to query, report, and analyze corporate data. They will learn how to use Discoverer Plus Relational to perform ad hoc analyses against relational data sources, and how to use Discoverer Plus OLAP to perform analysis on OLAP data that resides in a multidimensional data source.
