How This Course Is Organised

The Business Intelligence and Data Warehousing Fundamentals course provides step-by-step instructions on how to perform a variety of data analysis, visualisation and data warehouse development tasks for activities based on real-life work scenarios. This course provides step-by-step instructions for capturing requirements, learn about the basic concepts of a data warehouse. Explore the issues involved in planning, designing, building, populating and maintaining a successful data warehouse.

Students learn to use Oracle and Cognos Data Analysis and Visualisation Tools, including build of Oracle BI Interactive Dashboards and Cognos Reports Studio; using Data analysis and Visualisation techniques including pivot tables, charts, gauges, prompts, embedded content and navigation links and Interactive Dashboards for users.

Data Warehousing and Analytics Tools: 

During this course, you'll  use some of the available Oracle, Microsoft and IBM Business Intelligence and data warehousing tools. These tools include Oracle Database, Oracle Data Integrator, Microsoft  SSIS, Oracle BIEE, Cognos Reports Studio and Business Objects WebIntelligence.

Certification:
This course will assist in preparation for the IBM Cognos BI, Microsoft BI or Oracle BI Certification exams.

Duration: N/A

Suggested Prerequisites:

Knowledge of your business requirements
Experience using basic Windows functionality
Experience using a Web browser

Audience

Data Warehouse Analysts
Business Analysts
Functional Implementer
Technical Consultant
Business Intelligence Developer
Data Warehouse Developer
Application Developers
Data Warehouse Administrator
Support Engineer

Course Objectives:

Upon completion of this Course, you should be able to:

Define the terminology and explain basic concepts of Business Intelligence

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 Modelling

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
Build Data Analysis and Visualisation in SAP WebIntelligence

Course Outline

Overview 

Business Scenario 

Business Intelligence Value Proposition 

Key Business Intelligence Concepts 

What is Business Intelligence - BI? 

The Query and Analysis Continuum

The Dimensional Model and Oracle OLAP

Extraction, Transformation, and Loading (ETL)

Business Intelligence and OLAP Concepts

Overview of Analytics and Business Intelligence Tools

Oracle Analytics and BI Tools

Microsoft Analytics and BI Tools

Cognos Analytics and BI Tools

SAP Business Intelligence Tools

The Business Intelligence Development Life-Cycle

Capturing User Requirements Management

Identify People Involved

Interview Appropriate People

Identify business process requirements

Identify the grain

Identify the dimensions

Identify the facts

Verify the model

Physical (report) design considerations

Meta data management

Create Requirements Definition Document

The Application specification Document

Agree Requirements Definition document with the Users

Project Management and Review

Overview of ETL Tools 

Oracle Data Integrator and Warehouse Builder

Oracle SQL*Loader and Data Pump

Microsoft SQL Server Integration Services

SAP BusinessObjects Data Integrator/Services

BI and Warehouse Architecture Framework

Data Sources

Data Access, Transformation, Cleansing

Staged Data

Business Subject Data

Multidimensional Data

Backup, Archive Data

Structured Query Language and OLAP Engine

Business Intelligence Applications

Administration, Automation, Operation, Control

Metadata Repository

Visualisation and Publishing

Data Warehouse Concepts and Terminology

Data Warehouse Definition and Properties

Data Warehouse Versus OLTP

Data Warehouses Versus Data Marts

Typical Data Warehouse Components

Warehouse Development Approaches

Data Warehousing Process Components

Strategy Phase Deliverables

Understanding Business Dimension Modelling

Building a Business Dimension Model

Analysing Data Elements from your Model

Business Dimension Model Design Issues

Identifying Source Data elements for the Model

Relational Data Modelling in OLAP Environments

Business, Logical, Dimensional, and Physical Modeling

Data Warehouse Modeling Issues

Defining the Business Model

Defining the Logical Model

Defining the Dimensional Model

Defining the Physical Model: Star, Snowflake, and Third Normal Form

Fact and Dimension Tables Characteristics

Translating Business Dimensions into Dimension Tables

Translating Dimensional Model to Physical Model

Database Sizing, Storage, Performance, and Security Considerations

Overview of Oracle and Microsoft Database Architectures

Database Sizing and Estimating and Validating the Database Size

Oracle Database Architectural Advantages

Data Partitioning

Indexing

Optimizing Star Queries: Tuning Star Queries

Parallelism

Security in Data Warehouses

Oracle’s Strategy for Data Warehouse Security

The ETL Process: Extracting Data

Extraction, Transformation, and Loading (ETL) Process

ETL: Tasks, Importance, and Cost

Extracting Data and Examining Data Sources

Mapping Data

Logical and Physical Extraction Methods

Extraction Techniques and Maintaining Extraction Metadata

Possible ETL Failures and Maintaining ETL Quality

ETL Tools: Oracle Data Integrator, SQL*Loader, and Data Pump

Microsoft SQL Server Integration Services

The ETL Process: Transforming Data

Transformation

Remote and Onsite Staging Models

Data Anomalies

Transformation Routines

Transforming Data: Problems and Solutions

Quality Data: Importance and Benefits

Transformation Techniques and Tools

Maintaining Transformation Metadata

The ETL Process: Loading Data

Loading Data into the Warehouse

Transportation Using Flat Files, Distributed Systems, and Transportable Tablespaces

Data Refresh Models: Extract Processing Environment

Building the Loading Process

Data Granularity

Loading Techniques Provided by Oracle and Microsoft

Postprocessing of Loaded Data

Indexing and Sorting Data and Verifying Data Integrity

Refreshing the Warehouse Data

Developing a Refresh Strategy for Capturing Changed Data

User Requirements and Assistance

Load Window Requirements

Planning and Scheduling the Load Window

Capturing Changed Data for Refresh

Time- and Date-Stamping, Database triggers, and Database Logs

Applying the Changes to Data

Materialized Views

Using Summaries to Improve Performance

Using Materialized Views for Summary Management

Types of Materialized Views

Build Modes and Refresh Modes

Query Rewrite: Overview

Cost-Based Query Rewrite Process

Working With Dimensions and Hierarchies

Introduction to Oracle BI Enterprise Edition

Introduction to Oracle BI Enterprise Edition Components

Understanding OBIEE Administration

Administrative Tasks

BI Repository (RPD) 

Oracle Business Intelligence Administrator 

BI Publisher Repository 

Navigating and Accessing Subject Areas with Answers 

Viewing Saved Requests by Dashboard 

Viewing Saved Requests in Presentation Catalog 

Searching for Saved Requests 

Printing a Dashboard or Request 

Downloading Oracle BI Requests 

Emailing Requests or Dashboards 

Setting Preferences 

Using Business Intelligence Answers 

Creating Reports and Dashboards

Creating a Query and Chart 

Creating a Query 

Creating a Filter 

Formatting the Query 

Creating Chart 

Working Pivot Tables 

Formatting Pivot Tables 

Using Interactive Dashboards 

Creating Interactive Dashboards 

Creating Dashboard Prompts 

Presentation Variables 

Dashboard Design Principles and Best Practices

Exploring Reporting Studio

Discuss different modes of reporting

Examine Report Studio and its interface

Explore different report types

Create a simple, sorted, and formatted report

explore how data items are added to queries

Create List Reports

Group, Format, and sort list reports

Describe options for aggregating data

Create a multi-fact query

Create a report with repeated data

The BusinessObjects Value Proposition

Business Objects Enterprise XI Overview

BusinessObjects Enterprise XI Architecture

Portal Integration Kits

Dashboards and Scorecards

Office Integration

SAP Business Intelligence

SAP WebIntelligence Introduction

Key Concepts

The Query and Analysis Continuum

Business Intelligence and OLAP Concepts

Business Objects and Data Warehouse Concepts

The Report Development Process

Identify People Involved

Identify business process requirements

Identify high level entities and measures for conformance

Select requirements gathering approach

Requirements Gathering

Requirements Analysis

Create Requirements Definition Document

Design and Build Reports

Acceptance Testing

Introducing Web Intelligence

Web Intelligence XI Architecture Overview

Accessing corporate information with WebI

Understanding how universes allow you to query databases.

Getting Started with InfoView

Managing documents in InfoView

Viewing a Web Intelligence document in InfoView

Customizing InfoView

Setting InfoView Preferences

Creating an InfoView dashboard with My InfoView

Creating Web Intelligence Documents with Queries

Getting new data with Web Intelligence

Creating a new Web Intelligence document

Modifying a document’s query

Working with query properties

Restricting Data Returned by a Query

Modifying a query with a predefined query filter

Applying a single-value query filter

Using prompts to restrict data

Using complex filters

Report Design in the Java Report Panel

Working in the Java Report Panel

Displaying data in tables and charts

Presenting data in free-standing cells

Enhancing the Presentation of Reports

Using breaks, calculations, sorts and report filters

Ranking data to see top or bottom values

Using alerters to highlight information

Organizing a report into sections

Copying data to other applications

Formatting Reports

Document formatting

Formatting charts

Creating Formulas and Variables

Using formulas and variables in the Java Report Panel

Synchronizing Data

Creating multiple queries in a document

Synchronizing data with merged dimensions

Analyzing Data

Analyzing the data cube

Drilling in the Java Report Panel

Setting Web Intelligence drill options

Sharing Web Intelligence Documents

Sharing documents

Scheduling a Web Intelligence document

What is a CBT?

CBT's are usually interactive with Software Simulations (behaves like you're using the real thing on the PC, therefore you don't even need the real software installed on your machine) and sometimes BUT NOT ALWAYS with voice. This Publisher's CBT Titles do NOT have voice.

Generally, CBT's tend to be more expensive. Our CBT Titles are NOT based on Flash. They are based on the latest technology which uses the: See It, Do It, and Try It learning paradigm. A very powerful new way of learning. All CBT and Courseware Learning formats are delivered with FULL LICENCE KEY.

Today's competitive business environment and frequent software updates by software vendors demands rapid skill acquisition. WebLearning Publishing helps you keep up-to-date by delivering quality Interactive Self-Study in CBT format. These factors give CBT's a clear advantage over conventional, inconvenient and expensive Classroom and Hard-copy print training methods.

CBT's not only offers the advantage in terms of convenience and lower cost, but it also facilitates improved subject-matter comprehension.

The WebLearning unique Methodology

All WebLearning® CBT and Courseware courses are based on the latest materials available at the time of publishing and are regularly updated every 3 months with FREE UPGRADES to the LATEST EDITION: ANEW, very effective and proven way of learning. 

FACT:

·        Material retention with CBT’S are 45% better than with conventional training methods

·        Your learning curve with CBT is 25%-55% less than conventional methods

·        The cost of CBT training is over 65% less than Classroom training

·        CBT’S are self pacing, interactive and simulate the actual software being studied