In this 2-day 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.
Describe OLAP concepts and terminology
Create dimensions, cubes, and measures using the AWM10g tool for deployment with the OLAP analytical tools
Create custom functions and custom measures for analysis
Build analytical reports that access the multidimensional data in the analytic workspace using the Discoverer Plus OLAP tool
Use the Oracle BI Spreadsheet Add-in to query OLAP data in an Excel spreadsheet
Skills Gained
Upon completion of this course you should be able to:
Describe OLAP concepts and terminology
Create dimensions, cubes, and measures using the AWM10g tool for deployment with the OLAP analytical tools
Create custom functions and custom measures for analysis
Build analytical reports that access the multidimensional data in the analytic workspace using the Discoverer Plus OLAP tool
Use the Oracle BI Spreadsheet Add-in to query OLAP data in an Excel spreadsheet
Who Can Benefit
Business Intelligence Developer
Prerequisites
None.
Code:
DB-10G-OLAP
Length:
2 days
Type:
Instructor-Led
Certified By:
Oracle
Tuition:
$1,200
This course is taught by Certified Oracle instructors. There is a difference. Learn More
When you take a certified course with ExitCertified, you are learning from
the creators of the products you use. Our commitment to your IT
community, along with our authorization to deliver certified courses,
ensures you receive a premium training experience.
