Course Catalogue
This Data Warehousing Fundamentals training will teach you about the basic concepts of a data warehouse. Explore the issues involved in planning, designing, building, populating and maintaining a successful data warehouse.
Learn To:
- Define the terminology and explain basic concepts of data warehousing.
- Identify the technology and some of the tools from Oracle to implement a successful data warehouse.
- Describe methods and tools for extracting, transforming and loading data.
- Identify some of the tools for accessing and analyzing warehouse data.
- Describe the benefits of partitioning, parallel operations, materialized views and query rewrite in a data warehouse.
- Explain the implementation and organizational issues surrounding a data warehouse project.
- Improve performance or manageability in a data warehouse using various Oracle Database features.
Improve Data Warehouse Performance
Learn the benefits of using Oracle’s materialized views to improve the data warehouse performance. Instructors will give a high-level overview of how query rewrites can improve a query’s performance. Explore OLAP and Data Mining and identify some data warehouse implementations considerations.
Use Data Warehousing Tools
During this training, you'll briefly use some of the available data warehousing tools. These tools include Oracle Warehouse Builder, Analytic Workspace Manager and Oracle Application Express.
- Define the terminology and explain the basic concepts of data warehousing
- Describe methods and tools for extracting, transforming, and loading data
- Identify some of the tools for accessing and analyzing warehouse data
- Identify the technology and some of the tools from Oracle to implement a successful data warehouse
- Define the decision support purpose and end goal of a data warehouse
- Describe the benefits of partitioning, parallel operations, materialized views, and query rewrite in a data warehouse
- Explain the implementation and organizational issues surrounding a data warehouse project
- Use materialized views and query rewrite to improve the data warehouse performance
- Develop familiarity with some of the technologies required to implement a data warehouse
The Hyperion Planning 11.1.1/11.1.2 training course teaches how to design build and administer Oracle Hyperion Planning Applications.
You will learn to:
- Design a Planning application based on Business Requirements.
- Create and deploy planning applications.
- Manage metadata by adding and importing dimensions and members.
- Load data into Hyperion Planning and Essbase.
- Set up security for users and groups.
- Create and customize forms, task lists and menus.
- Work with Life Cycle Management.
- Build calculations and business rules from very basic do more complex allocations
- Design an set up the budget approval process.
- Manage the approval process.
Benefits to You
Oracle Hyperion Planning is the leading Enterprise Performance Management (EPM) solution by Oracle. Oracle Hyperion Planning is a centralized, Excel and Web-based planning, budgeting and forecasting solution supporting the financial and operational planning processes.
Oracle Hyperion Planning meets financial planning needs of all companies, big medium or small. It provides an intuitive model and the possibility of introducing changes to the budget process without impacts. A company may grow or change the way things are done, Hyperion Planning can adapt to new requirements.
This training course covers the Exam Topics of the
Oracle Hyperion Planning 11 Essentials 1Z0-533
- Design, Create and deploy Planning applications
- Manage metadata and data
- Set up security for users and groups
- Create and customize forms, task lists and menus
- Work with Life Cycle Management.
- Set up and test business rules
- Set up and manage the approval process
- Describe Financial Reporting, Workforce Planning, Capital Expense Planning.