Sweden path Tjänster path Utbildning: Affecto Academy path Kurskalender path Business Performance Warehouse path BPW - Business Performance Warehouse

BPW - Business Performance Warehouse

Tillbaka
Varaktighet 3 dagar

The course offers a thorough review of the Business Performance Warehouse (BPW) functions and design methods. We mix theory with practical training. The BPW course is designed for people seeking the basics skills as well as more BPW experienced developers looking for more in-depth knowledge. We offer the opportunity for students to contact us in advance if they wish to bring up any particular area during the course. 

Course Venue:
Affecto Sweden, Wallingatan 2, Stockholm
Innehåll

After successfully completing this course, students should be able to:

  • BPW installation and configuration
  • BPW overview
  • BPW in practice
  • Create dimensions and fact tables
  • Automomize the ETL process
  • Export and documentation models
  • ETL properties
  • Exception handling
  • Change an existing solution
  • Common mistakes and problems
  • Index and maintenance
  • Data from other systems other than M3, metadata import, operational source systems and Linked servers.
  • Detailed review of process options
  • More unusual object types; Decoders, Mergers, Normalizers och Denormalizers,what are they and when do we use them?
  • Data warehouse design; other possible schemes in BPW (other than ie  “snowflake” and partitioned tables)
Datum
Tillbaka