“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?

 

Advertisements

“#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?

 

Whatever happened to Information Management at this bank? #DataQualityFail

Yesterday I set up SMS alerts for my business bank account for the first time. When I registered for the service, it showed me the last four digits (9901) of the number they proposed to use for messages advising me of activity on my account. That worried me, as I stopped using that number several years ago when I changed providers, and the bank are well aware of my current number. In fact, they already send me text messages to confirm certain activities via internet banking.

With trepidation, I registered for the service, and there was an option to update my contact details, so I took it. Lo and behold, the ‘9901’ number is not in my contact details; the mobile number is correct.

Here’s my mobile phone number in my “Personal Details” (there is nowhere to record a second mobile number):

my banking mobileSo, I decided to carry on and sign up for a couple of ‘text alerts’. Here are the choices I’m given when setting up a ‘text alert’ – note the first phone number:

two numbers for text alerts

Interesting that, I can choose from a list of mobile numbers, though I’m only allowed to record one mobile phone number.

I was careful to select the correct number, and expected the service to work OK. My first email alert arrived at 02:06 this morning, but no matching SMS arrived. This may have been due to the patchy mobile service I’ve had in the last few days, but I decided to ring the bank anyway. I called at 10:20 and explained the issue to the customer service representative, and she promised to get back to me today.

I asked her for the contact details for their data protection team, as I wanted to raise this concern with them, in case other customers’ alerts were going to the wrong people, and also because this is very obviously a data management problem. I was told that the bank does not allow customers to contact data protection directly, that has to be done via customer service or by making a complaint.

Well, the missing text alert arrived at 11:57 this morning, nearly 10 hours after the email. The time is now 22:20, and I’m still waiting for my call back from the bank. I’m not surprised they haven’t sorted it yet, it’ll take a while to sort out.

I used to work for this bank in an information management capacity, leaving ten years ago when the new owners guillotined the Information Management department. I’ve heard a few things from the inside since then about how effective their information management is these days; this definitely would not have happened in ‘the old days’, there was a business department in place to make sure of that. I wonder what happened to it.

P.S. Why is there a drop-down list of phone numbers? Here’s a suggestion from a friend of mine, which I’ve paraphrased – “during project testing a developer found >1 mobile number, so they decide to add a drop-down list. Not scenario-checked. Unit tested but no end to end test.”  Could be true.

But that’s just experience bitching.

Trust and Traceability – Building an Information Architecture with SAP #PowerDesigner

Here’s a date for your diary – on February 5th, Sandhill Consultants will present a webinar aimed at those of you who want to know about building an Information Architecture in PowerDesigner.

The webinar will introduce three key approaches to moving beyond data modeling with SAP PowerDesigner that will allow you to trace your data lineage and analyze impacts on other systems, such as Data Warehousing, Transactional, ERP, COTS, among others.

• Reconciling disparate data systems
• Reduce data complexity via data modeling
• Reuse data assets

Follow this link to register – https://attendee.gotowebinar.com/register/6550129779954078721

Sandhill Consultants are PD resellers in North America, and I’m happy to say that I help them to provide PD services and training.