Course Code
Academic Year
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 11g. This includes learning OLAP concepts, building an analytic workspace and multidimensional objects with the Oracle database 10g analytic workspace manager (AWN11g) toolkit, enhancing analytic content, and using tolls for OLAP analysis. Students will also learn concepts and terminology, and create dimensions and cubes with the AWM11g. Analytical reports and access the multidimensional data in the analytical workspace will be built using Oracle business intelligence enterprise edition (OBIEE). Students will learn how to use OBIEE to query, report, and analyze corporate data. They will learn how to use OBIEE to perform ad hoc analyses against relational data sources, and how to use OBIEE to create dashboards.