Metadata Matters Limited provides unrivalled expertise in SAP PowerDesigner, from evaluating modelling tools through to training users of the tool. We enable organisations to move “from selection to effective”, by providing a blend of consultancy, training, and pre-built PowerDesigner resources.
Metadata Matters Limited provide several training courses for PowerDesigner users, all presented by George McGeachie, author of “Data Modeling Made Simple with PowerDesigner”.
Expand a section for information about a course and a link to the detailed course description
PowerDesigner Fundamentals for Data Architects
The course will teach you how to set up and use the PowerDesigner environment, how to create and manage objects and sub-objects, how to use the editing tools effectively, how to prettify and organise diagrams, and how to generate and manage models.
The “Fundamentals” course is designed to provide the essential knowledge required for data architects, covering a lot of material in a short time. In the time available, it can only introduce the user to PowerDesigner – there is insufficient time to cover topics in depth, or to carry out a detailed case study; the “Building the Data Model Pyramid” course uses a detailed case study to reinforce the Fundamental techniques, as well as introducing several more techniques.
The knowledge supplied by this course is a prerequisite for the more advanced training courses offered by Metadata Matters Limited.
Building the Data Model Pyramid with PowerDesigner
Building and Using the PowerDesigner Conceptual Data Model
You know how to work with Logical and Physical Data Models in SAP PowerDesigner, and now you need to work with Conceptual Data Models as well. This course will teach you how best to utilise the features that make the Conceptual Data Model stand out from the others – additional notations, Data Items, and additional model generation options.
Excel Import Workshop
Take Control of your Database Schemas with PowerDesigner
This course will enable you to:
- Create and manage Physical Data Models
- Generate, merge and compare models
- Reverse-engineer existing databases to create data models
- Synchronise physical data models with databases
This course builds on and reinforces the lesson learned in the “Fundamentals” training, focusing on the tasks carried out by those responsible for editing and managing Physical Data Models, including the different normalisation techniques available.
Model Management with the PowerDesigner Repository
PowerDesigner for Advanced Users
If you’ve been using SAP PowerDesigner for a while
– and – you’re ready to know more about the tool
– or – you’re responsible for designing your modelling methodology
then this course is for you!
This course will teach you how to utilise and benefit from the features that make SAP PowerDesigner stand out from the pack, as well as helping you avoid unnecessary complexity.
For example, using shortcuts and replications to share objects can be very beneficial but, like all complex mechanisms, you must design and govern your approach carefully.