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 customer

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 transacti

Who in Supplier diversity program - An interesting Aspect

Last week after I posted third part of my Supplier diversity series of - What Why and How, I got an question from my esteemed senior colleague Ashok Pai, Who works in Supply chain industry worldwide for decades and a Client Partner with Bristlecone, asking "When are you writing about WHO aspect of this?" I replied saying I never thought of that angle, as my basic assumption was that supplier onboarding process is part of strategic sourcing and procurement department chain so those are the people who will be implementing it. And then he mentioned to me that "Look at it from supplier onboarding angle, which is a major pain area for US industry". As I started thinking and researching from that angle, I realized that as a part of diversity implementation its easy to say that run the diversity program in industry, capture supplier attendtion, get the diverse suppliers registered and start doing business with them - its hard to implement. Its really hard to get a new su