• Twitter
  • Facebook
  • LinkedIn
  • Contact us
  • Login
Safefood 360°
  • Why Safefood 360°
    • Why Safefood 360°
      • Food Safety Management
      • Supplier Quality Management
      • Food Safety Risk Assessment Tools
      • Enterprise Food Safety
    • Technology
      • Software Modules
      • Advanced Security & Technology for Food Safety Compliance
      • Available Languages
      • Supporting Standards
      • StatusBI Business Intelligence
      • Food Safety Remote Working
      • Self-Service Reporting Tool
  • Support
    • Technical Support
    • Professional Services
    • Customer Success
    • Education & Training
  • Blog
    • Food Safety Knowledge
    • Food Safety Industry News
    • Product Updates
    • Data Report
  • Customer Success
    • Case studies
    • Testimonials
  • Resources
    • ROI Tool
    • Webinars
    • Whitepapers
    • Datasheets
      • Physical Hazard Series
      • Chemical Hazard Series
      • Microbiological Hazard Series
      • Food Safety Management Series
    • Presentations
    • Ebooks
    • Tools
  • Company
    • Team
    • Sustainability
    • Get in Touch with Our Team – Contact Us
    • About Safefood 360°
    • About LGC Assure
  • Demo Request
  • Search
  • Menu Menu
  • Why Safefood 360°
    • Why Safefood 360°
      • Food Safety Management
      • Supplier Quality Management
      • Food Safety Risk Assessment Tools
      • Enterprise Food Safety
    • Technology
      • Software Modules
      • Advanced Security & Technology for Food Safety Compliance
      • Available Languages
      • Supporting Standards
      • StatusBI Business Intelligence
      • Food Safety Remote Working
      • Self-Service Reporting Tool
  • Support
    • Technical Support
    • Professional Services
    • Customer Success
    • Education & Training
  • Blog
    • Food Safety Knowledge
    • Food Safety Industry News
    • Product Updates
    • Data Report
  • Customer Success
    • Case studies
    • Testimonials
  • Resources
    • ROI Tool
    • Webinars
    • Whitepapers
    • Datasheets
      • Physical Hazard Series
      • Chemical Hazard Series
      • Microbiological Hazard Series
      • Food Safety Management Series
    • Presentations
    • Ebooks
    • Tools
  • Company
    • Team
    • Sustainability
    • Get in Touch with Our Team – Contact Us
    • About Safefood 360°
    • About LGC Assure
  • Demo Request
46780974 ml

Developing advanced food safety reports and dashboards using external BI software

in blog

You might not have realized it yet, but Safefood 360° has amazing reporting capabilities compared to most enterprise level software. This is because we give you super fast access to your data, allowing you to develop whatever reports you need. The system offers a number of different tools that allow you to get answers quickly and easily; the trick is just to use the right tool for the right question. And, sometimes you need to know how to use these tools together with some other reporting solutions. This is true for most enterprise software solutions like ERP or CRM systems.

There are two types of reporting tools available in Safefood 360°:

  1. Standard reports that are available in every module right out of the box. These reports can be printed, emailed or saved in various formats including PDF and Excel. Any of these reports can be automatically scheduled for repeating email delivery. The standard reports give you quick access to your data as registers and simple graphs. Most times, these reports contain exactly the answer you were looking for. So, they are great when you need quick access to some key information that you need for managing the day-to-day operations of your food factory.
  2. Query Tool that is found in the “Reports” module. It allows you to export whatever fields and columns you want and use the data in Excel or other BI (Business Intelligence) tools. Query Tool is your best friend when you want to develop advanced dashboards. When it comes to your monthly, quarterly and annual management reports, you will probably need to combine lots of different data sources into one chart or report.  The Query Tool is the right way to go here.

In this blog post, I want to explore the possibilities of using the Query Tool together with Excel and other BI tools. I’m not going to explain in great detail how to build these dashboards, but rather to open your eyes to the possibilities. There are a number of tools out there that allow you to develop powerful reports and dashboards in a matter of minutes as long as you realize the potential.

What is the Query Tool?

Earlier this year, we introduced the new Query Tool into Safefood 360° and it has rapidly become one of the most used features in the software. It allows you to:

  • Create your own reports by selecting whatever data you want
  • You can order columns any way you want
  • The data in columns can be ordered by date, by number, or by alphabetical order, etc.
  • Data can be either printed on individual lines or summed together into aggregate values
  • Queries can be saved for later access
  • The data can be exported to Excel

It all begins by exporting your data

In order to use Excel or other BI tools, you need to first export your data. Query Tool is perfect for this and it only takes some seconds to grab your data for export. In the picture below, you can see the query I used to export data from the Corrective Action module with the intention of building some neat dashboards from the data. You need to save your query first, and when you open it, you will see an “Export to Excel” button.

Exporting data with the Query Tool

A good rule of thumb for developing dashboards is to export all rows from the table and then filter the data in your BI solution. The more data you have in the beginning, the better the results will be.

Example 1: CAPA dashboard in Excel

Here, we can see an automatically generated Excel dashboard where our Corrective Actions have been organized into a pipeline view. A simple macro runs through the exported data and drops the actions into this grid. Actions are colour coded, based on their risk category. You can filter the actions by the risk level and the link takes you to the original record. What a great way to see your corrective actions on one page! You could easily add a timeline slicer into your spreadsheet, allowing you to filter data by date as well.

CAPA dashboard in Excel

Example 2: Monitoring deviations heat-map

This chart is 100% formula based and it requires no Macros to be enabled. All you have to do is to copy and paste the data from a specific query into the spreadsheet. The query combines records from four different monitoring programs into one dataset and the spreadsheet then sorts and manipulates the data in a number of different ways. We also used conditional formatting to automatically generate highlights that draw the eye to values that are outside the average and only those months that have past.

Deviations heatmap

Example 3: Advanced dashboards using Zoho Reports

You could use any BI software, but if you are new to the field, Zoho Reports is an inexpensive and easy to use business intelligence suite that can solve 95% of even your most complex analytical tasks with little learning curve. It has similar, if not more comprehensive, features than other BI software packages, but in many ways it’s much easier to use than other software suites, like Qlick where significant time can go into developing dashboards. Zoho Reports works in the cloud – so you don’t have to install anything locally and you can access your dashboards from anywhere – and there is a free version available.

Zoho Reports for building dashboards

The picture above shows a report where we grouped the data using three variables: Year, Risk, & Status. Clicking on any of these labels reveals the underlying data, which means you can drill down very easily without any programming. Below, you can see the same report embedded into a single dashboard with two other widgets and the ability to filter the data based on risk, date and status. Building this dashboard took less than 10 minutes from start to finish, which is testament to how easy it is to get dashboards these days – all you need is the source data and a good idea. The Query Tool gives you access to the data faster than almost anything else I’ve seen, so getting the inspiration is the only thing you have to solve yourself.

An advanced CAPA dashboard using Zoho Reports

Example 4: Advanced dashboards with Microsoft Power BI

Microsoft has a handy software called Power BI and there is even a free version of it. The software works in cloud, desktop and mobile environments, which is great for having your reports and dashboards available in every channel and device you might be using.

Food safety dashboard and KPIs using Microsoft Power BI

Setting this dashboard up using the same dataset took about 15 minutes. Power BI is nowhere near as flexible as Zoho Reports is in terms of your ability to manipulate the data by calculating fields, creating custom formulas from your dataset, etc., but it does offer a really sleek user experience with visually appealing results. Drilling down to segments of the data is also extremely easy; all you have to click is one of the widgets and the dashboards adjust showing just the underlying data. Having the free version available can make the threshold of getting started very low.

Example 5: A simple supplier dashboard using Qlik

As I mentioned earlier, Qlik is a software that can take some time to set up. However, when you get the hang of it, it is probably the best solution of all the listed software solutions: It is cloud based, offers sleek style and powerful formulas for manipulating your data. With Qlick, it is easy to combine data from a number of datasets into the same dashboard, which is great when you want to get information from more than just one module. Free versions are available for both cloud and desktop. This example shows you a simple supplier dashboard where we have drilled down to the data, based on approval status and country.

Simple supplier dashboard using Qlik

When it comes to BI suites the sky is the limit to what you can build. I hope this post comes in handy for those power users of Safefood 360° who are looking for some inspiration on what they can do with all their data. Have you tried building something more advanced in Excel or some other BI suite using your Safefood 360° data?

Share this entry
  • Share on Facebook
  • Share on Twitter
  • Share on LinkedIn
  • Share by Mail
https://safefood360.com/wp-content/uploads/2015/10/46780974_ml.jpg 1061 1769 /wp-content/uploads/2015/04/sf360-logo.png 2015-10-28 16:17:092016-03-16 17:08:33Developing advanced food safety reports and dashboards using external BI software
1 reply
  1. Mohammed Taha
    Mohammed Taha says:
    27 September 2022 at

    I a Quality and Food safety manager in meat factory
    I need to know please the cost of this system and how can I apply it in my industry scope

    Reply

Leave a Reply

Want to join the discussion?
Feel free to contribute!

Leave a Reply Cancel reply

Your email address will not be published. Required fields are marked *

Recent
  • webinar1 SPC
    Unlocking the Power of SPC in Food Safety: A Webinar Re...
  • Safefood 360 is top performer on sourceforge in Summer 2023
    Safefood 360°: Top Performer Summer 2023 at SourceForg...
  • RISK Jun 2023 report
    Food Safety Alert Update (June 2023)
  • RISK May 2023 report
    Food Safety Alert Update (May 2023)
  • sf360 Single sign on
    Should I implement single sign-on (SSO) for food safety...
  • How do Chemical Hazards Occur in the food safety process 1
    How do Chemical Hazards occur in the Food Safety Proces...
  • RISK Apr 2023 report
    Food Safety Alert Update (April 2023) by Safefood 360°...
  • How do Physical Hazards Occur in the Food Safety Process 1
    How do Physical Hazards Occur in the Food Safety Proces...
  • The high cost of Cross contamination in the food sector
    The High Cost of Cross-Contamination in the Food Sector
  • RISK Mar 2023 report
    Food Safety Alert Update (March 2023) by Safefood 360°...
  • RISK Feb 2023 report
    Food Safety Alert Update (February 2023) by Safefood 360°...
  • RISK jan 2023 report
    Food Safety Alert Update (January 2023) by Safefood 360°...
  • Novel Food Regulation
    Novel Food Regulation: EFSA versus FDA
  • RISK Dec 2022 report
    Food Safety Alert Update (December 2022) by Safefood 360°...
  • RISK Nov 2022 report
    Food Safety Alert Update (November 2022) by Safefood 360°...
  • Blog post image 13
    Complete Guide to Food Cooking Temperature Control
  • RISK Oct 2022 report
    Food Safety Alert Update (October 2022) by Safefood 360°...
  • Blog post image 8 1
    7 Ways Compliance Management Platforms Improve Operational...
  • 6 Ways
    6 Ways to Implement Preventive Measures and Controls For...
  • RISK sep 2022 report
    Food Safety Alert Update (September 2022) by Safefood 360°...
  • Blog post image 3
    Safefood 360° is nominated as top 20 Compliance Technology...
  • New Business Director of Safefood 360_ David_Richardson
    LGC Assure appoints David Richardson as Business Director...
  • food_safety_hazard
    Hazards 101: An Introductory Guide
  • Blog post image 1
    What is Food Safety Management Software (FSMS)?
  • RISK Aug 2022 report
    Food Safety Alert Update (August 2022) by Safefood 360°...
  • RISK Jul 2022 report
    Food safety alert update (July 2022) by Safefood 360° RISK...
  • NVWA
    Reducing Regulatory and Legal Interventions
  • Salmonella outbreaks
    How do you lower the risk of Salmonella contamination?
  • RISK June 2022 report
    Food safety alert update (June 2022) by Safefood 360° RISK...
  • uk food report summary
    Summary of the UK 2021 food report
Popular
  • CCP PRP blog
    Understanding the difference between PRP, OPRP & CCP...
  • fsma harpc guidance
    The difference between HACCP and HARPC. A case of the Emperor’s...
  • Auditing
    New checklist available for TS ISO 22002
  • thanks for c360
    Thank you for Connect 360°
Comments
  • Gay KSend me info on what foods and drinks and water having MRA...20 June 2023 - by Gay K
  • AmrikDear Sanika , we want to use one line to be able to ...9 February 2023 - by Amrik
  • EthanThanks for reach out ,would like to discussion13 October 2022 - by Ethan
  • Mohammed TahaI a Quality and Food safety manager in meat factory I need...27 September 2022 - by Mohammed Taha
Tags
cross contamination food safety food safety compliance system food standard and legislation pandemic Report RISK Risk Assessment Tool supply chain webinar

Archives

Frame 16

Safefood 360°, built by a group of food safety experts in 2010, is designed to tackle the real difficulties facing food-related industries by combining Food Safety Management and Supplier Quality Management Solutions with over 35 pre-set modules – creating a fast, secure, and audit-ready working environment.

Follow us
  • Link to Facebook
  • Link to Twitter
  • Link to LinkedIn

Solutions

  • Food Safety Management
  • Supplier Quality Management Software: Food Safety & Compliance
  • Line of Sight & Horizon Scanning Risk Assessment Tools
  • StatusBI Business Intelligence

Support

  • Technical Support
  • Professional Services
  • Password Reset Instructions
  • Accepting an invitation from Safefood 360°
  • How to Fill in the Master Data Worksheet
  • Frequently Asked Questions

Resources

  • Whitepapers
  • Technical Data Sheets
  • Webinars
  • Tools
  • Presentations
  • Privacy Policy
© Copyright – Safefood 360°
The Utilities menu will change later this weekSystem Update44670675 mlDo we need all these different food safety standards?
Scroll to top