Technical Professional 

Course and Training

AGENDA

Xpert BI Technical Professional course in Stavanger on Tuesday 19th of November at 08:00-17:00

Price: 12 500,-

2-for-1 with sign up by Nov. 18th

Price includes:

  • Lunch
  • 3-month trial license
  • Online certification

 

Course content:

Xpert BI Extraction including: source metadata handling, destination metadata handling and data extraction with surrogate primary and foreign keys. Incremental loads, Tracking and Changing attributes, using functions, advanced metadata handling. 

Xpert BI Collection basics from Excel, XML and Web Services 

Xpert BI Transformation including: introduction to data transformation methodology, creating tables using Xpert BI configuration, understanding dependencies.  Incremental data loads in Transformation, using stored procedures, solution documentation, publish to Rest API, Power Pivot, SSAS Tabular, Export groups (ADL), Test Automation and much more. 

Administration, logging and metadata reports. 

Demo of new modules; Solution catalog, Online Input 

At convenience:Online Xpert BI Certification Test 

Pre-requisites:            

Knowledge of BI and Data Warehouse development

Preferable with knowledge of the SQL server BI stack including SSMS and SSAS

Tools: PC/laptop with SQL server 2016 (or later) installed or access to a server with this installation.

Aimed for: BI and Data Warehouse developers/professionals/architects/technicians

Share This