Building a procurement analytics tool (2 days)

This two-day, company-specific workshop is the first in a series of two workshops. In this workshop, you will build an analytics tool from your organization's own purchasing data and learn basic usage. In the second workshop, you will learn how to refine and utilize the tool.

What will you know after the workshop?

• After the workshop, you will understand the basics and processes of purchasing analytics
• You have built an analytics tool from your organization's own purchasing data
• You know the basics of utilizing purchasing analytics and know how to apply it to your own organization

Who is the workshop intended for?

• The training is intended for everyone who works in purchasing and procurement development, management or managerial positions, as well as for all experts responsible for procurement development.

What parts are there in the workshop?

• As a preliminary task for the workshop, participants
  • acquire their own organization's purchasing data to be used in the workshop according to the instructions
  • adopt the Spendata tool as a trial or regular version
• Introduction to purchasing analytics and the tool used provides the skills to understand purchasing analytics, its concepts and the tool used.
• The Uploading Purchase Data section walks you through uploading your organization's own data to the tool so that participants can reproduce it independently in the future.
• In the Understanding and Organizing Information section, purchasing information is refined and information viewing, analysis, and utilization of different perspectives are practiced.
• The section on applying analytics in your own organization identifies the uses and target groups of purchasing analytics and describes ideas for further development of the analytics tool.

The workshop can utilize the online learning environment and data bank.

Why is it worth attending the workshop?

• You will be prepared to understand purchasing analytics, its utilization and the benefits achieved
• You will build an analytics tool for your own organization and learn how to use it
• You can analyze purchasing data, agilely test different action options, and identify areas for improvement in procurement.
• You identify the use cases and stakeholders of purchasing analytics in your own organization
• You can continue developing your purchasing analytics by participating in a follow-up workshop, where we will delve deeper into utilizing the analytics tool built in this workshop.

BEFORE TRAINING

• Agree on the workshop objectives and structure
• Pre-assignment instructions
• Prerequisite: Obtaining purchasing data from your own organization to be used in the workshop

TRAINING

Opening of training

• objectives, program, introduction, rules of the game

Part 1: Introduction to purchasing analytics and the tool to use

Purchasing analytics basics and processes

Features and uses of Spendata

• features and functions
• processes and principles
• key concepts
• transparency and security

PART 2: Uploading Purchase Information

Review of the preliminary assignment

Understanding and editing the structure of purchase data

• Understanding the content of purchase data: fields, their meanings, and possible hierarchies
• Checking the presentation formats of key fields and making the necessary formatting
• Converting purchase data into a format that can be loaded into the tool

Uploading purchase data to the tool

• Review and practice the loading process
• Loading data and verifying the accuracy of the result

Part 3: Utilization

Information organization

• Merging the same suppliers (name spelled differently)
• Adding dimensions and views

Understanding information: using the tool

• data analysis
• viewing and filtering using different criteria
• utilizing ready-made views
• formatting data and transferring results to Excel

Part 4: Application

Utilizing analytics in your own organization

• uses and stakeholders
• tool development ideas

Ending education

• achieving set goals - discussion
• the following measures

AFTER TRAINING

• training feedback survey
• further development activities

• A workshop tailored to the team and client. The objectives, content, structure and duration are agreed upon before the workshop. The workshop may include preliminary, intermediate and final tasks as agreed, as well as training material.
• Participants will adopt a trial or regular version of the Spendata analytics tool before the workshop.
• Duration 2 days, can be implemented in 1-4 parts as a local, multi-modal or remote workshop.
• Number of participants: group size maximum 5
• The workshop will be invoiced in one installment approximately two weeks before it begins and it is possible to cancel it free of charge 14 days before the start of the training.
• The price includes 24% VAT. The customer is responsible for travel, accommodation and other practical arrangements and their costs. Depending on the location of the training venue, travel costs may be charged.
• We will contact you within 24 hours of your order.