Oracle Analytics and Data warehousing

The Oracle Analytics and Data Warehousing course provides step-by-step instructions on how to perform a variety of introductory right through to advanced business analytics, data analysis, visualisation and data warehouse development tasks for activities based on real-life work scenarios.

On successful Completion of this course you will be able 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 analysing 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
• Understand the Oracle Business and Analytics Technology Stack
• Understand the Oracle Analytics Reference Architecture
• Build queries in Oracle BI Answers
• Customize the Oracle BI user interface
• Create and modify Oracle BI Interactive Dashboards
• Work with views to display request information
• Create and modify Interactive Dashboards
• Create guided navigation links within Interactive Dashboards
• Use Oracle BI Delivers to configure, schedule, and deliver personalized alerts
• Build Oracle BI Publisher reports based on Answers requests and BI metadata
• Understand and Manage Presentation Layer Security
• Understand Repositories and the Presentation Layer Meta Data
• Understand BI Publisher – BI Presentation Services Integration
• Employ recommended design principles and best practices