Building the Data Model Pyramid with PowerDesigner

Join the author of “Data Modeling Made Simple with PowerDesigner” to learn how to develop a chain of data models (Conceptual, Logical, Physical) for a fictional publisher, and link to the outputs from Business Analysis.

This course reinforces and extends the techniques covered in the “Fundamentals” course. It uses a detailed case study to reinforce the Fundamental techniques, as well as introducing additional techniques, such as the ability to link to other kinds of models, and to the results of business analysis. Ideally, the material requires two days to be covered in sufficient depth, though it can be covered in a single day, if the final module (Generating the Physical Data Model) is omitted.

The following diagram illustrates the “Pyramid of Data Models” that the course addresses:


The following diagram illustrates the course flow:

Pyramid course

Delivery Options

A single focused one-day or two-day session   – or –   a series of online sessions


* All students will be knowledgeable about the role, purpose and construction of data models— this course is not intended to teach data modelling skills

* Students will supply their own PowerDesigner licence – a link can be provided for the evaluation version

* Basic knowledge of the use of PowerDesigner, equivalent to the content of the PowerDesigner Fundamentals training course provided by Metadata Matters Limited

Suggested Follow-up

Building and Using the CDM, Take Control of your Database Schemas, Excel Import, PowerDesigner for Advanced Users

Online computer-based training – Using the Excel Import Wizard