Kursangebot
- Upcoming Events
- Garantietermine
- Neue Kurse
- iTLS Academy»
-
iTLS IT Workshops»
- IT-Training by iTLS
- Garantietermine
- Themen im Fokus
- Professional Services
- Hersteller im Fokus
- Amazon Web Services»
- Aruba»
- Barracuda
- Check Point
- Cisco»
- Ethical Hacking
- F5 Networks
- Fortinet»
- Google Cloud»
- ITIL® und Cobit
- Microsoft»
- NetApp»
- Palo Alto Networks»
- VMware»
- Weitere Hersteller»
- Themen/Technologien im Fokus
- Artificial Intelligence (AI)»
- Cloud Computing»
- Cyber Security»
- Data Center»
- Kubernetes / Container»
- Linux»
- Network Analysis / Wireshark»
- Projektmanagement
- Python»
- Software Development»
- Wireless & Mobility»
OR-D70039
Online Training
Dauer 3 Tage
Preis (exkl. MwSt.)
-
Country: AT1.911,- €
Derzeit gibt es keine Online-Termine für diesen Kurs.
Classroom Training
Dauer 3 Tage
Preis (exkl. MwSt.)
-
Österreich:
Country: AT2.010,- €
-
Schweiz:
Country: CHCHF 2.484,-
Derzeit gibt es keine Klassenraum-Termine für diesen Kurs.
Termin anfragenOracle Database 11g: OLAP Essentials (D70039)
Detaillierter Kursinhalt
Examining the Role of Oracle OLAP within the Oracle BI / DW Platform
- Oracle OLAP and the Oracle BI / DW Platform
- Features of the Oracle OLAP Option
- Accessing Oracle 11g OLAP data
Understanding the Dimensional Model
- Stored and Calculated Measures
- Dimensions
- Hierarchies
- Levels
- Attributes
Building OLAP Cubes
- Using the Cube Building Tool
- Creating Dimensions
- Designing Cubes
- Creating Measures
- Mapping to Source Data
- Loading Data
Examining Cube-Organized Materialized Views (Cube MVs)
- Benefits of Cube MV Summary Management
- General Requirements for rewrite to MVs
- Designing Cube MVs
- Using Cube MVs
Creating Calculated Measures
- Examining OLAP Calculation Types
- Using the Calculation Builder
- Creating Common Business Calculations
- Creating Custom Calculations
Using SQL to Query Oracle OLAP Cubes
- Understanding Cube Views
- Querying OLAP Cubes: The Basics
- Leveraging Cube Summaries
- Applying Query Filters
- Joining OLAP and Relational Data
Enhancing Analytic Content
- Creating Cubes with Varying Dimensionality
- Integrating Measures from Data with Different Dimensionality
- Creating Forecast Measures Using OLAP DML
Using Ad Hoc Query and Reporting Tools Against OLAP Data
- Exploring OLAP Data Using Oracle Application Express (APEX)
- Performing Ad Hoc Query of OLAP Data Using Oracle BI Answers
- Examining Metadata Requirements for BI Tools
Implementing Cube Security
- Understanding Authentication Requirements
- Authorizing Access to Cube Data
- Examining User and Object Privileges
- Examining Methods for Scoping User Views of Data
Designing Cubes for Performance and Scalability
- Objectives of Performant and Scalable Design
- Examining how Data is Stored in Oracle Cubes
- Identifying Cube Features that Impact Performance and Scalability
- Implementing Design Techniques for Performance and Scalability
Examining Performance Tuning
- Describing How Cubes are Stored
- Understand Cube Build Processing
- Examining Balanced Configurations
- Correcting Performance Bottlenecks