WhereScape Developer course is designed for existing Data Warehouse Practitioners who wish to use WhereScape  to design and build data warehouses and reporting databases. The course teaches WhereScape features, and how to Apply it to real life data scenarios using the rapid, iterative capability of WhereScape RED.

This 3 day instructor-led course includes two and a half days training on the usage of WhereScape, and a half day hands on Data Warehouse practice
which guides the delegate through design and build of a data mart from start to finish using WhereScape, using a transactional operational data source, through star schema or normalized models, to analysis cubes and data delivery, built using WhereScape and an iterative approach.


Data Warehouse Developers.


Tell me, show me, and let me do it.

Course Content:

Data Warehouse theory, terminology and model types:

A quick understanding of Data Warehouses and DW terminology along with a discussion of Star Scheme, Data Store, Third Normal
Form, Data Vault and Big Data modelling

WhereScape architecture and installation:

The Architecture and Installation module includes:

• An overview of the WhereScape technical architecture.
• How to install and configure WhereScape software and associated components such as metadata repository,
client applications, connectivity, etc.
• It demonstrates WhereScape components, from a developer perspective, describing how the components work together
including: the WhereScape interface, extract connections, metadata repository, defaults and environment variables.
• An understanding of the WhereScape Administrator utility and all of it’s functions.
• The use of the Administrator utility to create a new Data Warehouse repository.

Loading Data:

The Loading Data module includes:

• An understanding of the WhereScape interface, menu options, how to browse a source database and the different
object types.
• Utilise the different load data options, database link, ODBC, file load, SSIS, etc. from different sources, including Databases,
Excel, flat files and XML files.
• Understanding the transformations available at load time.

Data Store and Third Normal Form Tables:

In this module we:

• Explore the difference between Data Store and 3NF data warehouse tables and how to create them using WhereScape.
• This includes both non-history and slowly changing tables to show the differences in the table structure and the generated
SQL code.
• You also learn to handle multiple source tables.
• Use the Join Maintenance option to document the 3NF DW layer.

Building the Data Mart:

In this module we learn how to build the star scheme, how to manage change in the environment and create the DW documentation.

• Creation of dimensions and role playing dimension views, staging the data and creating fact tables make up the major
tables of the Data Mart.
• The creation of the Stored Procedures used to update the data across the DM.
• Using the inbuilt version control of objects in the metadata.
• We learn the different types of diagrammatic views WhereScape can produce.
• How to create and display documentation from the metadata repository.

Data Warehouse Management:

This module includes:

• Setting up developer Groups and Projects.
• Building, distributing and loading application packages.
• Versioning and migrating applications between Development, Test and Production repositories.
• Backing up RED metadata repositories.
• Customising DW documentation.

Data Warehouse Workflow:

Understanding the inbuilt WhereScape Scheduler:

• Setting up the schedulers.
• Creating a job, understanding the job definition.
• Adding tasks.
• Scheduler options.
• Creating a job from a diagram.


Create and use parameters:

• Creating, updating, deleting a parameter.
• Where used.
• Incremental loading.

Dimension Tables:

Understanding the different types of dimension tables:

• Slowly changing dimension.
• Conformed dimensions.
• Dimension hierarchies.

Aggregate Facts:

Understanding how to create aggregate fact tables:

• Base fact tables.
• Rollup fact table.
• Aggregate table.

OLAP Cubes:

Understanding how to create and manage OLAP Cubes:

• Create OLAP Cube.

Table Partitioning:

Understanding how to create a partitioned table:

• Creating a partitioned table.
• Understanding how WhereScape processes the updates and reads.

Build a Data Warehouse:

Using the Agile approach, build a data warehouse end-to-end:

• Create the environment.
• Create the load tables.
• Create the storage tables.
• Create the dimension tables and roll-playing date dimension views.
• Create the fact table.
• Create a job, including all the tasks.
• Create and display your fully documented warehouse.


25 - 27 Sep 2019


9:00 am - 5:00 pm




WhereScape Developer


Level 14, 9 Hunter Street, Sydney