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.

Looking for recommendations for an online #training #platform #Dataversity #Udemy

I want to convert my existing software training courses into online training, which is straightforward enough (though it will take some time, as I’m picky about the quality of what I deliver). There are some obvious platforms I could use:

  • Dataversity – well-known to many of us in Information Management for their conferences and webinars, and they host online training as well
  • Udemy – hosts a multitude of training courses on a multitude of topics. They have a lot of very useful guidance for building courses

If anyone can recommend another platform, I’d be grateful. Here’s what I’d like it to do for me:

  • handle payments for me
  • support a subscription model
    • allowing someone access to all my training (or specified courses) for a period, perhaps a month, a year, or longer
  • allow customers to download resources, such as the model output from a session
  • quizzes
  • certification paths – e.g. do courses 1 to 4 and get a certificate
  • bundling multiple courses for a discount
  • support a mixture of technologies
    • PowerPoint
    • Videos

There’s probably some more, but that’ll do for now.