Skip to main content

Increase revenue by checking and fixing data quality issues

These days everybody talks about cost cutting, increasing revenue, how the depression, recession affecting company margins and how the job losses are imminent and so on and so forth. All this is true and real and no doubt everybody is looking at new avenues to struggle with the numbers. Though there is no magic recipe to alter the scenario overnight, lot of people, lot of companies are failing to see optimization chances within the organization and chance of increasing revenue – data in their own systems. What data – everything – right from suppliers, customers, materials. What to look for – Data Quality.


The surveys done by few companies in the area estimated that the by managing the data quality one can increase revenue by 66%. Now let’s take that as marketing gimmick on the face, but then assume its half of that – still there is a chance of revenue increase of 33% - do you want to believe that? I do.


My experience with large global enterprises in the data area points me to believe in that. There are these multiple locations, multiple plants, and multiple systems having too many suppliers, too many material getting procured – direct or indirect. All this creates big quality issues in the data – same supplier calling by different names, IBM, I B M, I.B.M, …….favorite example of quality industry, not having linkages among suppliers in system. So this issue prevents to get visibility of suppliers – subsidiaries and vendors relationship. If you have that visibility there are greater chances of negotiations with parent suppliers and thereby affecting the bottom line. End of the day this is one supplier but as your data is too scattered its difficult for you to get visibility. E.g. You are happy to have contract with doubletree hotel, another with embassy suites and likewise but if you have linkages in your system correctly maintained, you will know that they are all “Blackstone group” and if you have negotiated contract with Blackstone then probably your saving is much much more.


That’s just one example of supplier data. Same applies to materials. A simple example is matching attribute values for materials. As the data doesn’t contain attribute values at the detailed down the hierarchy level – you cannot compare same or similar materials using your systems. If you have that probably you can use material available in plant A rather than procuring it right away. So data quality saves you there.


Classification –spend or material – both are another data quality related areas – which we will discuss briefly about in next article.


Thanks
Prashant Mendki
pmendki@gmail.com

Comments

Popular posts from this blog

Master Data Management – Product or Process ?

I have 2 SAP systems and I want to fix my material master, Services Master. I want all that data to be clean, standardized, classified, enriched and load it back to my SAP in next 6 months. What do you suggest ? Chris - one of my key client was explaining during a “solution understanding” call. My sales manager Tom, enthusiastically started talking about new version of the MDM platform by ERP company, tools, technologies, product landscape, licenses etc. After 30 minutes of sales pitch, I could see confusion on Chris’s face clearly. He said - but I don’t want to add any new product in my infrastructure for all this. Can you just implement MDM for me without I adding any new software ?   Both are using MDM implementation as a keyword, but in a completely different context. Chris wants to implement MDM as a process while Tom was trying to sell MDM as a new software. Whats the difference ? Lot I will say. MDM as a product – when you sell a   software license to a...

Data Management - Terminologies & Definitions

As a third step in my Data Management article series – lets look at commonly used terminology in the domain. Now these are very standard definitions I am quoting from a standard available glossary. The next step – next article would be to explain the relevance and usage of these terminology in business world. E.g. How to look at data standardization in supplier data context or material data context – when it comes to optimizing your procurement processes. That’s next. In my first article in this data management series –I compared data management with the story of elephant and seven blind men. http://manageyourdata.blogspot.in/2012/09/data-management-elephant-seven-blind-men.html The second post is more about – why its important to speak same language when you are running any data management initiative.   http://manageyourdata.blogspot.in/2012/09/data-management-are-we-all-speaking.html Data analysis : Analysis of data is a process of inspecting, cleaning, transfo...

Journey of procurement transformation begins with..….. Part II

 Original Blog post - https://www.linkedin.com/pulse/journey-procurement-transformation-begins-part-ii-prashant-mendki Procurement transformation journey is complex, cross functional, time consuming and even frustrating at times. The very basic but a strategic step to start this journey is “Spend Analysis”. Again – this has to be done in a right way to get the potential benefits. We talked about that in first part of this article https://www.linkedin.com/pulse/journey-procurement-transformation-begins-part-i-prashant-mendki By definition – Spend Analysis is an analysis of your spend (invoice paid), what items you are spending on (product), who you are paying to (supplier). It looks really simple – no? When I worked with one of the large Media Entertainment company few years back, they had thousands of suppliers, millions of transactions, good amount of Maverick spend. It’s a global business with more than $2Bn in Spend, 12 different global systems. Thousands of trans...