WHERESCAPE DEVELOPER – 3 DAY EDUCATION
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 vault and 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.
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.
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 a Data Vault:
In this module we learn how to build the Hub, Link and Satellite tables using the Data Vault Stage layer.
• Creation of DV staging tables which are going to be used to create the different DV tables.
• The creation of the Hub tables.
• Creation of the Link tables.
• Creation of the Satellite tables.
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.
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.
Understanding the different types of dimension tables:
• Slowly changing dimension.
• Conformed dimensions.
• Dimension hierarchies.
Understanding how to create aggregate fact tables:
• Base fact tables.
• Rollup fact table.
• Aggregate table.
Understanding how to create and manage OLAP Cubes:
• Create OLAP Cube.
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.