During the course you will learn about the product ‘Powerpack with Python’ and how to apply it to your project. This will allow you to learn how to work with the product in a safe environment, after which you can apply the learned knowledge to your daily work.

Target audience

The course is intended for developers who need to automate a Data Lake with ETL. The course is also suitable for BI architects and BI analyst who, besides specific subjects around administration, want to gain more knowledge about the possibilities of the automation tool.

Required knowledge

No specific knowledge is required for this course. Although knowledge of Data Warehousing, Dimensional modelling, Python and SQL will be of advantage.

Structure

The course contains theoretical, as well as practical elements with examples that can directly be applied.

Course details

  • Overview what can be generated automaticly.
  • Overview architecture.
  • Flexibiliteit bij automation.
  • Concepts ‘Powerpack with Python’.
    • Overview Principles;
    • Components;
    • Powerpack generation templates;
    • Roadmaps implementation;
      • Which sources can be used;
      • How does the Data Lake automation tool work;
      • Logging during the ETL-proces;
      • Errorhandling during the ETL-proces;
  • Overview possibilities automation database DDL- and Python ETL-code.
    • Data Quanlity;
    • Roadmaps implementation;
    • Standaards and Guidelines;
  • Source to BI Data Lake roadmap.
    • Explain automation steps;
      • Details ETL processes;
      • Generation of the ETL;
      • Execute the ETL-process;
  • BI Data Lake to DataMart roadmap.
    • Explain automation steps;
      • Details ETL processes;
      • Generation of the ETL;
      • Execute the ETL-process;