Connexica logo

CXWAREHOUSE

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.

Duration: 1day

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.

Benefits

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

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