2-Day Seminar

Data Modelling Made Simple with PowerDesigner
You know what you need to do - learn how to do it with PowerDesigner

Click here for an in-house quote request or for further information regarding in-house training.

There is an option to add a third day, either to increase the time available for learning, or to cover a selection of the following additional topics:

  • Replicas and shortcuts
  • Linking with Business Analysis
  • Sharing Resources
  • Creating Model Extensions
  • The PowerDesigner Glossary and reference models
  • PowerDesigner in Data Governance
  • Linking with Business Analysis
  • Sharing PowerDesigner Resources
  • User Profiles
  • Managing Naming Standards
  • Impact and lineage analysis and Impact Analysis Models
  • Glossary approaches
  • Other types of PowerDesigner model
  • Running macros
  • Dimensional data models

Overview
Do you already know the basics of data modelling and need to know how to do it in PowerDesigner? Perhaps you're an experienced data modeller working with PowerDesigner for the first time? Maybe you're using an old version of PowerDesigner and you need your skills brought up to date?

This course commences with a discussion of the different types of data model supported by PowerDesigner, followed by a detailed explanation of the PowerDesigner working environment. If you're familiar with other data modelling tools, you will realise that PowerDesigner operates differently - it has its quirks, and you'll see how to make use of them. You'll also know how to take advantage of the features that you may not have seen in other tools, such as the Dependency Matrix.

Once you've got to grips with the environment and facilities, you'll work through a detailed case study, creating a chain of data models from Conceptual to Logical to Physical, applying normalisation and de-normalisation techniques where appropriate. In the case study. you'll see how PowerDesigner Projects enable you to visualise and manage your chain of models.

In addition, you'll see features added in version 16 - the Glossary and Reference models, and the improved Web Portal.

Client will Need to Provide:

  • Access to a printer
  • A workstation for each attendee or pair of attendees, with PowerDesigner 16 installed on each workstation
  • Whiteboard for ‘bulletin board’
  • Local modelling and naming standards (if applicable)

Learning Objectives

    This course will enable you to:

  • Use the right PowerDesigner data model for each task, by referencing the data model pyramid
  • Work effectively within the PowerDesigner environment
  • Create and Manage Conceptual, Logical and Physical Data Models
  • Generate, merge and compare models
  • Reverse-engineer an existing database to create data models
  • Synchronise physical data models with databases
  • Communicate your models using Excel exports, reports and the Web Portal
  • Use model extensions to enhance the information captured by PowerDesigner
  • Describe the importance of quality object names

Seminar Outline

  • The  Data Model Pyramid and PowerDesigner model types
  • Working in the PowerDesigner environment
    • A model is not just a load of symbols
    • Understanding Workspaces and Projects
    • PowerDesigner windows, views, browser, and toolbox
    • Creating Models
    • Working with diagrams and packages
    • Object Names and Codes
    • Working with model objects
    • Options and Preferences
    • Replicas and shortcuts
    • Object Lists and List Reports
    • Dependency Matrices
    • Excel Imports
    • Attaching model extensions
    • Impact and lineage analysis
    • Checking Models
  • Using the PowerDesigner Glossary and reference models
  • Working with Business Rules and Requirements
  • Creating a CDM
  • Model Generation
  • Creating a LDM
    • Normalisation techniques
    • Inheritances
  • Comparing and Merging models
  • Creating a PDM
    • De-normalisation techniques
    • Triggers, Views and Procedures
  • Round-trip engineering
    • Reverse-engineering a database to create a PDM
    • Synchronising a database and a physical data model
  • Model management
  • PowerDesigner Web Portal

Pre-requisites
This course has as prerequisite the Data Modelling Fundamentals course, or at a minimum an understanding of data modelling concepts.

Audience
Data Modellers, Data Architects and Database Developers, and anyone who needs to produce  data models using PowerDesigner 16.

Speaker Biography

George McGeachie

George McGeachie has worked in the field of modelling and metadata since the 1980s, in the UK, Saudi Arabia and Germany. Over the years, he has become proficient with several well-known (and not so well-known) data modelling tools, and generally becomes the local power user of each tool. George is the co-author of "Data Modelling Made simple with PowerDesigner".

In-House Training
If you require a quote for running this course in-house, please contact us with the following details:

  • Subject matter and/or speaker required
  • Estimated number of delegates
  • Location (town, country)
  • Number of days required (if different from the public course)
  • Preferred date

Please contact:
Jeanette Hall
E-mail: jeanette.hall@irmuk.co.uk
Telephone: +44 (0)20 8866 8366
Fax: +44 (0)1923 828 770

Speaker: George McGeachie
George McGeachie

George McGeachie has worked in the field of modelling and metadata since the 1980s, in the UK, Saudi Arabia and Germany. Over the years, he has become proficient with several well-known (and not so well-known) data modelling tools, and generally becomes the local power user of each tool. George is the co-author of "Data Modelling Made simple with PowerDesigner".

Related Book
Click on image below for further information