What makes #PowerDesigner different? Find out at my #DMZone session in Dusseldorf next week

Next week at Data Modelling Zone in Dusseldorf, I’ll be demonstrating my favourite features of SAP PowerDesigner. These range from simple usability to advanced tinkering, none of them are rocket science. Most of them are not available in other competing tools.

Challenge me with a feature of your favourite data modelling tool that you just can’t live without, and I’ll show you how to handle it in PowerDesigner.

Here’s the list of features I intend to demonstrate:

  • What if you draw that relationship in the wrong direction, or between the wrong entities? You don’t need to delete it, just edit it
  • Tidy up that diagram – have more than one symbol on the diagram for that busy entity
  • When you connect two objects together, the link is visible from both ends (even if they’re from two different models, or different types of models)
  • Multiple editing windows – individual objects and lists of objects, from multiple models
  • Copy and paste from a list of Objects straight into Excel, complete with headers
  • Import anything from Excel without writing any code
  • Link anything to anything if you have a need to, using Traceability Links
  • Add new properties, and new types of object, and links between them
    – how about adding Data Stewards, and linking them to the entities they’re responsible for?
  • Dependency matrices – show (and edit) links between objects
  • Create a model within a model – useful for Subject Area models
  • How about generating that LDM as JSON structures for your fancy governance tool to ingest?
  • Tailor how PowerDesigner generates DDL, and even invent your own DBMS and funky new DDL syntax
  • When you generate one model from another (e.g. generating a PDM from a LDM) you can change what happens using model transformations – such as the model transformation that makes sure your PDM tables all have the correct audit columns
  • Who needs Visio? Use a ‘Free Model’ to invent your own type of model

 

Advertisements

“Making It Real” – Establishing the Interdependence of Data Governance and Your Data Models #mdmdg

“Data governance is at the heart of all data management activities and is heavily reliant on effective data modelling. This is a two-way interdependency. Neither can work effectively without the other.”

In May 2018, Chris Bradley (@inforacer) and I will be running a full-day seminar on this topic at “Data Governance Conference Europe” in London. If you want to find out more, click on this link – https://irmuk.co.uk/events/data-governance-conference-europe – and we’ll see you there.

In the workshop, we describe real-world data governance processes, based upon years of experience with major clients, and the accompanying data modelling practices and additional information required to manage change effectively, including data lineage. Then it will be time for you to put those processes to the test, pushing proposed changes through the data governance pipeline, in which you are a key participant. Will our apparently perfect processes and data modelling practices hold up?

 

“#PowerDesigner Fundamentals for Data Architects” at Data Modelling Zone EU 2018 #DMZone

Are you thinking of attending Data Modelling Zone in Düsseldorf in September 2018?

  • Are you an experienced data architect, new to SAP PowerDesigner?
  • Have you used SAP PowerDesigner in the past, and need bringing up to date?
  • Are you currently using SAP PowerDesigner, but never had any training?
  • Are you evaluating SAP PowerDesigner?

– then –

This session is for you!

Join the author of Data Modelling Made Simple with PowerDesigner, and learn the Fundamental techniques you need to get the best out of SAP PowerDesigner.

The program hasn’t been announced yet, so watch the conference web site for announcements.

 

 

“Making It Real” – Establishing the Interdependence of Data Governance and Your Data Models #edw2018

“Data governance is at the heart of all data management activities and is heavily reliant on effective data modelling. This is a two-way interdependency. Neither can work effectively without the other.”

In April 2018, Chris Bradley (@inforacer) and I will be running a half-day seminar on this topic at Enterprise Data World in San Diego. If you want to find out more, click on this link – https://edw2018.dataversity.net/sessionPop.cfm?confid=121&proposalid=9515 – and we’ll see you there.

In the workshop, we describe real-world data governance processes, based upon years of experience with major clients, and the accompanying data modelling practices and additional information required to manage change effectively, including data lineage. Then it will be time for you to put those processes to the test, pushing proposed changes through the data governance pipeline, in which you are a key participant. Will our apparently perfect processes and data modelling practices hold up?

 

#PowerDesigner users- save $$, pre-register for ISUG-TECH 2015, and tell them what you want to see presented

I attended ISUG-TECH in Atlanta for the first time last year, and I think it was the first time they’d had a dedicated track for PowerDesigner. All of the PowerDesigner sessions were well attended, and I know there were some conference attendees (like me) who were only really interested in PowerDesigner. Most of the PowerDesigner speakers (like me, again) and some of the attendees weren’t from the USA, so there was a great international atmosphere.

It would be fantastic if we could expand that experience to more sessions and more people – where else will you find a whole week of PowerDesigner sessions, where else can you meet people facing the same issues as you do, whatever the type of modelling you do in PowerDesigner?

For 2015, they’ve decided to allow people to pre-register for the conference, which gives you $200 discount if you decide to actually attend the conference; you’ll also be able to have your say about what you’d like to see. Here’s what Mike Harrold, Executive Director of ISUG-TECH says about it:

“Pre-registration gives us an opportunity to solicit input from the community about which topics they want to see covered during the technical break-out sessions at the conference, which is important to both ISUG-TECH and the community to ensure the best possible content at the conference. There is absolutely no cost to pre-register and in return we’re extending a $200 discount to all those that do pre-register which can be applied to their actual registration fee later this year.”

For more information and to pre-register, visit www.isug.com/techwave2015/preregister.