In this part of the world, we’re treated to wonderful TV ads from Carlsberg, with the theme “If Carlsberg did…, it would probably be the best…. in the world”. One of my favourites is “If Carlsberg did Haircuts”.
Carlsberg TV Ad – If Carlsberg did haircuts
This led me to think, what if Carlsberg did Data Governance?
Picture the scene… Your CEO is looking for a new report, and she has tasked you with providing it, by close of business tomorrow! Where do you start?
In steps the “Data Waiter”, who presents you with a complete menu of the data in your organisation, suggests the data required for the new report and then prompts you with friendly questions like:
- How would you like your data sliced?
Would you like it by Geography, or Business line? Perhaps by Product, or by Customer Type?
- What time period would you like your data to cover?
For a light snack, I can recommend a “Point in Time” snapshot? Or perhaps you would like to include the past month? I can recommend the house special, which is a “Trend over time” for the past year.
- How up to date would you like your data to be?
The early-bird menu has some lovely data we captured 2 years ago. For a $10 supplement you can have data from 1 year ago. On the a la carte menu, you can choose from a wide range, from 6 months old to near-real-time.
- How often would you like your data?
Would you prefer a once-off or perhaps a weekly / monthly data extract? We do a lovely daily extract, or perhaps you would like real-time data-streaming?
- What level of trust does your CEO need in the report you’re preparing?
The early-bird menu has a fresh slice of big data. It’s a beautiful visualisation that looks really pretty – your CEO will love it. I’ve been assured that the data was so big that there’s no need to worry about the quality of it. (Editor note: Beware of Big Data Bullshit – Look up “Veracity” which is the critical, but often overlooked, 4th “V” of Big Data).
If your CEO needs a higher level of trust in your report, we have a complete selection of data that we’ve traced from data entry to our own reporting data warehouse, complete with data quality metrics along the data supply chain.
Having selected the data you need, the data waiter scans your retina, confirms you have appropriate access authority, and then delivers the data to your preferred location. You prepare your report and your CEO is so delighted that she promotes you to the senior management team… Happy days! Scene ends.
What services would you like from “The best Data Governance in the world”?
For more about “Trust in data” see my blog post “The growing demand for food and data provenance“.
This article originally appeared on LinkedIn Pulse
It’s that time of year again, when Santa Claus, the original Data Quality Risk Manager, makes his list and checks it twice.
BCBS 239 requires Data Quality Risk to be included in a bank’s overall Risk Framework
For the largest 30 banks in the world (known as G-SIBs), teams of experts are making final preparations ahead of the BCBS 239 compliance D-Day, which is 1st Jan 2016.
Based on the BCBS 239 document, I’ve put together a “Data Quality Risk Check-list”, that the bank’s board and senior management should sign off, after checking twice:
- We have updated our Risk Management Framework to include the identification, assessment and management of data quality risks
- We consider risk data accuracy requirements analogous to accounting materiality
- Our data quality risk controls surrounding risk data are as robust as those we apply to accounting data
- We reconcile our risk data with our sources, including our accounting data sources where appropriate, to ensure that our risk data is accurate
- We’ve established data taxonomies across the banking group, which includes information on the characteristics of the data (metadata), as well as use of single identifiers and/or unified naming conventions for data including legal entities, counterparties, customers and accounts
- We have defined our data consistently across our organisation and we hold the concepts we use and our data definitions in a “dictionary”
- We’ve established roles and responsibilities as they relate to the ownership and quality of risk data and information
- Our business owners ensure that data is correctly entered by the relevant front office unit (at source), kept current and aligned with the data definitions
- We measure and monitor the completeness, accuracy, timeliness and integrity of all material risk data and we have appropriate escalation channels and action plans in place to rectify poor data quality
BCBS 239 is a paradigm shift in Data Quality Risk management thinking.
Note: Major banks outside the top 30 in the world (known as the D-SIBs) have a little more breathing space. They will be required to comply with BCBS 239 within three years of being designated as a D-SIB by their national supervisor. They have the opportunity to learn for the experience of the first wave.
Does your data tick the right boxes?
Would you base important business decisions on data you knew to be incomplete, inappropriate or inaccurate? Of course not. But how confident are you that your business critical data is as complete, appropriate and accurate as you need it be?
I’m passionate about the benefits that applying common sense data quality management brings to the end to end data supply chain.
I help organisations to maximise the business value they derive from their business critical data. I help identify which data generates the most value. I then help them to measure the quality of critical data, and to correct data quality problems that are impacting revenue, costs, customer experience or regulatory compliance.
Data Quality Management presents the same challenges to all businesses in all industries. The challenges include:
What is our most critical data?
Where is the data, where does it come from?
Who owns the data?
What should it contain?
What does it contain?
What should we do if our most critical data does not contain what it should?
I have faced and solved the above challenges and more.
Contact me today to see how I may be of help.
Socrates, the ancient Greek philosopher, tells us that “The beginning of wisdom is the definition of terms”. Perhaps Socrates was the first “Data Steward“, since the first step in data stewardship is also the definition of terms. I’m sure you’ve often seen instances of the confusion caused when the same term is used to describe different things. What does the term “Monthly Sales” mean? Is it the value or the volume of sales? It is impossible to tell. However, it is easy to clarify by adding a simple qualifier:
- Monthly Sales Value
- Monthly Sales Volume
For a light-hearted look at the confusion that “unqualified” terms can bring, watch the British humour sketch below from “The Two Ronnies” – called “Fork Handles”. See if you can keep a straight face!
If you’ve ever organised a “Secret Santa” you’ll know that “data quality” is critical to its smooth running. Santa is the acknowledged world leader in data quality management, given his success managing the names and addresses of billions of children worldwide. He coined the data quality industry motto “Make a list, then check it twice”, which is a Critical Success Factor (CSF) to his “Naughty” and “Nice” segmentation process.
Santa has kindly shared some of his secret tips… In risk management terms, he tells us that we need to “manage the risk that the critical data required for the success of the (Secret Santa) programme is not fit for purpose”
He suggests that we apply 4 of his 6 favourite data quality dimensions:
- Completeness: Ensure you put a name on your gift
- Accuracy: Ensure you put the correct (accurate)name on your gift (Check against the slip of paper you pulled out)
- Uniqueness: Ensure you put First Name and Surname on your gift (just in case there are two Johns, or Marvins or Oprahs)
- Timeliness: Ensure you deliver your gift, with its associated critical data, to the secret santa organiser in good time
Update December 2018 – in response to GDPR
Much has changed in the four years since Santa shared the tips above. Santa has asked me personally to update this post to let people know that he welcomes the strengthening of data protection laws that came into effect with the GDPR on May 25th this year.
Santa Claus has always respected the privacy and security of the personal data of the billions of children he has delivered gifts to throughout history. He never has, and never will, share personal data with anyone other than the elves, cats, dogs, birds and other animals that keep him informed throughout the year on how boys and girls are behaving.
He personally maintains the naughty and nice list, without the use of Artificial Intelligence, Machine Learning or any other algorithmic processing.
Data privacy professionals across the world have been asking Santa Claus how he manages his data privacy processing. Santa’s response: “It’s all part of the magic of Christmas”