<img src="https://secure.leadforensics.com/133892.png" alt="" style="display:none;">

There is an increasing responsibility on food manufacturers to gain complete traceability of all the supplies, ingredients, materials and finished products throughout the supply chain.

By having full visibility of the entire lifecycle of all products and product components, from production to the point of consumption, means that in the event of a quality concern the relevant actions can be taken quickly and efficiently to either contain or recall ‘at-risk’ products.

Improved traceability can be readily achieved through the implementation of food focused solutions such as ERP, but these can require a large investment and time to implement, and certainly cannot provide a short-term solution.

Reliance on purely recording details in a spreadsheet or on paper, means traceability becomes a rather time-consuming and error ridden process. This can lead to a “recall it all” approach because its faster and safer, but incurs a higher direct cost.

However, there is thankfully an approach that can improve traceability using tools such as Power BI which can collate and display information from a variety of data sources, and doesn’t require substantial time and money to implement, providing a very realistic short-term solution to the issue of Food traceability which can make a significant difference.

What is Power BI?

Power BI is a tool from Microsoft which is rich in features and designed to create intelligent visualisations based on business data, supporting you in your decision-making processes. Power BI Pro provides the ability to create graphical data visualisations, in both independent or collaborative environments, which can then be shared between employees.

How can Power BI help you?

PowerBI

Power BI can provide the ability to manage data storage from a variety of sources and enable cleansing, joining and merging of sources such as spreadsheets. In essence, it doesn’t matter where the data comes from providing it exists, and if it exists, it can be extracted using items such as standard connectors where applicable.

This then provides rapid information breakdown and enables easy access to understandable data which means your Power BI users can quickly and easily make increasingly informed decisions in relation to business needs. So, if you retain data relating to ingredients, batch IDs, locations, delivery addresses etc, you should be able to easily analyse and filter information accordingly to determine for example the extent of use and coverage associated with a particular batch of ingredients.

These analysis reports can be created and customised to suit your business’s needs, via natural language queries rather than complex query coding reducing any learning time for users.

They can also be run on a variety of devices which means you’re not reliant on being on your desktop or in the office to access relevant information and make decisions.

As a result, it provides a solution to analyse relevant data, which can be applied even to smaller scale businesses and enables a single tool to be used for data analysis rather than multiple separate solutions.

How do I start?

  1. Identify data sources
    The starting point initially requires time to validate sources of data and identify any cleansing required to ensure data integrity. This time should be focused on the data needed to support traceability evaluation.

  2. Determine required outputs
    The next step should be on the what the outputs need to be in the form of standard reports, ad-hoc reports, drill-downs and queries, alerts etc.. Proof of Concept (PoC) outputs can then be created where required, using a subset of the data, so that you can see what the end result would look like and ensure it meets expectations before the full set-up occurs.

  3. Train your users
    Training is also key in terms of how to use Power BI, so that the customer is not solely reliant on the supplier and is then able to amend or adjust as needed.

  4. Manage compliance
    Finally, compliance and GDPR also need consideration with regards to data classification from a GDPR perspective and any other compliance requirements. Security, similarly, is also a key step when it comes to determining who can have access to relevant data sources and outputs.

ColumbusFood can help your food and beverage business

Support for doing this can be achieved using a partner to assist where needed... Ask yourself the following questions:

  • Should these reports be built in house or should you engage a partner to create these for you?
  • Should you create these internally and will you require training?

Consider the timeline vs cost. It may be that initially you use a partner to create the reports on your behalf, then arrange training for your key employees going forward so your reports are created internally.

The approach can be flexible!

Whichever path you decide to take, you will also need the following:

  • Power BI account
  • Power BI Pro Trial Licence
  • Power BI Desktop

Only once you have these in place can you begin.

How can I link Power BI to traceability?

If you capture the relevant information regarding attributes, batches, products, Customers etc.. then you have the ability via Power BI to collate and report on the relevant information which could be accessed and filtered quickly in the event of a potential quality issue arising.

This enables the extent of any issue to be quickly evaluated and appropriate action taken. The example below shows what can be achieved in a very short period of time.

Power BI 2

Defining and implementing an Analytics and Business Intelligence project can happen in a relatively short period of time, and at Columbus we have the industry expertise and the scale to get your ideas off the ground and turn them into reality quickly, using our flexible, rapid approach. Take a look at one of our case studies here!

So, if you need to find a quick route to solving your existing traceability needs and managing the potential impact of any quality issue more effectively then reach out to us here and find out how you can get started.

Topics

Discuss this post

Recommended posts

Quality is about meeting/exceeding your customer expectations every time they buy your product or service. But rising food prices due to global crisis such as the 2020/21 pandemic has placed added pressure on margins, meaning businesses are limited on how much they can spend on improving quality control. That’s why you need to prioritise effectively, so you can make the biggest impact with your expenditure on high quality.
Pressures from production, demand, regulations and more informed consumers are forcing food companies to modernise their business processes.
An ERP system is a powerful tool that combines sales, finance, resources, people and processes into one central location. It connects your departments in real-time, allowing you to make more informed business decisions and increases efficiency at all levels.
Today’s rapidly evolving digital landscape is constantly changing the behaviour and expectations of consumers. The digital era has also created a seemingly endless number of channels you can market your products to potential customers.  But without a clear plan of who you’re targeting, what you’re offering and what your business goals are, you’ll fall by the wayside. So, to succeed in the modern world, you need to know how to build a digital strategy to ensure your efforts have maximum impact.  Let’s dig deeper…  Understand what your customers want  There’s no point driving traffic to your website if all you’re going to get is a pile of spam in your inbox. Gathering customer data isn’t new. But knowing where to start when it comes to pulling this data from your CRM (customer relationship management) system, or knowing what to capture in the first place can be a daunting task.  Here are our top targeting options to use for a strategy:  Attributes – these include age, location, gender, technology preferences, etc  Value – by understanding your customers’ lifetime value, you can segment them into areas like returning buyers/one-time buyers and target them with different methods  Behaviour – e.g. what’s their preferred buying method? There are several tools that allow you access to this information such as Google Tag Manager  Channels – Find out what parts of the funnel are touching your customers. Don’t just look at the last click attribution model – analyse every step to determine which channels to focus on for each segment  Once you’ve gained a better understanding of who you’re talking to, you can start creating buyer personas which are profiles that represent your ideal customers. This allows you to tailor your marketing efforts to engage with your target audience and meet the needs of your customers. 
Today’s consumer wants quick satisfaction and constant connectedness, which is making it increasingly difficult to hold their attention. So, like you, we’re always looking at better ways to get our value proposition message across to our customers. This blog contains tips we’re currently implementing into our business and we hope they can help inspire you too.
right-arrow share search phone phone-filled menu filter envelope envelope-filled close checkmark caret-down arrow-up arrow-right arrow-left arrow-down