Oracle 11g - OLAP

• Dauer:
  2 Tage
• Lieferart:
  Classroom
• Zielgruppe:
  Business Intelligence Developer
• Vorkenntnisse:
  Oracle SQL, PL / SQL
• Methode:
  Presentation with examples and hands-on labs.
• Kursnummer:
  2023677
• 
  Themen:
  Oracle OLAP is a multidimensional analytic engine embedded in Oracle Database 11g. Oracle OLAP cubes deliver calculations using simple SQL queries. This query performance may be leveraged transparently when deploying OLAP cubes as materialized views – enhancing the performance of summary queries against detail relational tables. Because Oracle OLAP is embedded in Oracle Database 11g, it allows centralized management of data and business rules in a secure, scalable and enterprise-ready platform. Oracle OLAP makes it easy to produce analytic measures, including time-series calculations, financial models, forecasts, allocations, regressions, and more. Hundreds of analytic functions can be easily combined in custom functions to solve nearly any analytic calculation requirement. Oracle OLAP cubes are represented using a star schema design: dimension views form a constellation around the cube (or fact) view. This standard representation of OLAP data makes it easy for any reporting and analysis tool or application - including sophisticated business intelligence solutions, SQL-based development tools and Microsoft Excel - to leverage the power of Oracle OLAP in a simple and productive way. This training shows you how to develop Data Warehousing solutions based on Oracle.

Oracle OLAP and Oracle BI / DW Platform - Architecture of a Data Warehouse and an OLAP Solution - Elements of an OLAP Solution

Defining Measures and Calculations using the Calculation Builder - Loading the Data and Mapping Data to Multidimensional Structures with Dimensions and Hierarchies

Cube Views - Calculations and Aggregations - Filters - Joining Relational and OLAP Data

Cube MV Summary Management - Defining and Using Cube MVs

Implementing Security - Performance Optimization - Cube Maintenance and Management

Marco Skulschus (born in Germany in 1978) studied economics in Wuppertal (Germany) and Paris (France) and wrote his master´s thesis about semantic data modeling. He started working as a lecturer and consultant in 2002.

Veröffentlichungen

• "Oracle PL/SQL" (Comelio Medien, ISBN 978-3-939701-40-8)
• "Oracle SQL" (Comelio Medien, ISBN 978-3-939701-41-5)
• "Oracle PL/SQL - Objektrelationale Techniken" (Comelio Medien, ISBN 978-3-939701-42-2)
• "Oracle, PL/SQL und XML" (Comelio Medien, ISBN 978-3-939701-49-1)

Erfahrung: He works as an IT-consultant and project manager. He developed various Business Intelligence systems for industry clients and the public sector. For several years now, he is responsible for a BI-team in India which is mainly involved in BI and OLAP projects, reporting systems as well as statistical analysis and Data Mining. He led several research projects and was leading scientist and project manager of a publicly funded project about interactive questionnaires and online surveys. He led several research projects and was leading scientist and project manager of a publicly funded project about interactive questionnaires and online surveys.

Projekte: He works as an IT-consultant and project manager. He developed various Business Intelligence systems for industry clients and the public sector. For several years now, he is responsible for a BI-team in India which is mainly involved in BI and OLAP projects, reporting systems as well as statistical analysis and Data Mining. He led several research projects and was leading scientist and project manager of a publicly funded project about interactive questionnaires and online surveys.

Forschung: He led several research projects and was leading scientist and project manager of a publicly funded project about interactive questionnaires and online surveys.

Zertifizierung: Marco Skulschus is "Oracle Certified Associate" and passed the ComptiaCTT+ examination.

Bei der Anmeldung von mehreren Teilnehmern bieten wir Ihnen attraktive Rabatte an. Ab drei Teilnehmern kann sich ein Inhouse-Seminar bei Ihnen lohnen. Gern erstellen wir Ihnen ein individuelles Angebot.
Alle Preise zuzüglich der gesetzlichen Mehrwertsteuer.