Data models are not ‘just documentation’ @DV_Modeling @RoelantVos #PowerDesigner

My friend Dirk Lerner is speaking at the IRM UK data management conference this week (it has a longer title, but I’ll avoid using it today) on topics that are close to my heart, so I thought I’d share some related connections. Dirk has three sessions this week –

  • Data, Data, Metadata – DNA of Data Architecture?
  • From Conceptual to Physical Data Vault Data Model
  • Send Bi-Temporal Data from Ground to Vault to the Stars

Why am I so interested in these sessions (especially the first two)? The answer is simple – he’s discussing the combination of metadata and automation to improve the efficiency and efficacy of data modelling. This is a message I’ve been banging on about for years to anyone who will listen – data models are not ‘just documentation’, they’re an essential part of application development.

There are tools out there to help you with automating the development of Data Warehouses, including Data Vaults. Some are commercial products which you can buy with services, others are part of a consultancy package (so you buy the service, and they use the tools to provide the service). All of the consultancy examples I know of have extended a data modelling tool to provide the automation (they all use SAP PowerDesigner).

If you want to build your own automation, there is an initiative (led by Roelant Vos) to build a generic metadata interface for you to use when integrating tools – find out more at http://roelantvos.com/blog/a-collaboration-for-a-common-metadata-model/, and you can contribute to this effort at https://github.com/RoelantVos/Data_Warehouse_Automation_Metadata_Interface.

#JSON, Data Modelling and electric cars – what a mix #DMZone

It was a very early session, so I really appreciate the turnout for this niche subject, in the biggest room I’ve ever presented in.

The ‘big room’ at the Mercedes Benz Museum in Stuttgart

The venue was the Mercedes Benz Museum in Stuggart, Germany, which is an amazing place to be. Strolling around during the breaks was a different experience this year; I saw my next car there (I wish!)

Back to the serious stuff – my slides are available on Slideshare now – https://www.slideshare.net/metadatajunkie/data-modelling-zone-2019-data-modelling-and-json.

I’m really looking forward to Data Modelling Zone in Stuttgart this week #dmzone

Data Modelling Zone is unique among conferences in the topics it focuses on, which is great for me!

I’m really looking forward to meeting my colleagues from across the channel and elsewhere in the world from Tuesday evening to Friday in Stuttgart. It’s the one event of the year where I can guarantee to meet a lot of PowerDesigner users 😉.

I’m even looking forward to my 07:30 speaking sesson on Friday 😊

Looking forward to visiting Germany twice this month for #PowerDesigner training and for #DataModelingZone

It’s a year since I last went to Germany – tomorrow I’m going to Cologne to provide training for SAP PowerDesigner users, the following week I’ll be at Data Modelling Zone in Stuttgart (at the Mercedes-Benz museum).

If you’re in either place at the same time as me, keep your eyes open.

Thanks for completing my survey – the first sample #PowerDesigner training material is now available

Thank you to everyone who filled out my PowerDesigner training survey, the answers were reassuring and revealing. If you haven’t completed the survey yet, please follow this link – https://www.surveymonkey.co.uk/r/MRRYXYW.

There are two free training courses available at www.PowerDesigner.Training now – you can log in as a guest to see them. One of them is a cut-down version of a complete course on using the PowerDesigner Excel Import Wizard. Please contact concierge@powerdesigner.training if you’re interested in the complete course.