• Oracle Analytics and Data warehousing

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
Course Requirements
Prerequisites Some knowledge of SQL, Statistics and relational database systems
Target Audience
Audience End Users Business Analysts Developer Functional Implementer Business Intelligence Developer

Write a review

Please login or register to review

Oracle Analytics and Data warehousing

  • Brand: Weblearning Publishing
  • Product Code: Oracle Analytics and Data warehousing
  • Reward Points: 100
  • Availability: In Stock
  • £89.99
  • £72.99

  • Price in reward points: 1200

Available Options


Related Products

Oracle Database SQL Workshop

Oracle Database SQL Workshop

Oracle Database SQL Workshop  This course is a combination of Oracle Database: SQL Workshop ..

£72.99 £89.99

Oracle Database Design and Programming with SQL CBT

Oracle Database Design and Programming with SQL CBT

Oracle Database Design and Programming with SQL This covers the Data Modelling and Database Devel..

£59.99 £79.99

Oracle Database Design and Programming with SQL eLearning

Oracle Database Design and Programming with SQL eLearning

Oracle Database Design and Programming with SQL This covers the Data Modelling and Database Devel..

£59.99 £79.99

Oracle Database Design and Programming with SQL Training Guide

Oracle Database Design and Programming with SQL Training Guide

Oracle Database Design and Programming with SQL This covers the Data Modelling and Database Devel..

£23.99 £29.99

Oracle Database 12c Performance Management and Tuning

Oracle Database 12c Performance Management and Tuning

Oracle Database 12c Performance Management and Tuning The Oracle Database 19c: Performance Manage..

£79.99 £99.99

Oracle Database 12/19c Essentials Certified Implementation

Oracle Database 12/19c Essentials Certified Implementation

Oracle Database 12/19c Essentials Certified Implementation The Oracle Database 12/19c Essentials ..

£169.99 £329.99

SQL Server 2022 Database Administration Workshop

SQL Server 2022 Database Administration Workshop

SQL Server 2022 Database Administration Workshop This course is designed for beginners and interm..

£79.99 £99.99

SQL Server Database Modelling and Design

SQL Server Database Modelling and Design

SQL Server Database Modelling and Design The SQL Server Database Modelling and Relational Databas..

£64.99 £89.99

Database Administration Unlimited

Database Administration Unlimited

Database Administration Unlimited Cloud Learning SubscriptionThe Database Administration Unlimited C..

£320.00 £355.00

Oracle Database 23ai Data Warehousing Fundamentals

Oracle Database 23ai Data Warehousing Fundamentals

Oracle 23ai Data Warehousing Fundamentals This course introduces students to the Oracle Database ..

£110.99 £129.99

Oracle Database 23ai: SQL Workshop

Oracle Database 23ai: SQL Workshop

Oracle Database 23ai: SQL Workshop This course is designed for Developers and Database Administra..

£84.99 £99.99

Oracle Database 19c Data Warehousing Fundamentals CBT

Oracle Database 19c Data Warehousing Fundamentals CBT

Oracle Database 19c Data Warehousing Fundamentals This course introduces students to the Oracle D..

£79.99 £99.99

Oracle Database 19c Data Warehousing Fundamentals eLearning

Oracle Database 19c Data Warehousing Fundamentals eLearning

Oracle Database 19c Data Warehousing Fundamentals This course introduces students to the Oracle D..

£79.99 £99.99

Oracle Database Administration for Microsoft SQL Server DBAs

Oracle Database Administration for Microsoft SQL Server DBAs

Oracle Database Administration for Microsoft SQL Server DBAs The Oracle Database Administration f..

£91.99 £129.99

IBM DB2 Database Administration for SQL Server DBA's

IBM DB2 Database Administration for SQL Server DBA's

IBM DB2 Database Administration for SQL Server DBA's The IBM DB2 Administration for SQL Server&nb..

£89.99 £119.99

Microsoft SQL Server Database Administration for Oracle DBAs

Microsoft SQL Server Database Administration for Oracle DBAs

Microsoft SQL Server Database Administration for Oracle DBAs The Microsoft SQL Server Database Ad..

£84.99 £129.99

Fundamentals of the Java Programming Language, Java SE

Fundamentals of the Java Programming Language, Java SE

Fundamentals of the Java Programming Language, Java SE This course will assist in preparation for..

£59.99 £69.99

SQL Server Data Warehousing Fundamentals

SQL Server Data Warehousing Fundamentals

SQL Server Data Warehousing Fundamentals The Microsoft SQL Server Data Warehousing Fundamentals c..

£69.99 £89.99

SQL Server 2019 Database Administration Workshop

SQL Server 2019 Database Administration Workshop

SQL Server 2019 Database Administration Workshop This course is designed for beginners and interm..

£79.99 £99.99

Data Science Unlimited

Data Science Unlimited

Data Science Unlimited Cloud Learning SubscriptionThe Data Science Unlimited Cloud Learning Sub..

£310.00 £348.00

AI & Machine Learning Unlimited

AI & Machine Learning Unlimited

AI & Machine Learning Unlimited Cloud Learning SubscriptionThe Machine Learning Unlimited C..

£310.00 £348.00

Oracle Database 23ai: New Features for Developers

Oracle Database 23ai: New Features for Developers

Oracle Database 23ai: New Features for Developers This course focuses on the latest advancements ..

£124.00 £149.99

Tags: Database Management, Oracle Database, DB2, SQL, DBA, Analytics, Data Warehouse, BI