On successful Completion of the course you will get a sound understanding of:

• Define big data and the business drivers for advanced, big data analytics
• Describe why and how Data Science is different to traditional Business Intelligence
• Describe the roles and skills required in a big data analytics team
• Explain the phases and activities of the data analytics lifecycle and identify the main activities and deliverables
• Explore and make an initial analysis of the data, using R
• Select and execute appropriate advanced analytic methods for candidate selection, categorization, and predictive modeling
• Describe the challenges and tools for analyzing text and other unstructured data
• Describe the importance and benefits of advanced techniques such as in-database analytics and how extensions and other advanced functions add value

The Data Science and Big Data Analytics course educates students to a foundation level on big data and the state of the practice of analytics. The course provides an introduction to big data and a Data Analytics Lifecycle to address business challenges that leverage big data.

Product code: WLN-IDM-PBF<

On successful Completion of the course you will get a sound understanding of:

• Describe and Understand Data Science and Machine Learning
• Describe the main categories of machine learning techniques
• Describe and Understand the Data Science Process
• Identify the steps in the machine learning process
• Describe the CRISP-DM process
• Understand Open Source Data Science tools and Platforms
• Learn to Install and Configure KNIME Platform
• Prepare data for predictive modelling
• Learn how to model, transform and prepare data frames and visualize them
• Learn about table transformation (merging data, table information, transpose, group by, pivoting etc
)
• Learn about row operations (eg
filter)
• Learn about column operations (filtering, spiting, adding, date information, missing values, adding binners, change data types, do basic math operations etc
)
• Visualize and explore data (column chart, line plot, pie chart, scatter plot, box plot)
• Create supervised and unsupervised machine learning models

This course is designed for anyone looking for a user-friendly, easily understandable tool for data analyses and machine learning tasks without necessarily having programming skills.

Product code: WLN-IDM-PBF<

On successful Completion of the course you will get a sound understanding of:

• Describe and Understand Data Science and Machine Learning
• Describe the main categories of machine learning techniques
• Describe and Understand the Data Science Process
• Identify the steps in the machine learning process
• Describe the CRISP-DM process
• Understand Open Source Data Science tools and Platforms including Spark, R and Python
• Understand Commercial Data Science tools including Microsoft Azure ML and Oracle Advanced Analytics
• Learn to Install and Configure KNIME Platform
• Learn to Configure KNIME Platform for R Development
• Prepare data for predictive modelling
• Visualize and explore data
• Create supervised and unsupervised machine learning models
• Integrate KNIME with R and Python
• Develop Data Science solutions using R on KNIME Platform

This course is designed to help you understand the core principles of data science, and to learn techniques and technologies that you can use to explore and visualize data.

Product code: WLN-IDM-PBF<

On successful Completion of the course you will get a sound understanding of:

• Explain what Predictive Analytics is
• Describe the main categories of machine learning Algorithms
• Identify the steps in the machine learning process
• Describe what CRISP-DM is
• Install KNIME Analytics Platform
• Work with the KNIME Workbench
• Describe Data Exploration and Preparation
• Describe classification and how classification can be supervised or unsupervised
• Explain and Discuss Evaluation of Machine Learning Models
• Explain Regression, Cluster Analysis, and Association Analysis
• Define what the regression task is
• Explain the difference between regression and classification
• Construct models that learn from data using widely available open source tools
• Analyze big data problems using scalable machine learning algorithms on KNIME Analytics Platform

This course provides an overview of Predictive Analytics techniques to explore, analyze, and leverage data. You will be introduced to tools and algorithms you can use to create machine learning models that learn from data, and to scale those models up to big data problems.

Product code: WLN-IDM-PBF<

On successful Completion of the course you will get a sound understanding of:

• Define big data and the business drivers for advanced, big data analytics
• Describe why and how Data Science is different to traditional Business Intelligence
• Describe the roles and skills required in a big data analytics team
• Explain the phases and activities of the data analytics lifecycle and identify the main activities and deliverables
• Explore and make an initial analysis of the data, using KNIME Analytics Platform
• Select and execute appropriate advanced analytic methods for candidate selection, categorization, and predictive modeling
• Describe the challenges and tools for analyzing text and other unstructured data
• Describe the importance and benefits of advanced techniques such as in-database analytics and how extensions and other advanced functions add value

This course focuses on the practice of data analytics, the role of the Data Scientist, the main phases of the Data Analytics Lifecycle, analyzing and exploring data with KNIME Analytics Platform, statistics for model building and evaluation, the theory and methods of advanced analytics and statistical modeling, the technology and tools that can be used for advanced analytics, operationalizing an analytics project, and data visualization techniques.

Product code: WLN-IDM-PBF<

On successful Completion of the course you will get a sound understanding of:

• Describe key concepts of data science and machine learning
• Understand Open Source Data Science tools and Platforms including KNIME, R and Python
• Understand Open Source Machine learning Tools and Platforms
• Understand Commercial Data Science tools and Platforms
• Understand Data Science and Machine Learning Frameworks
• Learn to Install and Configure R and Python
• Prepare data for predictive modelling
• Visualize and explore data
• Create supervised and unsupervised machine learning models
• Develop Data Science solutions using R on Azure ML Platform
• Develop Machine Learning solutions using Microsoft Azure Notebooks

This course introduces you to the most commonly used Machine Learning algorithms used in Data Science applications

Product code: WLN-IDM-PBF<

On successful Completion of the course you will get a sound understanding of:

• Learn to Plan and Scope your Data Wrangling and Projects
• Understand the Data Wrangling Development Lifecycle
• Describe Data Integration techniques such as ETL,ELT, EAI and EII
• Understand the differences between Data Integration and Data Wrangling
• Understand Open source data integration tools and platforms
• Understand commercial data integration tools such as Microsoft SSIS, Oracle Data Integrator and Informatica
• Retrieve data from example database and big data management systems
• Learn how to model, transform and prepare data frames and visualize them
• Learn about table transformation (merging data, table information, transpose, group by, pivoting etc
)
• Describe the connections between data management operations and the big data processing patterns
• Describe the patterns needed to utilize them in large-scale analytical applications
• Identify when a big data problem needs data integration

This course is designed for those who are just getting started on their data wrangler journey with KNIME Analytics Platform. It starts with a detailed introduction of KNIME Analytics Platform - from downloading it through to navigating the workbench.

Product code: WLN-IDM-PBF<

On successful Completion of the course you will get a sound understanding of:

• Explain what Predictive Analytics is
• Describe the main categories of machine learning Algorithms
• Identify the steps in the machine learning process
• Describe what CRISP-DM is
• Installing RapidMiner Studio
• Install RapidMiner Server Platform
• Work with the RapidMiner Studio Workbench
• Describe Data Exploration and Preparation
• Describe classification and how classification can be supervised or unsupervised
• Explain and Discuss Evaluation of Machine Learning Models
• Explain Regression, Cluster Analysis, and Association Analysis
• Define what the regression task is
• Explain the difference between regression and classification
• Construct models that learn from data using widely available open source tools
• Analyze big data problems using scalable machine learning algorithms on RapidMiner Analytics Platform

This course provides an overview of Predictive Analytics techniques to explore, analyze, and leverage data. You will be introduced to tools and algorithms you can use to create machine learning models that learn from data, and to scale those models up to big data problems.

Product code: WLN-IDM-PBF<

On successful Completion of the course you will get a sound understanding of:

• Understanding the Tableau Project Planning and Scoping Activities
• Capture Requirements for your Tableau Environment
• Understand the creation of Analytics Applications and Technical Design Specification documents
• Understand Foundational Elements of Data Visualization, and Apply Them Using Tableau
• Create Professional Dashboards and Master Tableau for Data Visualization and Analytics
• Build Professional Business Dashboards to Effectively Convey Patterns and Trends in Your Data
• Master Level of Detail (LOD) Expressions to Solve Complex Tasks in Data Visualization
• Master the Usage of Basic Calculations to Solve Common Tasks in Data Visualization
• Learn and Master Table Calculations to Apply Further Transformations to Your Visualization
• Navigate the Dashboard Workspace, and Customize Your Dashboards to Different Devices
• Master Tableau’s Mapping Functionality to Answer Spatial Questions
• Learn to Style and Format Maps with Mapbox, WMS, and Dual Axis capabilities
• Find, and Make of Use of Various Spatial Files in Tableau
• Master the Usage of Context Filters, Dimension Filters, Top N Filters, and Measure Filters
• Use Heat Maps to Find Hot Spots in Overlapping Data
• Add Interactivity to your Plots using Set actions and Parameter Control
• Learn about Different Join types to Combine your Data into a Single Rich Data Source
• Use Story Points to Tell Stories With Your Data
• Apply Pivots to your Data for Effective Data Processing
• Implement Unions to Combine Multiple Data Sources into One
• Learn About Theoretical Concepts Such as Data Types and Pre-attentive Processing

This course will teach you everything you need to know to create amazing data visualizations and dashboards with Tableau.

Product code: WLN-IDM-PBF<

On successful Completion of the course you will get a sound understanding of:

• Describe and Understand Data Science and Machine Learning
• Describe the main categories of machine learning techniques
• Describe and Understand the Data Science Process
• Identify the steps in the machine learning process
• Describe the CRISP-DM process
• Understand Open Source Data Science tools and Platforms including Spark, R and Python
• Understand Commercial Data Science tools including Microsoft Azure ML and Oracle Advanced Analytics
• Learn to Install and Configure RapidMiner Platform
• Perform all common data preparations
• Build strong analytical predictive models
• Evaluate model quality with respect to different performance criteria
• Deploy analytical predictive models

The Data Science and Machine Learning with RapidMiner course focuses on data science and machine learning with RapidMiner Studio. You will explore a simplified business use case and build a strong analytical model while becoming familiar with the graphical interface and the main product features functionality.

Product code: WLN-IDM-PBF<

On successful Completion of the course you will get a sound understanding of:

• Describe key concepts of Big Data
• Gain a high-level understanding of big data and Hadoop
• Understand Hadoop Components: MapReduce and HDFS
• Understand Hadoop Components: YARN and Apache Tez
• Understanding of big data infrastructure with its possibilities and limitations
• Connecting a desktop computer with a Hadoop cluster
• Exploration of large volumes of data
• Extracting and loading data
• Producing big data analyses with RapidMiner
• Knowledge of methods to efficiently process large volumes of data

After the course, participants will have an in-depth knowledge about the pros and cons of big data technologies and will know how large amounts of data can be processed using RapidMiner on Hadoop. In the course, the participants use their personal laptops, meaning they can take home the knowledge and example solutions from the course and use these as a basis for their own big data challenges.

Product code: WLN-IDM-PBF<

On successful Completion of the course you will get a sound understanding of:

• Describe and Understand Data Science and Machine Learning
• Describe the main categories of machine learning techniques
• Describe and Understand the Data Science Process
• Identify the steps in the machine learning process
• Describe the CRISP-DM process
• Understand Open Source Data Science tools and Platforms
• Learn to Install and Configure RapidMiner Platform
• Prepare data for predictive modelling
• Learn how to model, transform and prepare data frames and visualize them
• Learn about table transformation (merging data, table information, transpose, group by, pivoting etc
• )
• Learn about row operations (eg. filter)
• Learn about column operations (filtering, spiting, adding, date information, missing values, adding binners, change data types, do basic math operations etc.)
• Visualize and explore data (column chart, line plot, pie chart, scatter plot, box plot)
• Create supervised and unsupervised machine learning models

This course is designed for anyone looking for a user-friendly, easily understandable tool for data analyses and machine learning tasks without necessarily having programming skills.

Product code: WLN-IDM-PBF<

On successful Completion of the course you will get a sound understanding of:

• Describe Data Integration techniques such as ETL,ELT, EAI and EII
• Understand the differences between Data Integration and Data Wrangling
• Understand Open source data integration tools and platforms
• Understand commercial data integration tools such as Microsoft SSIS, Oracle Data Integrator and Informatica
• Retrieve data from example database and big data management systems
• Learn how to model, transform and prepare data frames and visualize them
• Learn about table transformation (merging data, table information, transpose, group by, pivoting etc
)
• Describe the connections between data management operations and the big data processing patterns
• Describe the patterns needed to utilize them in large-scale analytical applications
• Identify when a big data problem needs data integration

This course is designed for those who are just getting started on their data wrangler journey with RapidMiner. It starts with a detailed introduction of RapidMiner - from downloading it through to navigating the workbench.

Product code: WLN-IDM-PBF<

On successful Completion of the course you will get a sound understanding of:

• Define big data and the business drivers for advanced, big data analytics
• Describe why and how Data Science is different to traditional Business Intelligence
• Describe the roles and skills required in a big data analytics team
• Explain the phases and activities of the data analytics lifecycle and identify the main activities and deliverables
• Explore and make an initial analysis of the data, using RapidMiner
• Select and execute appropriate advanced analytic methods for candidate selection, categorization, and predictive modeling
• Describe the challenges and tools for analyzing text and other unstructured data
• Describe the importance and benefits of advanced techniques such as in-database analytics and how extensions and other advanced functions add value

This course focuses on the practice of data analytics, the role of the Data Scientist, the main phases of the Data Analytics Lifecycle, analyzing and exploring data with RapidMiner, statistics for model building and evaluation, the theory and methods of advanced analytics and statistical modeling, the technology and tools that can be used for advanced analytics, operationalizing an analytics project, and data visualization techniques.

Product code: WLN-IDM-PBF<

On successful Completion of the course you will get a sound understanding of:

• Explain what Predictive Analytics is
• Describe the main categories of machine learning Algorithms
• Identify the steps in the machine learning process
• Describe what CRISP-DM is
• Install RapidMiner
• Work with the RapidMiner Workbench
• Describe Data Exploration and Preparation
• Describe classification and how classification can be supervised or unsupervised
• Explain and Discuss Evaluation of Machine Learning Models
• Explain Regression, Cluster Analysis, and Association Analysis
• Define what the regression task is
• Explain the difference between regression and classification
• Construct models that learn from data using widely available open source tools
• Analyze big data problems using scalable machine learning algorithms on RapidMiner

This course provides an overview of Predictive Analytics techniques to explore, analyze, and leverage data. You will be introduced to tools and algorithms you can use to create machine learning models that learn from data, and to scale those models up to big data problems.

Product code: WLN-IDM-PBF<

On successful Completion of the course you will get a sound understanding of:

• Learn to create interactive reporting
• Create basic and advanced analyses and dashboards
• Build analyses and use views and graphs in analyses
• Explore data using Visual Analyzer
• Learn to create actionable intelligence and fixed-format published reporting
• Learn data exploration and visualisation techniques
• Learn to create self-service reporting
• Learn how to create augmented Analytics with machine learning

The Data Analysis and Visualization with Oracle Analytics Server course provides step-by-step instructions on how to create analyses, dashboards and perform a variety of Data Analysis and Visualization tasks using the Oracle Analytics Server platform.

Product code: WLN-IDM-PBF<

On successful Completion of the course you will get a sound understanding of:

• Understanding the OAC and OAS Project Planning and Scoping Activities
• Capture Requirements for your Analytics Environment
• Understand the creation of Analytics Application and Technical Design Specification documents
• Understand Oracle Analytics Cloud (OAC) and (OAS) Architectures
• Understand the Oracle Analytics Reference Architecture
• Understand the data and repository layer
• Create and publish data models using Data Modeler
• Explore data using Visual Analyzer
• Build analyses and use views and graphs in analyses
• Administer objects in the catalog
• Troubleshoot issues with data loading, data modeling, analyses and dashboards
• Understanding the OAS Developer Client Tool
• Understanding Analytics Desktop Tool

The Oracle Analytics Server (On premise version of Analytics cloud - OAC) Bootcamp course covers everything you need to know in order to manage your Oracle Analytics Server (On premise version of Analytics cloud) and BI platform. It assumes no prior knowledge up-front.

Product code: WLN-IDM-PBF<

On successful Completion of the course you will get a sound understanding of:

• Understanding the OAC and OAS Project Planning and Scoping Activities
• Capture Requirements for your Analytics Environment
• Understand the creation of Analytics Application and Technical Design Specification documents
• Upload data from external sources
• Explore data through data wrangling and visualizations
• Load data using Data Loader and SQL Developer
• Create and publish data models using Data Modeler
• Explore data using Visual Analyzer
• Build analyses and use views and graphs in analyses
• Administer objects in the catalog
• Troubleshoot issues with data loading, data modeling, analyses and dashboards
• Configure Oracle Analytics Server on Mobile
• Understanding the OAS Developer Client Tool
• Understanding Analytics Desktop Tool

The Business Intelligence on Oracle Analytics Server 5.5 course provides step-by-step instructions for creating analyses and dashboards using Oracle Analytics Server Platform. You’ll learn how to load data, model data, build and modify analyses and dashboards, while configuring Oracle Analytics Server on mobile.

Product code: WLN-IDM-PBF<

On successful Completion of the course you will get a sound understanding of:

• Describe the key features of Oracle Machine Learning
• Create Projects and workspaces, and manage users in Oracle Machine Learning
• Crete and run Oracle Machine Learning Notebooks
• Develop SQL Scripts that can be used in Notebooks
• Create Notebooks for data analysis and Data Visualization
• Collaborate and share Notebooks with other Oracle Machine Learning users
• Schedule Jobs to run Notebooks
• Use Analytics Cloud to create data visualizations
• Extract data for analytics from Autonomous Data Warehouse and Autonomous Transaction Processing Cloud service instances
• Use Machine Learning feature in Oracle Analytics Cloud

This is a great starting point for Data Scientists, Developers, Architects, Business Analysts and anyone who wants to know how Oracle Machine Learning and Oracle Autonomous Cloud Platform can add value and transform their business.

Product code: WLN-IDM-PBF<

On successful Completion of the course you will get a sound understanding of:

• Understand the features and Benefits of Oracle Analytics Cloud
• Learn to upload data from external sources
• Learn to blend and manage data
• Explore data on mobile devices
• Learn to manage users and roles
• Learn to troubleshoot issues in projects

In this Enhanced Visual Analysis with Data Visualization course, you will learn to use Data Visualization to easily create visualizations and explore your data through intuitive drag and drop gestures. Learn to quickly upload data from a variety of sources, like spreadsheets, CSV files, Fusion Applications, and database, to your system and model it in a few easy steps. You will learn to use the Oracle Analytics Cloud Home page to perform analyses and dashboards tasks.

Product code: WLN-IDM-PBF<

On successful Completion of the course you will get a sound understanding of:

• Create and Configure the Oracle Analytics Server
• Configure the Prerequisites for Provisioning the OAS
• Understand Data Models and its components
• reate the Data Model in OAS
• Learn to use data modeler
• Learn to create source views
• Learn to create a Time Dimension
• Learn to define Hierarchies and Levels to Drill and Aggregate
• Learn to secure your data model

In this Data Modelling for BI Administrators course you will learn how to use Data Modeler to create data models from various source types, such as star and snowflakes.A data model is a design that presents business data for analysis in a manner that reflects the structure of the business. Data models enable analysts to structure queries in the same intuitive fashion as they ask business questions.

Product code: WLN-IDM-PBF<

On successful Completion of the course you will get a sound understanding of:

• Create Reports
• Administration tasks
• Create reports from different data sources
• Create and Modify Data Models
• Create RTF Templates by Using Template Builder
• Create Layouts by Using the Layout Editor
• Schedule Reports
• Perform Translations

This Oracle Analytics Server: BI Publisher Reporting course will help you build a foundation of understanding how to best leverage BI Publisher in Oracle Analytics Cloud. You'll learn how to create layouts for reports, build data models, work with template builder, schedule reports, perform translations as well as perform some common administration tasks.

Product code: WLN-IDM-PBF<

On successful Completion of the course you will get a sound understanding of:

• Define big data and the business drivers for advanced big data analytics
• Describe why and how Data Science is different to traditional Business Intelligence
• Describe the roles and skills required in a big data analytics team
• Explain the phases and activities of the data analytics lifecycle
• Describe what CRISP-DM is and identify the main activities and deliverables
• Describe and Understand Oracle Advanced Analytics Tools
• Describe the Oracle Data Miner Workflow GUI; a SQL Developer extension
• Explore and make an initial analysis of the data, using R
• Understand R Technologies in Oracle
• Describe Oracle R Enterprise Server
• Describe and Understand Data Science Algorithms supported by Oracle
• Select and execute appropriate advanced analytic methods for candidate selection, categorization, and predictive modeling
• Describe the challenges and tools for analyzing text and other unstructured data
• Describe the importance and benefits of advanced techniques such as in-database analytics and how extensions and other advanced functions add value
• Describe the SQL and R Support in Oracle Advanced Analytics
• Describe the In-Database Processing with Oracle Advanced Analytics
• Describe the Oracle R Enterprise—Integrating Open Source R with the Oracle Database
• Describe the Hadoop, Oracle Big Data Appliance and Big Data SQL

The Big Data Analytics with Oracle Advanced Analytics course educates students to a foundation level on big data and the state of the practice of analytics. The course provides an introduction to big data and a Data Analytics Lifecycle to address business challenges that leverage big data.

Product code: WLN-IDM-PBF<

On successful Completion of the course you will get a sound understanding of:

• Describe Oracle Advanced Analytics (OAA) Option
• Describe the main categories of machine learning techniques
• Describe and Understand the AI and Machine Learning Process
• Identify the steps in the machine learning process
• Describe what CRISP-DM is
• Install Oracle R Enterprise
• Start up R load ORE, and connect to Oracle Database
• Apply R Language Basics
• Use the ORE Transparency Layer
• Use ORE for embedded R execution
• Use ORE predictive analytics packages
• Interact directly with Oracle Database objects using ROracle

The Oracle R Enterprise Essentials course will teach you how to leverage the Oracle Database as a high performance computing platform from the powerful R statistical programming language and environment. Overcome the memory limitations of the open source client R engine. Prepare data, perform statistical analysis, and build predictive models on Big Data data sets that are generally impossible with open source R. Generate graphics and invoke R scripts from SQL for integration with the Oracle stack.

Product code: WLN-IDM-PBF<

On successful Completion of the course you will get a sound understanding of:

• Explain basic Machine Learning concepts and describe the benefits of predictive analysis
• Understand primary Machine Learning tasks, and describe the key steps of a Machine Learning process
• Use the Oracle Data Miner to build,evaluate, and apply multiple Machine Learning models
• Use Oracle Machine Learning's predictions and insights to address many kinds of business problems, including: Predict individual behavior, Predict values, Find co-occurring events
• Learn how to deploy Machine Learning results for real-time access by end-users

In this course, students review the basic concepts of Machine Learning and learn how leverage the predictive analytical power of the Oracle Database Machine Learning option by using Oracle Data Miner 19c. The Oracle Data Miner GUI is an extension to Oracle SQL Developer 18.0 that enables data analysts to work directly with data inside the database.

Product code: WLN-IDM-PBF<

On successful Completion of the course you will get a sound understanding of:

• Understand Predictive Analytics and Data Mining Concepts
• Explain data mining concepts and describe the benefits of predictive analysis
• Understand the Oracle Advanced Analytics (OAA) Option
• Understand Oracle R Enterprise (ORE)
• Understand Predictive Analytics and Machine Learning and their role within Information Warehouse Architecture
• Understand primary data mining tasks
• Describe the key steps of a Machine Learning process
• Deploy various Predictive Analytics Methods and Techniques
• Explore Predictive Analytics Case studies
• Use the Oracle Data Miner to build, evaluate, apply, and deploy multiple data mining models
• Use Oracle Data Mining's predictions and insights to address various kinds of business problems

The Predictive Analytics using Oracle Advanced Analytics course provides hands-on step-by-step instructions on how to apply a variety of Predictive Analytics and mining techniques using Oracle 12c and 18c.

Product code: WLN-IDM-PBF<

On successful Completion of the course you will get a sound understanding of:

• Describe key concepts of data science and machine learning
• Understand Open Source Data Science tools and Platforms including Spark, R and Python
• Understand Open Source Machine learning Tools and Platforms
• Understand Commercial Data Science tools including Oracle SQL Developer and Microsoft Azure ML Studio
• Learn to Install and Configure R and Python
• Prepare data for predictive modelling
• Visualize and explore data
• Create supervised and unsupervised machine learning models
• Develop Data Science solutions using Oracle R (ORE) and Machine Learning Platform
• Develop Machine Learning solutions using Jupyter Notebooks
• Develop Data Science solutions using Oracle Data Miner

The Predictive Analytics using Oracle Machine Learning course provides step-by-step instructions on how to use a combination of data science and Machine Learning techniques to address your business challenges. You will perform basic to advanced Data Science and Machine Learning tasks using open source tools and Oracle SQL Developer for activities based on real-life work scenarios.

Product code: WLN-IDM-PBF<

On successful Completion of the course you will get a sound understanding of:

• Understand Predictive Analytics and Machine Learning Concepts
• Explain data mining concepts and describe the benefits of predictive analysis
• Understand the Oracle Advanced Analytics (OAA) Option
• Understand Oracle Machine Learning for R (OML4R)
• Start up R, load OML4R, and connect to Oracle Database
• Apply R Language Basics
• Use the OML4R Transparency Layer
• Use OML4R for embedded R execution
• Use OML4R predictive analytics packages
• Interact directly with Oracle Database objects using ROracle
• Create Projects and Workspaces in Oracle Machine Learning
• Create and Running Notebooks in Oracle Machine Learning
• Collaborate in Oracle Machine Learning
• Creating a SQL Script in Oracle Machine Learning
• Running SQL Statements in Oracle Machine Learning

The Predictive Analytics with Oracle Machine Learning for R (OML4R) course will teach you how to leverage the Oracle Database as a high performance computing platform from the powerful R statistical programming language and environment. Overcome the memory limitations of the open source client R engine. Prepare data, perform statistical analysis, and build predictive models on Big Data data sets that are generally impossible with open source R. Generate graphics and invoke R scripts from SQL for integration with the Oracle stack.

Product code: WLN-IDM-PBF<

On successful Completion of the course you will get a sound understanding of:

• Understand Predictive Analytics and Machine Learning Concepts
• Explain data mining concepts and describe the benefits of predictive analysis
• Understand the Oracle Advanced Analytics (OAA) Option
• Understand Oracle R Enterprise (ORE)
• Understand Oracle Machine Learning for R (OML4R)
• Understand Predictive Analytics and R and their role within Information Warehouse Architecture
• Understand primary data mining and Machine Learning tasks
• Describe the key steps of a data mining and Machine Learning process
• Understand primary data mining tasks, and describe the key steps of a data mining process
• Use the Oracle Data Miner to build, evaluate, apply, and deploy multiple data mining models
• Deploy various Predictive Analytics Methods and Techniques
• Explore Predictive Analytics Case studies
• Use the Oracle R Enterprise to build, evaluate, apply, and deploy predictive analytics models
• Use Oracle R Enterprise's predictions and insights to address various kinds of business problems

This Oracle Database 19c: Advanced Analytics Fundamentals course will teach you how to leverage the Oracle Database Advanced Analytics option as a high performance computing platform for Predictive Analytics and Data Science projects.

Product code: WLN-IDM-PBF<

On successful Completion of the course you will get a sound understanding of:

• Use SQL with aggregation operators, SQL for Analysis and Reporting functions
• Group and aggregate data using the ROLLUP and CUBE operators
• Analyze and report data using Ranking, LAG/LEAD, and FIRST/LAST functions
• Analyze and report data using the PIVOT and UNPIVOT clauses
• Use the MODEL clause to create a multidimensional array from query results
• Use Analytic SQL to aggregation, Analyze and Reporting, and Model Data
• Interpret the concept of a hierarchical query, create a tree-structured report
• Format hierarchical data, and exclude branches from the tree structure
• Use regular expressions to search for, match, and replace strings
• Perform pattern matching using the MATCH_RECOGNIZE clause

This Oracle Database 19c: Analytic SQL for Data Warehousing training teaches you how to interpret the concept of a hierarchical query, create a tree-structured report, format hierarchical data and exclude branches from the tree structure.

Product code: WLN-IDM-PBF<

On successful Completion of the course you will get a sound understanding of:

• Use SQL with aggregation operators, SQL for Analysis and Reporting functions
• Group and aggregate data using the ROLLUP and CUBE operators
• Analyze and report data using Ranking, LAG/LEAD, and FIRST/LAST functions
• Analyze and report data using the PIVOT and UNPIVOT clauses
• Use the MODEL clause to create a multidimensional array from query results
• Use Analytic SQL to aggregation, Analyze and Reporting, and Model Data
• Interpret the concept of a hierarchical query, create a tree-structured report
• Format hierarchical data, and exclude branches from the tree structure
• Use regular expressions to search for, match, and replace strings
• Perform pattern matching using the MATCH_RECOGNIZE clause

This Oracle Database 19c: Analytic SQL for Data Warehousing training teaches you how to interpret the concept of a hierarchical query, create a tree-structured report, format hierarchical data and exclude branches from the tree structure.

Product code: WLN-IDM-PBF<

On successful Completion of the course you will get a sound understanding of:

• Review and describe the characteristics of a data warehouse
• Describe all of the components of an enterprise architecture
• Examine different data warehouse architectures
• List various types of data that may be considered for the warehouse
• Identify the requirements of a decision support query environment
• Outline the steps to building a data warehouse
• Describe how to determine the first increment according to the value proposition and return on investment
• Know the different modeling techniques, specifically entity relationship modeling
• Identify the modeling conventions and terminology used, specifically in the Oracle environment
• Define metadata and describe why it is important to the warehouse and users
• Identify types of metadata for every aspect of warehouse operation, management, and access
• Identify the organizational and technical uses of metadata
• Evaluate sources for metadata currently in your enterprise
• Conduct gap analysis and appreciate where this occurs in the Data Warehouse Method

In this course Students are introduced to the data warehouse environment in the context of the enterprise architecture. Students learn to identify each component of the architecture and its role in the overall system. Students learn how specific business needs can influence the data warehouse design, and also learn how to translate business issues into subject areas.

Product code: WLN-IDM-PBF<

On successful Completion of the Oracle Business Intelligence 11g Foundation Suite Essentials Self-Study eLearning course you will be able to:

• Understand Oracle BI Suite Enterprise Edition Plus
• Understand Hyperion Performance Management Architecture
• Understand and Explore OBI Administration Tools
• Build queries in Oracle BI Answers
• Create and modify Oracle BI Interactive Dashboards
• Understand Strategy and Scorecard Management Concepts
• Create KPI and KPI Watch lists
• Build Oracle BI Publisher reports
• Use EPM Workspace
• Understand Hyperion Essbase
• Understand and use SmartView
• Understand Essbase Integration with Oracle BIEE

Certification: This course will assist in preparation for the Oracle BI Certified Implementation Specialist 1Z0-591 Certification exam..

Product code: WLN-OBIEE-FDN

On successful Completion of the Oracle Business Intelligence 11g: Analyses and Dashboards course you will be able to:

• Build queries in Oracle BI Analyses
• Customize the Oracle BI user interface
• Create and modify Oracle BI Interactive Dashboards
• Create and work with KPIs
• Use Oracle BI Content in your Microsoft Office documents
• Use Oracle BI Delivers to configure, schedule, and deliver personalized alerts
• Create and modify Business Intelligence Analysis using Oracle Business Intelligence Analyses
• Work with views to display request information
• Create and modify Interactive Dashboards
• Create guided navigation links within Interactive Dashboards
• Use Oracle Business Intelligence Delivers to configure, schedule, and deliver personalized alerts
• Work with Oracle BI Presentation Services content in Microsoft Office applications
• Build Oracle BI Publisher reports based on Analyses Analysis and BI metadata subject areas
• Integrate Oracle BI Publisher reports in Interactive Dashboards
• Employ recommended design principles and best practices

Certification: This course will assist in preparation for the Oracle BI Certified Implementation Specialist 1Z0-591 Certification exam.

Product code: WLN-OBIEE-FDN

On successful Completion of the Oracle Business Intelligence 11g Administration Self-Study eLearning course you will be able to:

• Use Fusion Middleware Control to diagnose and resolve issues in Oracle BI
• Set up, configure, and manage Oracle BI security
• Set up a clustered environment to deploy Oracle BI for high availability
• Use Oracle BI system administration tools to monitor, manage, and configure Oracle BI system components
• Use vertical and horizontal scaling to manage the capacity of an Oracle BI deployment
• Use Fusion Middleware Control to diagnose and resolve issues in Oracle BI
• Use Oracle BI system administration tools to monitor, manage, and configure Oracle BI system components
• Manage performance tuning and query caching to improve Oracle BI query performance

Certification: This course will assist in preparation for the Oracle BI Certified Implementation Specialist 1Z0-591 Certification exam.

Product code: WLN-OBIEE-ADM

On successful Completion of the Oracle Business Intelligence & BI Publisher BootCamp course you will be able to:

• Create and modify Business Intelligence analysis using Oracle Business Intelligence Analyses
• Combine analysis criteria using set operations and execute direct database requests
• Work with views to display analysis information
• Create and modify Interactive Dashboards
• Create guided navigation links within Interactive Dashboards
• Use Oracle Business Intelligence Delivers to configure, schedule, and deliver personalized alerts
• Work with Oracle BI Presentation Services content in Microsoft Office applications
• Describe BI Publisher Technology and Architecture
• Create and Modify Data Models
• Create Layouts by Using the Layout Editor
• Create RTF Templates by Using Template Builder
• Define parameters and LOVs for a data model
• Create BI Publisher reports based on data models
• Create report layouts by using the Layout Editor (online)
• Analyze data by using the Excel Analyzer
• Create Reports Integrated With Oracle BIEE
• Administer BI Publisher Server
• Build Oracle BI Publisher reports based on Answers requests and BI metadata subject

Certification: This course will assist in preparation for the Oracle BI Certified Implementation Specialist 1Z0-591 Certification exam.

Product code: WLN-OBIEE-FDN

On successful Completion of the Oracle Business Intelligence & BI Publisher course you will be able to:

• Understand Oracle BI Foundation Suite
• Understand Enterprise Reporting Architectures
• Understand Reports Development Lifecycle
• Describe BI Publisher Technology and Architecture
• Configuring the Data Sources
• Create and Modify Data Models
• Create Layouts by Using the Layout Editor
• Create RTF Templates by Using Template Builder
• Define parameters and LOVs for a data model
• Create BI Publisher reports based on data models
• Create report layouts by using the Layout Editor (online)
• Analyze data by using the Excel Analyzer
• Create Reports Integrated With Oracle BIEE
• Administer BI Publisher Server

Certification: This course will assist in preparation for the Oracle BI Certified Implementation Specialist 1Z0-591 Certification exam.

Product code: WLN-OBIEE-FDN

On successful Completion of the Oracle BI 11g: Scorecarding and Strategy Management course you will be able to:

• Create a Strategy map within Scorecard
• Create a Strategy tree within Scorecard
• Create a Cause & Effect map within Scorecard
• Create Mission and Vision statements within Scorecard
• Create KPIs
• Create Agents
• Create a stand-alone KPI watchlist
• Create Scorecards and associated objects
• Add Scorecards to a Dashboard
• Create a KPI and KPI watchlist within Scorecard
• Create Objectives within Scorecard
• Create Initiatives within Scorecard
• Create a Perspective within Scorecard
• Create comments for collaboration within Scorecard

Certification: This course will assist in preparation for the Oracle Business Intelligence Implementation Specialist - 1Z0-591 Certification exam.

Product code: WLN-OBI-SSC

On successful Completion of the Hyperion EPM Financial Management 11.1.x Interactive Users Self-Study eLearning course, you should be able to:

• Understand Business Intelligence and OLAP Concepts
• Understand Hyperion FM and Essbase Concepts
• Understand the Analysis, Design of Hyperion FM Applications
• Analyze and enter data in Smart View
• Create reports in Financial Reporting
• Navigate Financial Management
• Translate data
• Enter and calculate data
• Create journal entries
• Enter intercompany data
• Consolidate data

Certification: This course will assist in preparation for the Oracle Hyperion FM Certfied Implementation Specialist - 1Z0-532 Certification exam..

Product code: WLN-HFM-IU

On successful Completion of the Hyperion Planning 11.1.2 Certified Implementation Specialist course you will be able to:

• Create Planning applications
• Navigate Workspace in Planning
• Create data forms and folders
• Customize data forms
• Enter data in Planning
• Enter data in Smart View
• Create business rules
• Manage business rules
• Add variables and formulas to business rules
• Manage the approval process
• Create task lists
• Identify the Planning installation requirements
• Describe the architecture of WebLogic Server
• Understand WebLogic Server domains, servers and machines
• Install and configure WebLogic Server
• Install and configure Foundation Services and Essbase
• Design and manage Essbase security
• Install and configure Planning
• Verify the Planning installation
• Perform backup, recovery, application migration, and task automation

Certification: This course will assist in preparation for the Oracle Hyperion Planning 11 Specialist - 1Z0-533 Certification exam.

Product code: WLN-HFM-IS

On successful Completion of the Hyperion FM 11.1.2 Certified Implementation Specialist course you will be able to:

• Use EPM Workspace
• Manage Financial Management Applications
• Create Classic Planning Applications
• Create applications and setting up profiles
• Load data to HFM and the various alternatives available for developers
• Work with formulas, add charts, deploy reports with books and batches
• Build reports using the Smart View client
• Address management issues such as security, backing up Reports
• Understand Performance Management Architecture and Infrastructure
• Install and Configure Hyperion EPM Financial Management System 11.1.2
• Install and Configure Hyperion Financial Management 11.1.2 Server and Clients
• Understand EPM Foundation Modules including Essbase
• Understand EPM System Applications
• Understand EPM Architect Modules
• Understand EPM System Integration with Oracle BIEE
• Understand and use Shared Services
• User Management, including: User provisioning, External authentication definition
• Understand Lifecycle Management and for Migrations

Certification: This course will assist in preparation for the Hyperion Financial Management 11.1.2: Implementation Specialist - 1Z0-532 Certification exam.

Product code: WLN-HFM-IS

On successful Completion of the Hyperion FM 11.1.2: Create & Manage Applications course you will be able to:

• Navigate Workspace
• Navigate Financial Management
• Import and export data and metadata
• Create and deploy an application
• Enter data in data forms and data grids
• Enter data in data grids
• Enter data in data forms 
• Adjust data with journals 
• Process and report on journals 
• Eliminate intercompany balances 
• Manage intercompany transactions 
• Run consolidations 
• Manage the review cycle through Process Management
• Synchronize data 
• Automate Tasks 
• Analyze data with Smart View 
• Enter data by using data forms in Smart View
• Analyze data with Smart View functions

Certification: This course will assist in preparation for the Hyperion Financial Management 11.1.2: Implementation Specialist - 1Z0-532 Certification exam.

Product code: WLN-HFM-IS

On successful Completion of the Hyperion Planning & Essbase 11.1.2: Fundamentals course you will be able to:

• Configure Hyperion EPM Planning and Essbase System 11.1.2
• Understand EPM Foundation Modules including Essbase
• Understand EPM System Web Components
• Understand EPM System Applications
• Understand EPM Architect Modules
• Understand Oracle BI Enterprise Edition Products and Architecture
• Understand the Plus Components of OBIEE
• Understand and use Shared Services
• User Management, including: User provisioning, External authentication definition
• Understand Lifecycle Management and for Migrations
• Understand the Deployment Architecture for EPM 11.1.x Applications
• Use EPM Workspace including building Portal Pages
• Manage and use Planning Applications
• Develop Essbase OLAP Applications
• Develop Essbase OLAP ASO and BSO Cubes

Certification: This course will assist in preparation for the Oracle Hyperion Planning 11 Specialist - 1Z0-533 Certification exam.

Product code: WLN-HPNESS-CBT

On successful Completion of the Hyperion Planning 11.1.2 Create and Manage Applications eLearning course you will be able to:

• Create Planning applications
• Navigate Workspace in Planning
• Create data forms and folders
• Customize data forms
• Enter data in Planning
• Enter data in Smart View
• Create business rules
• Manage business rules
• Add variables and formulas to business rules
• Manage the approval process
• Create task lists

Certification: This course will assist in preparation for the Oracle Hyperion Planning 11 Specialist - 1Z0-533 Certification exam.

Product code: WLN-HPLN-CM

On successful Completion of the SAP BusinessObjects XI WebIntelligence: Data Analysis & Visualisation course you will be able to:

• BusinessObjects Enterprise XI Architecture
• BusinessObjects Enterprise XI 4.x Architecture
• SAP BusinessObjects XI 4.1 Client Tools
• The Query and Analysis Continuum
• Business Intelligence and OLAP Concepts
• Business Objects and Data Warehouse Concepts
• Enterprise Reporting Architectures
• Introduction to Business Intelligence Platforms
• Understand the Report Development Process
• Create Web Intelligence Reports
• Analyse Data in Drill Mode
• Work with InfoView and BI Launchpad
• Analyzing Data using Web Intelligence
• Share Web Intelligence Documents
• Schedule Web Intelligence documents
• Work with SAP Web Intelligence 4.x BI Launchpad
• Work with SAP Web Intelligence 4.x Queries Using Bex
• Work with SAP Web Intelligence 4.x Queries Using Analysis View

Certification: This course will assist in preparation for the SAP BusinessObjects XI WebIntelligence Certification exams.

Product code: WLN-OBIEE-FDN

On successful Completion of the SAP BusinessObjects XI:Data Analysis & Reporting course you will be able to:

• BusinessObjects Enterprise XI Architecture
• BusinessObjects Enterprise XI 4.x Architecture
• SAP BusinessObjects XI 4.1 Client Tools
• The Query and Analysis Continuum
• Business Intelligence and OLAP Concepts
• Business Objects and Data Warehouse Concepts
• Enterprise Reporting Architectures
• Introduction to Business Intelligence Platforms
• Understand the Report Development Process
• Create Web Intelligence Reports
• Analyse Data in Drill Mode
• Work with InfoView and BI Launchpad
• Analyzing Data using Web Intelligence
• Share Web Intelligence Documents
• Schedule Web Intelligence documents
• Creating Desktop Intelligence Documents
• Synchronizing Data from Multiple Data Providers
• Format Desktop Intelligence Documents
• Create Variables and Alerters
• Schedule Desktop Intelligence Documents
• Create Variables and Alerters
• Work with SAP Web Intelligence 4.x BI Launchpad
• Work with SAP Web Intelligence 4.x Queries Using Bex
• Work with SAP Web Intelligence 4.x Queries Using Analysis View

Certification: This course will assist in preparation for the SAP BusinessObjects XI Certification exams.

Product code: WLN-BOBJ-DAR

On successful Completion of the Business Intelligence and Analytics – Ad-Hoc Data Analysis, Visualisation and Reporting Boot Camp course you will be able to:

• Understanding Enterprise Reporting Architectures
• Understand Business Intelligence, Analytics and OLAP Concepts
• Understanding Reporting and Data Warehousing Concepts
• Understanding the Report Development Process
• Understand Cognos, SAP BusinessObjects XI and Oracle BIEE BI Architectures
• Explore different Cognos Query Studio report types (list, crosstab, chart)
• Create Ad-Hoc Reports in Cognos Query Studio
• Create and Format reports and other formatting options
• Focus Query Studio reports by filtering data and using prompts
• Understand Oracle BIEE Answers and Dashboards Ad-Hoc Reporting
• Create Ad-Hoc Reports in Oracle BIEE Answers and Dashboards
• Build queries in Oracle BI Answers
• Customize the Oracle BI user interface
• Create and modify Oracle BI Interactive Dashboards
• Use Oracle BI Content in your Microsoft Office documents
• Use Oracle BI Delivers to configure, schedule, and deliver personalized alerts
• Create and modify Business Intelligence requests using Oracle BI Answers
• Work with views to display request information
• Create and modify Interactive Dashboards
• Understand the BusinessObjects XI Infoview Portal Interface
• Understand Web Intelligence Reporting
• Create Ad-Hoc Reports in Web Intelligence
• Enhance Reports in Web Intelligence
• Customise Reports in Web Intelligence

Certification: This course will assist in preparation for the Microsoft Business Intelligence Certification exams.

Product code: WLN-BUNDLE-BIDW

On successful Completion of the Business Analytics and OLAP: Modelling and Design Boot Camp course you will be able to:

• Understand Enterprise BI & Analytics Concepts
• Understand OLAP Concepts
• Understand Oracle BIEE, Cognos and BusinessObjects XI Concepts
• Understand Enterprise BI & Analytics Deployment Method Framework and Cycles
• Understand Planning your Enterprise BI & Analytics Project
• Understand Requirements Analysis
• Create and modify Business Intelligence Semantic Layer Models using Oracle BIEE
• Create and modify Business Intelligence Semantic Layer Models using Business Objects XI Designer
• Create and Modify Multi-Dimensional OLAP Models using Cognos Powerplay
• Employ recommended design principles and best practices

Certification: This course will assist in preparation for the Microsoft Business Intelligence Certification exams.

Product code: WLN-BUNDLE-BIDW

On successful Completion of the Business Intelligence & Analytics - Production Reporting Boot Camp course you will be able to:

• Understanding Enterprise Reporting Architectures
• Understand Business Intelligence, Analytics and OLAP Concepts
• Understanding Reporting and Data Warehousing Concepts
• Understanding the Report Development Process
• Understand Cognos 8, BusinessObjects XI and BI Publisher Technology & Architectures
• Explore different Cognos Report Studio report types (list, crosstab, chart)
• Create Production Reports in Cognos Report Studio
• Create and Format reports and other formatting options
• Focus Report Studio reports by filtering data and using prompts
• Understand Oracle BI Publisher 11g Production Reporting
• Create Production Reports in Oracle BI Publisher 11g
• Create and Modify Data Models
• Create Layouts by Using the Layout Editor
• Create RTF Templates by Using Template Builder
• Define parameters and LOVs for a data model
• Create BI Publisher reports based on data models
• Create report layouts by using the Layout Editor (online)
• Analyze data by using the Excel Analyzer
• Understand the BusinessObjects XI Desktop Intelligence Reporting Interface
• Understand Desktop Intelligence Reporting
• Create Production Reports in Desktop Intelligence
• Enhance Reports in Desktop Intelligence
• Customise Reports in Desktop Intelligence

Certification: This course will assist in preparation for the Microsoft Business Intelligence Certification exams.

Product code: WLN-BUNDLE-BIDW

On successful Completion of the Multi-Dimensional Analytics: Modelling, Development and Analysis Boot Camp course you will be able to:

• Understand Key Business Intelligence and OLAP Concepts
• Understand the BI and OLAP Development Life-cycle
• Understand Business Intelligence and OLAP Tools: Architecture and Concepts
• Model and Build PowerPlay Transformer Cubes
• Model and Build Microsoft SQL Server Analysis Services Cubes
• Model and Build Hyperion Essbase Applications and Databases
• Set up drill-through access and Create drill-through reports for Cognos PowerPlay
• Manage OLAP content in Cognos Connection

Certification: This course will assist in preparation for the Microsoft Business Intelligence Certification exams.

Product code: WLN-BUNDLE-BIDW

On successful Completion of the Multi-Dimensional Analytics: Data Analysis, Exploration and Visualisation Boot Camp course you will be able to:

• Understand Key Business Intelligence and OLAP Concepts
• Understand the BI and OLAP Development Life-cycle
• Understand Business Intelligence and OLAP Tools: Architecture and Concepts
• Analyse and Visualise PowerPlay Transformer Cubes using Cognos Analysis Studio
• Analyse and Visualise Microsoft SQL Server Analaysis ServiceS Cubes using PowerPivot
• Analyse and Visualise Oracle and Hyperion Essbase Cubes using Oracle BIEE
• Analyse and Visualise Hyperion Essbase Cubes using SmartView
• Explore different OLAP report types (list, crosstab, chart, map)
• Create and Format OLAP reports using Microsoft PowerPivot, Hyperion SmartView and Cognos Analysis Studio
• Focus OLAP reports by filtering data and using prompts
• Add value to your reports using calculations and additiona report building techniques
• Enhance reports with advanced formatting and exceptional data highlighting
• Manage OLAP content in Cognos Connection

Certification: This course will assist in preparation for the Microsoft Business Intelligence Certification exams.

Product code: WLN-BUNDLE-BIDW

On successful Completion of the Business Intelligence and Analytics - Ad-Hoc Reporting Boot Camp course you will be able to:

• Understand Key Business Intelligence, Analytics and OLAP Concepts
• Understand Data Anlysis and Visualisation Concepts
• Understand the BI, Analytics and OLAP Development Life-cycle
• Understand Business Intelligence, Analytics and OLAP Tools and Architecture Concepts
• Analyse and Visualise Cognos PowerPlay Transformer Cubes using Cognos Analysis Studio
• Analyse and Visualise Microsoft SQL Server Analaysis Services Cubes using PowerPivot
• Analyse and Visualise Oracle Databases using Oracle BIEE
• Analyse and Visualise Oracle Databases using BusinessObjects WebIntelligence XI
• Explore different OLAP Data Exploration, Visualisation and Analysis types (list, crosstab, chart, map)
• Create and Format OLAP reports using Microsoft PowerPivot and Cognos Analysis Studio
• Focus Data Exploration by filtering data and using prompts
• Add value to your data analysis using calculations and additional data visualisation techniques
• Enhance data visualisation with advanced formatting and exceptional data highlighting
• Manage content in Cognos Connection

Certification: This course will assist in preparation for the Microsoft Business Intelligence Certification exams.

Product code: WLN-BUNDLE-BIDW

On successful Completion of the Business Intelligence and Data Warehousing Fundamentals 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 and Microsoft 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 Business, Logical, Dimensional, and Physical Modeling
• Understand Oracle, SAP and Microsoft ETL Development Tools
• Understand the Oracle, SAP, Microsoft and IBM Cognos Business Intelligence and Analytics Technology Stack
• Understand the The BI and OLAP Development Life-Cycle
• Understand the BI and Warehouse Architecture Framework
• Understand Business Dimension Modelling
• Build Data Analysis, Visualisation and Interactive Dashboards in Oracle BIEE
• Build Data Analysis and Visualisation in Cognos Reports Studio

Certification: This course will assist in preparation for the Oracle and Microsoft SQL Server Business Intelligence Certification exams.

Product code: WLN-MSFT-BIDW

On successful Completion of the Microsoft Power BI Desktop for Technical Users course you will be able to:

• Power BI Overview
• Power BI Architecture
• Installing Power BI Desktop
• Accessing Data
• Transforming Data
• Modelling Data
• Visualisation

Certification: This course will assist in preparation for the Microsoft Business Intelligence Certification exams.

Product code: WLN-MSFT-PWBIDSK

On successful Completion of the Analyzing Data with Power BI course you will be able to:

• Perform Power BI desktop data transformation
• Describe Power BI desktop modelling
• Create a Power BI desktop visualization
• Implement the Power BI service
• Describe how to connect to Excel data
• Describe how to collaborate with Power BI data
• Connect directly to data stores
• Describe the Power BI developer API
• Describe the Power BI mobile app

Certification: This course will assist in preparation for the MCSA SQL Server Business Intelligence Certification exams.

Product code: WLN-MSFT-BIDW

On successful Completion of the Microsoft Power BI Desktop for Business Users course you will be able to:

• Power BI Desktop Concepts and Main Features
• Data Sources compatible with Power BI Desktop
• Connecting to Data with Power BI Desktop
• Explore Data Visualizations
• Apply Common Query Tasks to Shape Data in Power BI Desktop
• Create and publish Reports

Certification: This course will assist in preparation for the Microsoft Business Intelligence Certification exams.

Product code: WLN-MSFT-PWBIBUS

On successful Completion of the Power BI Reports and Dashboards for Business Users course you will be able to:

• Perform Power BI desktop data transformation
• Describe Power BI desktop modelling
• Create a Power BI desktop visualization
• Implement the Power BI service
• Describe how to connect to Excel data
• Describe how to collaborate with Power BI data
• Connect directly to data stores
• Describe the Power BI developer API
• Describe the Power BI mobile app

Certification: This course will assist in preparation for the MCSA SQL Server Business Intelligence Certification exams.

Product code: WLN-MSFT-BIDW

On successful Completion of the SQL Server Reporting Services: Data Analysis and Visualisation course you will be able to:

• Understand SQL Server Reporting Services and its components
• Describe key features of data modelling within business intelligence
• Describe various report services data sources and how these are configured
• Create reports with report designer and/or report builder
• Configure reports with report designer and/or report builder
• Enhance a Reporting Services report
• Create and manipulate data sets
• Configure report publishing and execution settings
• Implement subscriptions for reports
• Create SQL Server mobile reports

Certification: This course will assist in preparation for the Microsoft Business Intelligence Certification exams.

Product code: WLN-MSFT-BIDW

On successful Completion of the Microsoft Business Intelligence and Data Warehousing BootCamp course you will be able to:

• Learn to Plan and Scope your SQL Server Data Warehouse Projects
• Understand BI and Warehouse Architecture Frameworks
• Understand the BI and Warehouse Development Process
• Learn to Manage SQL Server Warehouse Projects
• Understand the Data Warehouse and ETL Development Lifecycle
• Understand Data Warehousing Concepts
• Understand Dimension Modelling
• Understand SQL Server Warehouse Capabilities
• Understand Data warehouse concepts and architecture considerations
• Understand Data Warehouse Administration
• Understand Data Quality Issues in ETL Process
• Understand the architecture of the SQL Server Integration Service system
• Select an appropriate hardware platform for a data warehouse
• Design and implement a data warehouse
• Implement data flow and control flow in a SSIS package
• Create and Manage Projects
• Define Integration Processes
• Manage metadata in SQL Server Integration Service
• Enforce data quality constraints in a Package
• Debug and troubleshoot SSIS packages
• Implement a SSIS incremental data warehouse loads and extracting data
• Deploy and configure SSIS packages

Certification: This course will assist in preparation for the Microsoft Business Intelligence Certification exams.

Product code: WLN-MSFT-BIDW

On successful Completion of the Microsoft SQL Server Reporting Services (SSRS) Fundamentals course you will be able to:

• Understand SQL Server Reporting Services and its components
• Create a Reporting Services report
• Enhance a Reporting Services report
• Create and manipulate data sets
• Use report models to implement reporting for business users
• Configure report publishing and execution settings
• Implement subscriptions for reports
• Administer Reporting Services
• Implement custom Reporting Services applications

Certification: This course will assist in preparation for the Microsoft Business Intelligence Certification exams.

Product code: WLN-MSFT-BIDW

On successful Completion of the Career Enabler: Microsoft Business Intelligence: Reporting and Analysis course you will be able to:

• Understanding the Microsoft BI Project Planning and Scoping Activities
• Capture Requirements for your BI Environment
• Understand the creation of Report ApplicationS
• Understand the creation of Technical Design Specification documents
• Components, architecture and nature of a BI solution
• Implement Dimensions in a cube
• Implement Measures and measure groups in a cube
• Understand Multidimensional Expressions (MDX) syntax
• Understand Cube customisation
• Implement tabular data model in SQL Server Analysis Services
• Enhance a tabular model using DAX
• Build queries in Microsoft BI Reporting Services
• Enhance Reports using charts and parameters
• Manage Report execution and Delivery

Certification: This course will assist in preparation for the Microsoft SQL Server Business Intelligence Certification exams.

Product code: WLN-MSFT-BIDW

On successful Completion of the Career Enabler: Microsoft Microsoft SQL Server Analysis Services Essentials course you will be able to:

• Understand Key BI and OLAP Concepts
• Understand the BI and OLAP Development Life-cycle
• Implement analytical solutions
• Create multidimensional analysis solutions
• Implement dimensions and cubes
• Implement measures and measure groups
• Query a multidimensional Database
• Customise an Analysis Services cube
• Deploy and secure an Analysis Services database
• Maintain a multidimensional Analysis Services solution

Certification: This course will assist in preparation for the Microsoft SQL Server Business Intelligence Certification exams.

Product code: WLN-MSFT-BIDW

On successful Completion of the Career Enabler: Microsoft SQL Server Integration Services Essentials course you will be able to:

• Understanding SQL-Server Integration Services and its tools
• Create an Integration Services package
• Implement control flow in an Integration Services package
• Implement data flow in an Integration Services package
• Implement logging in an Integration Services package
• Debug and implement error handling in an Integration Services package
• Implement checkpoints and transactions in an Integration Services package
• Deploy an Integration Services package
• Manage and secure an Integration Services package

Certification: This course will assist in preparation for the Microsoft SQL Server Business Intelligence Certification exams.

Product code: WLN-MSFT-BIDW

On successful Completion of the Career Enabler: Microsoft Microsoft Business Intelligence: Modelling and Reporting course you will be able to:

• Understanding the Microsoft BI Project Planning and Scoping Activities
• Capture Requirements for your BI Environment
• Understand the creation of Report Applications
• Understand the creation of Technical Design Specification documents
• Components, architecture and nature of a BI solution
• Implement Dimensions in a cube
• Implement Measures and measure groups in a cube
• Understand Multidimensional Expressions (MDX) syntax
• Understand Cube customisation
• Implement tabular data models in SSAS
• Enhance a tabular model using DAX
• Build queries in Microsoft BI Reporting Services
• Enhance Reports using charts and parameters
• Manage Report execution and Delivery

Certification: This course will assist in preparation for the Microsoft SQL Server Business Intelligence Certification exams.

Product code: WLN-MSFT-BIDW

On successful Completion of the Career Enable: for SQL Server Business Intelligence course you will be able to:

• Comprehend fundamentals of Database Administration
• Comprehend Querying Databases
• Comprehend Data warehouse fundamentals
• Comprehend fundamentals of OLAP cubes
• Use SQL Server to implement a Data Warehouse
• Manage operations in SQL Server 2012 Databases
• Design and implement Business Intelligence Solutions in SQL Server 2012
• Comprehend fundamentals of Cloud Computing and SQL Azure

Certification: This course will assist in preparation for the MCSA SQL Server Business Intelligence Certification exams.

Product code: WLN-MSFT-BIDW

On successful Completion of the Career Enabler for MCSA: SQL Server 2014/2016 Certification course you will be able to:

• Create database objects
• Work with data
• Modify data
• Troubleshoot and optimize
• Install and configure
• Maintain instances and databases
• Optimize and troubleshoot
• Manage data
• Implement security
• Extract and transform data
• Load data
• Configure and deploy SSIS solutions
• Build data quality solutions

Certification: This course will assist in preparation for the MCSA SQL Server 2014/2016 Certification Certification exams.

Product code: WLN-MCSA-BIDW

On successful Completion of the Career Enabler: for MCSE SQL Server 2014/2016 BI Platform course you will be able to:

• Designing, configuring, installing, and administering the business intelligence platform of SQL 2014
• Designing databases for Analysis Services
• Designing BI solution architecture
• Administering, maintaining and troubleshooting SSAS database
• Designing tabular data models
• Generating reports with SRSS (SQL Server Reporting Services)
• Planning the complete BI infrastructure
• Creating Reporting Solutions
• Designing ETL Solutions
• Provisioning Hardware and Software services
• Designing Data mart and data warehouse structure
• Designing OLAP (Online Analytical Processing) cubes
• Integrating applications with business applications such as SharePoint etc.

Certification: This course will assist in preparation for the MCSE SQL Server BI Platform Certification exams.

Product code: WLN-MSFT-BIDW

On successful Completion of the Career Enabler: for MCSE SQL Server 2014/2016 Data Platform course you will be able to:

• Designing, configuring, installing, and maintaining databases in a Microsoft enterprise set up
• Implementing and troubleshooting database objects in SQL Server
• Querying SQL 2014/2016 Server
• Administering SQL Server 2014 database environments
• Implementing data warehouse with SQL server 2014/2016
• Designing solutions for SQL 2014/2016 databases

Certification: This course will assist in preparation for the MCSE SQL Server 2014/2016 Data Platform Certification exams.

Product code: WLN-MSFT-DATPLAT

On successful Completion of the Career Enabler: Foundations of Microsoft AI, Machine Learning and Big Data Platform course you will be able to:

• Gain a high-level understanding of SQL Server 2016/2017
• Understand the mission-critical and hybrid capabilities of SQL Server
• Gain a high-level understanding of Azure Data Services
• Gain a high-level understanding of Modern Data Warehouse
• Gain a high-level understanding of SQL Server BI
• Gain a high-level understanding of SQL Server Enterprise Information Management
• Gain a high-level understanding of Power BI
• Gain a high-level understanding of Azure Machine Learning
• Gain a high-level understanding of Azure Data Factory
• Gain a high-level understanding of SQL Server R Services
• Gain a high-level understanding of Hadoop on Azure
• Gain a high-level understanding of Azure Data Lake
• Gain a high-level understanding of Apache Spark

Certification: This course will assist in preparation for the Microsoft, IBM and Oracle Data Science and Machine Learning Certification exams.

Product code: CEN-BIG-MSPLT-eLearning

On successful Completion of the Fundamentals of Microsoft Azure Data Warehousing course you will be able to:

• Understand Data Warehousing Concepts
• Understand key SQL Data Warehouse concepts
• Understand the Data Warehouse and ETL Development Lifecycle
• Understand SQL Data Warehouse topology and architecture
• Understand Azure Data Warehouse database design
• Understand ETL (data access, data export) in SQL Data Warehouse
• Learn how to Extract, Transform, and Load (ETL) Data in Azure SQL Data Warehouse
• Understand data movement and distribution theory in SQL Data Warehouse
• Understand big data and SQL Server integration
• Understanding Azure Data Warehouse to BI integration, including with Power BI

Certification: This course will assist in preparation for the Microsoft Business Intelligence Certification exams.

Product code: WLN-MSFT-AZUDW

On successful Completion of the Fundamentals of SQL Server 2016 Platform course you will be able to:

• Gain a high-level understanding of SQL Server
• Understand the new features in SQL Server 2016
• Understand SQL Server In-Memory Optimization (OLTP)
• Understand SQL Server In-Memory Data Warehouse capabilities
• Understand SQL Server 2016 high-availability features
• Understand SQL Server 2016 SQL Server security features
• Understand SQL Server 2016 Query Store and Live Query Statistics
• Understand SQL Server 2016 Temporal Tables
• Understand the integration of SQL Server 2016 with big data sources with PolyBase
• Understand SQL Server 2016 Stretch Database
• Gain a high-level understanding of SQL Server R Services Analytics
• Understand SQL Server 2016 R Services integration

Certification: This course will assist in preparation for the Fundamentals of SQL Server 2016 Platform Certification exams.

Product code: WLN-MSFT-BIDW

On successful Completion of the Fundamentals of SQL Server 2017 Platform course you will be able to:

• Gain a high-level understanding of SQL Server
• Understand the new features in SQL Server 2017
• Understand SQL Server In-Memory Optimization (OLTP)
• Understand SQL Server In-Memory Data Warehouse capabilities
• Understand SQL Server 2017 high-availability features
• Understand SQL Server 2017 SQL Server security features
• Understand SQL Server 2017 Query Store and Live Query Statistics
• Understand SQL Server 2017 Temporal Tables
• Understand the integration of SQL Server 2017 with big data sources with PolyBase
• Understand SQL Server 2017 Stretch Database
• Gain a high-level understanding of SQL Server R Services Analytics
• Understand SQL Server 2017 R Services integration

Certification: This course will assist in preparation for the Fundamentals of SQL Server 2017 Platform Certification exams.

Product code: WLN-MSFT-BIDW

On successful Completion of the Fundamentals of Microsoft On-Premise and Cloud Data Warehousing course you will be able to:

• Learn to Plan and Scope your SQL Server Data Warehouse Projects
• Understand BI and Warehouse Architecture Frameworks
• Understand the BI and Warehouse Development Process
• Learn to Manage SQL Server Warehouse Projects
• Understand the Data Warehouse and ETL Development Lifecycle
• Understand Data Warehousing Concepts
• Understand Dimension Modelling
• Understand key SQL Server Data Warehouse concepts
• Understand SQL Data Warehouse topology and architecture
• Understand Azure Data Warehouse database design
• Understand ETL (data access, data export) in SQL Data Warehouse
• Understand data movement and distribution theory in SQL Data Warehouse
• Understand big data and SQL Server integration
• Understanding Azure Data Warehouse to BI integration, including with Power BI

Certification: This course will assist in preparation for the Microsoft Business Intelligence Certification exams.

Product code: WLN-MSFT-AZUDW

On successful Completion of the Introduction to Data Modeling course you will be able to:

• Fundamentals of normalization and why it's important to transactional databases
• How to develop logical and physical data models
• How to model data security, privacy and protection requirements
• When and where to model database-specific performance requirements
• How model-driven development fits in a DevOps or agile environment
• How to avoid schema drift and other data anti-patterns

Certification: This course will assist in preparation for the Microsoft MCSE & MCSA Certification exams.

Product code: WLN-MSFT-BIDW

On successful Completion of the Career Enabler: Decision Modeling course you will be able to:

• Decision Modeling
• Decision Tree
• Supervised learning
• Unsupervised learning
• Artificial Neural Networks
• Twitter Data Processing with R

Certification: This course will assist in preparation for the Decision Modeling Certification exams.

Product code: WLN-MSFT-BIDW

On successful Completion of the Cognos BI: Report Studio Fundamentals course you will be able to:

• Explore Report Studio, different report types (list, crosstab, chart, map)
• Create and Format reports using grouping, headers, footers, and other formatting options
• Focus reports by filtering data and using prompts
• Add value to your reports using calculations and additional report building techniques
• Enhance reports with advanced formatting and exceptional data highlighting
• Author reports through query models
• Set up drill-through access and Create drill-through reports
• Manage content in Cognos Connection

Certification: This course will assist in preparation for the Cognos 8 and 10 Business Intelligence Certification exams.

Product code: WLN-COG-BI-REPSTD

On successful Completion of the Cognos BI:Data Analysis and Visualisation course you will be able to:

• Understand Key BI and OLAP Concepts
• Understand Cognos BI: Analysis Studio Concepts
• Understand Data Analysis and Visualisation Concepts
• Explore Analysis Studio, different report types (list, crosstab, chart, map)
• Create and Format reports using grouping, headers, footers, and other formatting options
• Focus reports by filtering data and using prompts
• Add value to your reports using calculations and additional report building techniques
• Enhance reports with advanced formatting and exceptional data highlighting
• Author reports through query models
• Set up drill-through access and Create drill-through reports
• Manage content in Cognos Connection

Certification: This course will assist in preparation for the Cognos 8 and 10 Business Intelligence Certification exams.

Product code: WLN-COG-BIDAVIS

On successful Completion of the Cognos BI: Reporting & Analysis BootCamp course you will be able to:

• Understand IBM Cognos BI
• Create Reports in Report Studio
• Enhance Reports in Report Studio
• Customise Reports in Report Studio
• Analysis Studio Fundamentals
• Tools for Investigation in Analysis Studio
• Nest Data in Crosstabs in Analysis Studio
• Build Advanced Crosstabs in Analysis Studio
• Focus with Filters in Analysis Studio
• Extend the Analysis
• Manage Content in Cognos Connection

Certification: This course will assist in preparation for the Cognos 8 and 10 Business Intelligence Certification exams.

Product code: WLN-COG-BIRAS-BC

On successful Completion of the Informatica Data Integration & ETL Fundamentals course you will be able to:

• Understand the ETL Development Lifecycle
• Understand basic Data warehousing Concepts
• Understand basic Dimension Modelling
• Understand Data Quality Issues in ETL Process
• Understand the architecture of the complete Informatica system
• Design and build simple mappings and workflows
• Use PowerCenter 9.x Designer to build mappings that extract data from a source to a target
• Use PowerCenter 9.x Designer to build transformations
• Use PowerCenter transformations to cleanse, format and join data
• Use PowerCenter transformations to aggregate and route data to targets
• Perform error handling/trapping using PowerCenter mappings
• Describe the use of Mapping Variables and Parameter Files
• Use PowerCenter 9.x Workflow Manager to build and run a workflow
• Use PowerCenter 9.x Workflow Manager to execute sessions associated with a mapping
• Perform basic troubleshooting using PowerCenter logs and debugger
• Describe the SQL Transformation

Informatica Data Integration & ETL Fundamentals Self-Study eLearning:

Product code: WLN-INF-ETLFNDM

On successful Completion of the Informatica Data Integration & ETL BootCamp Self-Study eLearning course you will be able to:

• Learn to Plan and Scope your ETL/ELT Projects
• Understand the ETL Development Lifecycle
• Understand basic Data warehousing Concepts
• Understand basic Dimension Modelling
• Understand the Oracle Data Integration Reference Architecture
• Understand Data Quality Issues in ETL Process
• Understand the architecture of the complete Informatica system
• Describe the Informatica domain, nodes, and application services
• Describe the Informatica clients
• Install Informatica 9.6.x domain
• Describe the Administration Console
• Create Privileges and Roles
• Describe PowerCenter repositories
• Deploy PowerCenter metadata from development to test environment
• Describe Domain Management
• Design and build simple mappings and workflows
• Use PowerCenter 9.6.x Designer to build mappings that extract data from a source to a target
• Use PowerCenter 9.6.x Designer to build transformations
• Use PowerCenter transformations to cleanse, format and join data
• Use PowerCenter transformations to aggregate and route data to targets
• Perform error handling/trapping using PowerCenter mappings
• Describe the use of Mapping Variables and Parameter Files
• Use PowerCenter 9.6.x Workflow Manager to build and run a workflow
• Use PowerCenter 9.6.x Workflow Manager to execute sessions associated with a mapping
• Perform basic troubleshooting using PowerCenter logs and debugger
• Perform basic troubleshooting using PowerCenter logs and debugger
• Describe user defined and advanced functions
• Describe how to Normalize and Denormalize data using PowerCenter
• Describe the Stored Procedure transformation and its two modes of use
• Describe the SQL Transformation

Informatica Data Integration & ETL Bootcamp Self-Study eLearning:

Product code: WLN-INF-ETLBC

On successful Completion of the Informatica 9.6.x Data Warehousing Fundamentals Self-Study eLearning course you will be able to:

• Understand the Informatica Data Warehouse and ETL Development Lifecycle
• Understand the BI and Warehouse Development Process
• Learn to Manage Informatica Warehouse Projects
• Understand Data warehousing Concepts
• Understand Dimension Modelling
• Understand Data Quality Issues in ETL Process
• Understand the architecture of the Informatica system
• Manage your Informatica environment using the Informatica Console
• Use PowerCenter 9.x Designer to build mappings
• Use PowerCenter 9.x Designer to extract data from a source to a target
• Use PowerCenter 9.x Designer to build transformations
• Use PowerCenter transformations to cleanse, format and join data
• Use PowerCenter transformations to aggregate and route data to targets
• Perform error handling/trapping using PowerCenter mappings
• Describe the use of Mapping Variables and Parameter Files
• Use PowerCenter 9.x Workflow Manager to build and run a workflow
• Use PowerCenter 9.x Workflow Manager to execute sessions associated with a mapping

Informatica Data Integration & ETL Fundamentals Self-Study eLearning:

Product code: WLN-INF-DWFNDM

On successful Completion of the Informatica 9.6.x Data Warehousing BootCamp Self-Study eLearning course you will be able to:

• Understand the Informatica Data Warehouse and ETL Development Lifecycle
• Understand the BI and Warehouse Development Process
• Learn to Manage Informatica Warehouse Projects
• Understand Data warehousing Concepts
• Understand Dimension Modelling
• Understand Data Quality Issues in ETL Process
• Describe the Informatica 9.6.x Technical architecture
• Describe the Informatica domain, nodes, and application services
• Describe the Informatica clients
• Install Informatica 9.6.x domain
• Describe the Administration Console
• Create Privileges and Roles
• Describe PowerCenter repositories
• Deploy PowerCenter metadata from development to test environment
• Describe Domain Management
• Describe the Informatica PowerCenter architecture
• Design and build simple mappings and workflows
• Manage your Informatica environment using the Informatica Console
• Use PowerCenter 9.6.x Designer to build mappings
• Use PowerCenter 9.6.x Designer to extract data from a source to a target
• Use PowerCenter 9.6.x Designer to build transformations
• Use PowerCenter transformations to cleanse, format and join data
• Use PowerCenter transformations to aggregate and route data to targets
• Perform error handling/trapping using PowerCenter mappings
• Describe the use of Mapping Variables and Parameter Files
• Use PowerCenter 9.6.x Workflow Manager to build and run a workflow
• Use PowerCenter 9.6.x Workflow Manager to execute sessions associated with a mapping

Informatica 9.6.X Data Warehousing BootCamp Self-Study eLearning:

Product code: WLN-INF-DWBC

On successful Completion of the Oracle 11g Data Warehousing Fundamentals Self-Study eLearning course you will be able to:

• Define the terminology and explain the basic concepts of data warehousing
• Understand the Oracle Data Warehouse Technology Stack
• Understand the Oracle Data Warehouse Reference Architecture
• Understand the Oracle Business Intelligence and Analytics Technology Stack
• Describe methods and tools for extracting, transforming, and loading data
• Use Oracle Data Integrator 11g ETL for extracting, transforming, and loading data
• Identify some of the tools for accessing and analysing 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
• Understand the implementation and organisational issues surrounding a data warehouse project
• Use materialised views and query rewrite to improve the data warehouse performance
• Develop familiarity with some of the technologies required to implement a data warehouse

Certification: This course will assist in preparation for the Oracle BI Certified Implementation Specialist 1Z0-591 Certification exam.

Product code: WLN-ORA-DWFNDM

On successful Completion of the Oracle 12c Data Warehousing Fundamentals Self-Study eLearning course you will be able to:

• Define the terminology and explain the basic concepts of data warehousing
• Understand the Oracle Data Warehouse Technology Stack
• Understand the Oracle Data Warehouse Reference Architecture
• Understand the Oracle Business Intelligence and Analytics Technology Stack
• Describe methods and tools for extracting, transforming, and loading data
• Use Oracle Data Integrator 11g ETL for extracting, transforming, and loading data
• Identify some of the tools for accessing and analysing 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
• Understand the implementation and organisational issues surrounding a data warehouse project
• Use materialised views and query rewrite to improve the data warehouse performance
• Develop familiarity with some of the technologies required to implement a data warehouse

Certification: This course will assist in preparation for the Oracle BI Certified Implementation Specialist 1Z0-591 Certification exam.

Product code: WLN-ORA-DWFNDM

On successful Completion of the Oracle 18c Data Warehousing Fundamentals Self-Study eLearning course you will be able to:

• Define the terminology and explain the basic concepts of data warehousing
• Define the terminology and explain the basics of Oracle Big data warehousing
• Understand the Oracle 18c Data Warehouse Technology Stack
• Understand the Oracle 18c Multitenant Architecture for Data Warehousing
• Understand the Oracle 18c Data Warehouse Reference Architecture
• Discuss the different Oracle tools to implement data warehousing on-premise
• Discuss Autonomous Data Warehouse Cloud (ADWC) and Data Integration Platform Cloud (DIPC)
• Understand the Oracle Business Intelligence and Analytics Technology Stack
• Describe methods and tools for extracting, transforming, and loading data
• Use Oracle Data Integrator ETL for extracting, transforming, and loading data
• Identify some of the tools for accessing and analysing warehouse data
• Understand the Oracle 18c AI & Machine Learning Tools for data warehousing
• 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
• Understand the implementation and organisational issues surrounding a data warehouse project
• Use materialised views and query rewrite to improve the data warehouse performance
• Develop familiarity with some of the technologies required to implement a data warehouse

Certification: This course will assist in preparation for the Oracle BI Certified Implementation Specialist 1Z0-591 Certification exam.

Product code: WLN-ORA-DW18cFNDM

On successful Completion of the Oracle Data Integrator 11g Fundamentals course you will be able to:

• Understand the ETL Development Lifecycle
• Understand basic Data warehousing Concepts
• Understand basic Dimension Modelling
• Understand Data Quality Issues in ETL Process
• Understand the architecture of the Oracle Data Integrator system
• Define Data Sources
• Define Physical and Logical Architecture
• Create and reverse-engineer models
• Manage Projects
• Define Integration Processes
• Work with projects in Oracle Data Integrator
• Release your ODI work for deployment
• Understand models, reverse-engineering model metadata from your database
• Manage metadata in Oracle Data Integrator: models and data quality
• Create simple interfaces and add multiple sources to an interface
• Launch a session to run an interface
• Enforce data quality constraints in an interface
• Manage packages

Certification: This course will assist in the preparation for the Oracle Data Integrator 11g Certified Implementation Essentials - 1Z0-482 exam.

Product code: WLN-ORA-ODIFNDM

On successful Completion of the Oracle Data Integrator 11g Certified Implementation Essentials - 1Z0-482 course you will be able to:

• Learn to Plan and Scope your ETL/ELT Projects
• Understand the ETL Development Lifecycle
• Describe Oracle Fusion Middleware (FMW)
• Describe the Oracle Data Integrator (ODI) system logical architecture
• Identify and describe Oracle DI Java components
• Identify the system administration tools that are available for managing Oracle DI
• Define the Oracle Data Integrator 11g (ODI) Information System architecture
• Describe scenarios in which FMW Control is available
• Start and stop instances of WebLogic Server by using FMW Control
• Configure ODI11g Java EE Agent Components
• Monitor a WebLogic Server (WLS) domain with FMW Control
• Centrally manage Oracle DI components using Fusion Middleware Control
• Centrally manage Oracle DI Java components using the Oracle WebLogic Server Console
• Stop and start Oracle DI components
• Understand Data Quality Issues in ETL Process
• Understand the architecture of the complete Oracle Data Integrator system
• Create Data Servers and Sources
• Define Physical and Logical Architecture
• Create and reverse-engineer models
• Manage Projects
• Define Integration Processes
• Work with projects in Oracle Data Integrator
• Release your ODI work for deployment
• Understand models, reverse-engineering model metadata from your database
• Manage metadata in Oracle Data Integrator: models and data quality
• Create simple interfaces and add multiple sources to an interface
• Launch a session to run an interface
• Enforce data quality constraints in an interface
• Manage packages
• Manage and Monitor ETL processes in the ODI Console

Certification: This course will assist in the preparation for the Oracle Data Integrator 11g Certified Implementation Essentials - 1Z0-482 exam.

Product code: WLN-ORA-ODIBC

On successful Completion of the Oracle Data Integrator 12c Certified Implementation Essentials - 1Z0-482 course you will be able to:

• Learn to Plan and Scope your ETL/ELT Projects
• Understand the ETL Development Lifecycle
• Describe Oracle Fusion Middleware (FMW)
• Describe the Oracle Data Integrator (ODI) system logical architecture
• Identify and describe Oracle DI Java components
• Identify the system administration tools that are available for managing Oracle DI
• Define the Oracle Data Integrator 11g (ODI) Information System architecture
• Describe scenarios in which FMW Control is available
• Start and stop instances of WebLogic Server by using FMW Control
• Configure ODI11g Java EE Agent Components
• Monitor a WebLogic Server (WLS) domain with FMW Control
• Centrally manage Oracle DI components using Fusion Middleware Control
• Centrally manage Oracle DI Java components using the Oracle WebLogic Server Console
• Stop and start Oracle DI components
• Understand Data Quality Issues in ETL Process
• Understand the architecture of the complete Oracle Data Integrator system
• Create Data Servers and Sources
• Define Physical and Logical Architecture
• Create and reverse-engineer models
• Manage Projects
• Define Integration Processes
• Work with projects in Oracle Data Integrator
• Release your ODI work for deployment
• Understand models, reverse-engineering model metadata from your database
• Manage metadata in Oracle Data Integrator: models and data quality
• Create simple interfaces and add multiple sources to an interface
• Launch a session to run an interface
• Enforce data quality constraints in an interface
• Manage packages
• Manage and Monitor ETL processes in the ODI Console

Certification: This course will assist in the preparation for the Oracle Data Integrator 12c Certified Implementation Essentials - 1Z0-482 exam.

Product code: WLN-ORA-ODIBC-12c