DZone
Thanks for visiting DZone today,
Edit Profile
  • Manage Email Subscriptions
  • How to Post to DZone
  • Article Submission Guidelines
Sign Out View Profile
  • Post an Article
  • Manage My Drafts
Over 2 million developers have joined DZone.
Log In / Join
Refcards Trend Reports Events Over 2 million developers have joined DZone. Join Today! Thanks for visiting DZone today,
Edit Profile Manage Email Subscriptions Moderation Admin Console How to Post to DZone Article Submission Guidelines
View Profile
Sign Out
Refcards
Trend Reports
Events
Zones
Culture and Methodologies Agile Career Development Methodologies Team Management
Data Engineering AI/ML Big Data Data Databases IoT
Software Design and Architecture Cloud Architecture Containers Integration Microservices Performance Security
Coding Frameworks Java JavaScript Languages Tools
Testing, Deployment, and Maintenance Deployment DevOps and CI/CD Maintenance Monitoring and Observability Testing, Tools, and Frameworks
Culture and Methodologies
Agile Career Development Methodologies Team Management
Data Engineering
AI/ML Big Data Data Databases IoT
Software Design and Architecture
Cloud Architecture Containers Integration Microservices Performance Security
Coding
Frameworks Java JavaScript Languages Tools
Testing, Deployment, and Maintenance
Deployment DevOps and CI/CD Maintenance Monitoring and Observability Testing, Tools, and Frameworks
  1. DZone
  2. Data Engineering
  3. Data
  4. Why Businesses Should Spend More on BI and Analytics

Why Businesses Should Spend More on BI and Analytics

Ravi Kalakota user avatar by
Ravi Kalakota
·
Jul. 12, 12 · Interview
Like (0)
Save
Tweet
Share
6.67K Views

Join the DZone community and get the full member experience.

Join For Free

procurement organizations tend to swim in data. one of the most important strategies for any best-in class procurement organization is spend analytics. in conjunction with sourcing, category, contract management and purchasing, spend analytics provides a window into spend behavior to drive cost reduction and cost avoidance efforts.

as a result, we are seeing a lot of interest around spend bi and analytics projects. chief procurement officers and other sourcing/procurement leaders of global, large and even mid-market firms are increasingly focusing on spend data analytics as part of a new wave of spend rationalization projects.

the spend numbers are staggering.  at a large multi-national industrial firm with $55 bln in revenue, the indirect spend is $9 bln.  the opportunities for savings are tremendous.

spend bi and analytics can provide the visibility and insight needed to improve procurement performance. spend management provides many cost reduction opportunities thru visibility into direct and indirect procurement, it hardware, software, and services, and logistics, transportation and inventory costs.

however, getting a 360 degree view of spend data is extremely challenging in most organizations.  a large part of this is due to the number of fragmented solutions that contain spend information. in one firm we are helping, there are 32 erp instances that capture po transactions. then there are cash disbursements systems, shared services systems, manual systems, and so on.  you get the complexity.

another part is due to poorly implemented solutions where data as it flows from transactions systems to bi dashboards via an extract, cleanse, classify model is getting corrupted. sometimes the classification is wrong resulting in incorrect aggregates. as a result there is limited trust in the numbers presented in the dashboard.

poor quality of spend data coming from procurement and erp systems is a big problem.

so what is the solution? either fix the raw data -> insights chain which is hard to do in a large firm after the solution is deployed, or leverage sophisticated data analysts to do forensics and recreate the spend cube for targeted insights.

given the time pressure to generate results, some companies tend to go with the sophisticated data analysts who can interpret the nuances in the data.   data quality is absolutely critical for good fact driven decisions. best in class organizations are increasingly noted for their ability to analyze spend and identify opportunities for improvement.

optimizing spend under management is a key metric in world class procurement and sourcing organizations. specific questions good spend analytics execution can help address include:

direct and indirect material analysis

  • what materials has the procurement organization purchased last year? in what volumes and for what prices? how has that changed over time?
  • how many skus do we carry on our material list? has this increased over time? can we consolidate or substitute items to maximize buying power?
  • what % of payments are duplicates?
  • how is the total landed cost of a material distributed across unit cost, and other carry costs? has this changed?
  • what types of requests (mro, manufacturing job orders, mrp) by volume have been processed? do patterns reveal opportunities for streamlining?
  • are different demand channels ordering similar commodities? can we synchronize needs across channels or substitute materials for consolidated buying?

vendor and supplier analysis

  • what does our supplier landscape look like?  how many vendors have we purchased from this year? on average how much is spent per vendor in a specific period?
  • how do vendors rank by volume and revenue spent? how has that changed over time?
  • how many vendors do we have for a specific material or material group? what percentage of the volume is sourced from a single supplier?
  • how do prices compare across vendors for a specific material? has this changed?
  • how do vendors compare across payment and delivery terms, quality of materials received, on time delivery, order and invoice accuracy?

process analysis

  • how many transactions are performed for various stages in the procurement cycle?
  • how long does it take to move from one stage to the next in the procurement cycle?
  • how do processing times relate to specific materials, vendors and buyers?
  • what percentages of requisitions are declined? what are the reasons for rejection?
  • how does this compare across commodities, and demand channels?
  • where are there opportunities for reducing non value added activities?

transaction analysis

  • how many requisitions, contracts, and purchase orders are processed across the organization by buyer? what is the average value of each transaction?
  • how is each buyer’s activity distributed across vendors, materials and demand channels? should buyer responsibilities be redistributed?
  • is there an opportunity to consolidate transactions with a vendor through one buyer?
  • are there opportunities for consolidating the purchase of certain materials with certain buyers?
the linkage between strategic sourcing and tactical e-procurement is illustrated below.  bi to support procurement is going to be a growing field as companies look for new ways to adjust costs in a low-growth environment.

Analytics

Published at DZone with permission of Ravi Kalakota, DZone MVB. See the original article here.

Opinions expressed by DZone contributors are their own.

Popular on DZone

  • RabbitMQ vs. Memphis.dev
  • What Is Testing as a Service?
  • Implementing Adaptive Concurrency Limits
  • How to Deploy Machine Learning Models on AWS Lambda Using Docker

Comments

Partner Resources

X

ABOUT US

  • About DZone
  • Send feedback
  • Careers
  • Sitemap

ADVERTISE

  • Advertise with DZone

CONTRIBUTE ON DZONE

  • Article Submission Guidelines
  • Become a Contributor
  • Visit the Writers' Zone

LEGAL

  • Terms of Service
  • Privacy Policy

CONTACT US

  • 600 Park Offices Drive
  • Suite 300
  • Durham, NC 27709
  • support@dzone.com
  • +1 (919) 678-0300

Let's be friends: