Why you need Business Intelligence (BI) software for better insight

Recently we discussed data analytics and asked our customers what their thoughts were on the subject.

Every single person in the room agreed, without exception, that accessing business data and using it to aid strategic decisions is incredibly important.

That’s not too surprising because, after all, these were printing companies that have not only invested in a Management Information Solution (MIS) solution but have also taken the time to attend a user event. These were companies that appreciate the value of this type of software and know the positive impact it can have on their business.

But it seems that not every printing company is like that. A recent report from BCG showed that, although manufacturing executives understand the power of Big Data, and 72% reported that they rely on advanced data to improve productivity, only 17% claim to take advantage of data analytics.

...72% rely on advanced data to improve productivity, but only 17% claim to take advantage of data analytics

And that’s a big shame. Because this is where the competitive advantage lies. It’s the analysis of your MIS data that really aids strategic decision-making, that helps you better understand your business, the printing industry, your customers and market trends. That will help you predict revenue and increase the productivity of your employees, software and machines.

What is not defined cannot be measured. What is not measured, cannot be improved. What is not improved, is always degraded. - William Thomson Kelvin.

Content 

• The future of data analysis – taking it to the next level
• How does BI software work?
• 7 examples of how you could use BI software in your business
• Sold? Here’s how to get started using a BI software

The future of data analysis – taking it to the next level

Historically, data analysis has been focused on creating a set of reports, either physical or digital, which extract your data and set it out as a readable story of facts and figures. While this sort of analysis is an awesome tool for gaining mid-level data for your print business, it can be pretty limited if you want to dig a bit deeper.

That’s why we believe that the future of data analysis lies in using BI software to interrogate your MIS data and visualize trends.

...the future of data analysis lies in using BI Software

Up until recently, BI software has been seen as somewhat inaccessible to many printers and converters because of the high cost associated with them. But as technology continues to develop, and prices drop drastically, we’ve seen the number of our customers using BI steadily increasing.

A brilliant example of this is the PowerBI from Microsoft, which is a very intuitive, easy-on-the-eye solution and (this is the best bit) free with most Office 365 subscriptions.

How does BI software work?

Most BI software generally connects to the data stored in your MIS software using an API and can be used to analyze disparate databases of information such as estimates, orders and delivery times and then present them in a way that allows you to quickly visualize trends and glean insight into your business. You can create your own dashboards by specifying what data you want to analyze, and specifying how you want that data to be displayed e.g. chart type, summaries, percentages or tables.

Because the dashboards are interactive, and instantly update whenever you change a filter or select a piece of information, they are fantastic for taking into meetings, especially strategic ones. No more printing out 10 copies of a report and not being able to answer a question about that data without going away and running a new report! You can simply pull up the interactive dashboards and go through the data in real-time.

Here are 7 examples of how you could use BI software in your business:

1. Interrogate sales data per product

You’ve created a dashboard that analyzes the profitability of each of your product types. It shows that roll labels were your most profitable product in 2022. But you don’t have to stop there – you can now drill into the data to identify the most popular subset. Was it vinyl? Polyester? Foil? Maybe it’s time to increase capacity in one of these areas and invest in new equipment!

2. Analyze recent engagement with one particular customer

You want to analyze how it’s going with your biggest customer to see how things have changed since the pandemic, so you create the below dashboard. The sales for 2019 are displayed in comparison to the sales for 2021, allowing you to instantly see that there’s been a big reduction and that this continues month on month.

3. Compare sales performance between reps

You have upcoming performance reviews with your sales reps, so you create a dashboard identifying who brought in the most profit and who met their targets. Time to appeal to their competitive nature!

4. Identify your most profitable products and sectors

You can also generate a BCG chart that gives you a graphical representation of your product portfolio and ranks your best- to worst-performing products, helping to guide business decisions on where to focus your efforts in the future.

For those of you who are new to the concept of BCG charts, the chart is split into four sections:

• Stars – High profits and efficient to produce
• Cash Cows – High profits but less efficient to produce
• Dogs – Low profits and inefficient to produce
• Question Marks – Low profits but efficient to produce

This is a fantastic way to work out which products and sectors you need to focus more on (your Stars), or which ones you might be better off dropping or even outsourcing (your Dogs and Question Marks). You can also use it to identify areas where you need to streamline and automate your production processes so you can increase your profit margins (your Cash Cows).

5. Use your data to identify trends and forecast upcoming work

Since the BI dashboards allow for data comparison, you can use filters to get visual information for the number of previous orders per month and drill down into the types of products sold, which customers placed orders, and so on. This means you can analyze trends from previous years and predict when jobs might increase so you can prepare for this.

For example, you might see from the analysis that the number of pull-up banners ordered in November has increased from the month before for 3 years running, so you can plan ahead and order more materials in preparation.

6. Measure makeready times for each operator

Analyze your shop floor data to look at the average makeready times per period, and then drill into that data to show this information per operator. Carry out some trend analysis to see if you can identify any areas for improvement. Perhaps the night shift team are taking longer than the day shift – now you know this, you can look at why and maybe carry out more training to resolve it.

7. Analyze response times to identify improvements to customer experience

You could also analyze response time data to identify areas for improvement. For example, what is the average timescale between an order being placed and the order being shipped? How long are customers waiting for an estimate after their request? By identifying these trends, you can then work to automate more of the processes involved in this activity.

A couple of examples:

• Reduce the amount of time spent processing purchase orders and invoices by digitizing this process. One of our customers recently did this, and here’s how.
  
• If you find your CSRs are spending too much time dealing with artwork and there are costly errors going unnoticed for days further down the workflow, your data will show this. You could implement automated artwork submission, so your CSRs are only having to deal with errors flagged by the software.

It was reported in 2018 that only 40% of large businesses were said to be using automation across the organization or have fully automated processes in at least one business function (McKinsey, 2018). So any opportunity to automate your workflow should be seized upon. You can use it to really stand out from the crowd and improve your customer experience!

...in 2018, only 40% of large businesses were said to be using automation across the organization

Sold? Here’s how to get started using BI software

1. Speak to your MIS software provider about their existing software and integrations.
2. Sign up for something like Microsoft’s PowerBI – again, this is free with most Office 365 subscriptions, so is a great starting point.
3. Identify a person in your team who shows an appreciation of data and continuous improvement, and appoint them as your official BI project leader. This person will also be in charge of distributing licenses to the rest of the team and keeping data cleansed and up to date.
4. We always advocate having a team that’s responsible for continuous improvement projects involving automation and systemization, and this will be the perfect group of people to work on introducing BI software into the business.
5. Make sure your team has everything they need to make it a success, like the right technology and dedicated time away from their usual role.
6. Now you need to make sure your MIS data is accurate and optimized, otherwise, it’ll be a case of ‘garbage in, garbage out’. For example, make sure job and product types are set correctly and that jobs are always marked as complete. If you allow corners to be cut with your data, and then implement BI software, it will quickly become clear. But you shouldn’t let this put you off using these BI dashboards – in fact you can use them to identify your messy data so you can put plans together to whip it back into shape.
7. Find and join a BI community – Power BI have a dedicated community and user groups for users across the world, who want to connect with like-minded people to share ideas, upskill and learn about new products. These sites are a great way to ask for advice and get help when you’re getting started.

... businesses using BI software to analyze data are in the best position for success

There are significant opportunities to leverage the data within your MIS and print quoting software to learn more about your business, customers, and processes so you can continually improve. And it’s the businesses that make use of BI software to interrogate and analyze this data that are in the best position for success.

We hope you’ve found some inspiration from this article to get you started on your own data journey and implement BI software that will help you create more informed strategies and make smarter decisions.