Training:
CXWarehouse

Course Duration: 1 day

Overview

This course is designed to give users an understanding of how to configure and maintain CXAIR and learn how to make their data available for searching, analysing and building reports.

Who Should Attend?

IT professionals who either need to understand how to create a Data Warehouse within CXAIR and/or manage the daily operational processes of supporting a CXAIR Warehouse. Ideally with a pre-requisite of attending the Administrator Training.

Course Benefits

Upon completion of this course, attendees will be able to:

  • Understand the core concepts behind CXAIR’s Rule Base Warehouse
  • Understand the structure of Indexes, Search Engines and Collections
  • Apply initial data correction techniques
  • Union and amalgamate indexes and data sources
  • Use Linked fields to bring in data from reference tables to your index
  • Apply best practices when selecting indexing methods
  • Setup Rules to validate and update the data to improve data quality
  • Understand best practices for data validation and promotion
  • Setup schedules for refreshing and maintaining indexes
  • Use Filter Indexes to enhance reporting capabilities with flags and aggregations
  • Use Data Marts to segment a subset of data from an index into its own index

Course Content

The following topics will be covered during this course:

Introduction to CXWarehouse

  • Basic Overview of the CXWarehouse Architecture
  • Core Concepts
  • Warehouse Summary
  • Indexes Summary

Data Correction and Validation

  • Folder Structures
  • Combined Queries
  • Publishing and Sharing
  • Setting up Report Schedules

Data Joining

  • Amalgamated Indexes
  • Linked Fields
  • Unioned Indexes

Data Enhancement

  • Using Filters as Columns in your Index

Rules-based Warehouse

  • Overview
  • Creating Validation Rules
  • Creating Update Rules
  • Rules Data Source
  • Rules Promotion indexes
  • Rules Summary Index

Operational Management

  • Collections
  • Configuration Settings
  • Import and Export
  • Auditing Log and Usage Analysis
  • Backup Strategies

Advanced Indexing

  • Filters Indexes
  • Layers
  • Flags and Aggregations
  • Data Marts

More information

Get in touch to discuss your requirements further