PCI Data Warehouse Training Class

PCI Data Warehouse Training Class

Norman, Oklahoma

June 20 – 23

The PCI Data Warehouse is designed exclusively for energy companies to manage, analyze and report on generation, transmission and demand-side data from PCI-based and non-PCI data sources. Primarily a reporting and interfacing database, the PCI Data Warehouse helps speed up reports and integration. PCI uses an optional Data Mart Builder to easily create new data marts as well as ETLs, which can be used to create data sub-sets for data security enhancement and response time improvements. In addition to this, PCI provides optional Data Export Utility that allows users to export data from Data Warehouse directly to Microsoft Excel reports.

Audience:

This class is a must-attend for Report Writers, Business Users who want access to the data, Administrators of PCI GSMS products, Super Users of PCI Data Warehouse, System Integrators who would like to bring data from various systems to PCI Data Warehouse using PCI Data Warehouse Integration Bus

Summary Of Topics To Be Covered:
  • Overview of the PCI Data Warehouse framework
  • Dimensional Data Model of ODS (Operational Data Store)
  • Various dimensional data models supported by Data Mart Builder
  • Configure the system to accept new data points in ODS
  • Various Data Mart Builder configurations including calculated fields
  • Connect to Data Mart using a tool like MS Excel and use it for reporting
  • Use of Data Export Utility to export data from ODS to MS Excel
  • Ability to create new Data Types and Data Export Configurations for Data Export Utility
  • Job Scheduler for ETLs and Data Export Utility reports
  • System Integration Bus for Data Warehouse (Staging Tables, Staging CSV)
Share on LinkedInShare on Google+Email this to someonePrint this pageTweet about this on TwitterShare on Facebook