As a special introductory offer, PCI is offering registrants to buy one get one free for a limited time.
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.
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)