Skip to main content

Why should I Profile my Data?

You have got an enterprise system for your organization since long time. Do you know how much data quality issues you may have in your data? What does that mean ?
1. You may have different date formats - like mmddyyyy, ddmmyyyy, dd-mon-yyyy and so on.
2.You may have unit of measurement (UOM) inconsistencies issues. - Somebody putting the data in inches, one in cms and one in feet.
3. Have you considered the currency conversion and exchange rate issues.
4. And how about the material code ? One coding it as ABC123, other as ABC-123 and another as ABC 123. All are same, but when you search you dont find the material ABC123 and you order another 1000 quanitities, when same material named as ABC 123 is there in your warehouse.
5. Do you know the vendor ABC, AB-C, AB Corp and AB Ltd are same under one group?

All these issues are eating in your money. Directly or indirectly. Just under your nose, because they are the issues, you are going through everyday, but just ignoring it due to invisibility problem.

Thats why the "Data Profiling" is most important step for you. It will tell you how much problem you are into and make a statement about how much efforts you may need to put for to go ahead.

Watch out for next step - How to execute Data profiling and save cost too.
Labels:

Comments

Post a Comment

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
4 comments
Read more

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
Post a Comment
Read more

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
1 comment
Read more