Modern Shop Floor Series S2: Real-Time Insights and Dashboards

This is session two of a four-part webinar series: Modern Shop Floor

This webinar empowers manufacturers to transform their shop floor operations by leveraging real-time data and actionable dashboards, helping teams make faster, smarter decisions. Viewers will gain practical strategies to boost efficiency, align business goals, and create a competitive edge using accessible technology solutions tailored for organizations of any size.

  • How to choose and implement KPIs that drive real-time decision-making and impact your shop floor.
  • Ways to make dashboards and BI tools accessible for everyone, from mobile devices to large displays.
  • Strategies to turn data into actionable insights aligned with your company’s strategic goals.
  • Tips for small manufacturers to justify costs and start dashboard pilots.
  • Examples of key manufacturing KPIs like OEE and OTIF, and how to measure them using Epicor ERP and Power BI.

Webinar Companion One-Pager |  Watch Session 1 Now | Podcast Episode


+ Full Transcript

Real-Time Manufacturing Insights and Dashboards for the Modern Shop Floor

Moderator: Good afternoon and welcome. Today, we’re continuing our four-part webinar series on technology for the modern shop floor.

In part one, we discussed the technology infrastructure that supports a modern manufacturing environment. Today, in part two, we’re digging into real-time manufacturing insights, dashboards, and key performance indicators, or KPIs.

Today’s presenters are Mark Jamieson, President and CEO; Tom, CTO; and Sam, who leads our Epicor practice.

If you’re not familiar with 2W Tech, we’re a technology solutions and managed services provider specializing in manufacturing and distribution. Our solutions span Epicor ERP, Microsoft cloud technologies, cybersecurity, managed IT, data analytics, and more.

I’ll now turn it over to Mark to get us started.

Why Does the Modern Shop Floor Need Better Data?

Mark: This is episode two of our four-part series on modernizing the shop floor.

We created this series because we’ve realized that, from a technology perspective, the shop floor can sometimes become the forgotten part of a manufacturing facility.

Tom: When we walk into manufacturing environments, we often see a multigenerational shop floor.

You might have a brand-new, computer-controlled, multi-axis machine operating right next to a piece of equipment that’s been running reliably for decades.

And the workforce can be multigenerational too. You have experienced operators working alongside the next generation of technicians and apprentices.

The technology infrastructure often reflects that same mix of old and new.

What Technology Infrastructure Supports a Modern Shop Floor?

Tom: In part one of this series, we focused on infrastructure as the foundation for the modern shop floor.

We organized that conversation around three pillars: reliable, flexible, and secure.

Reliable: Manufacturers need dependable connectivity, including solid Wi-Fi and networking, so production operations aren’t constantly interrupted by technology problems.

Flexible: Shop floor employees need access to appropriate devices such as tablets, mobile devices, and scanners that can adapt to changing production requirements.

Secure: Manufacturers also need strong authentication, cybersecurity controls, data protection, and appropriate safeguards for applicable regulatory and compliance requirements.

Once that infrastructure foundation is in place, manufacturers can begin doing more with ERP systems, integrations, dashboards, reporting, and real-time shop floor data.

What Makes a Good Manufacturing Dashboard?

Sam: Today, we’re building on that foundation by focusing on KPIs, or key performance indicators, and the dashboards and business intelligence tools used to display them.

We’ve organized this conversation around another three pillars.

Your manufacturing data and KPIs should be:

1. Accessible
The right information should be available to the right people where they need it.

2. Actionable
The information should arrive in time for somebody to actually do something about it.

3. Meaningful
The metrics should connect to the goals and priorities that matter to the business.

1. How Do You Make Shop Floor Data Accessible?

Sam: Historically, a lot of shop floor information has been paper-based or delivered through relatively basic reporting.

There’s still a place for traditional reports, but modern data analytics creates an opportunity to move from information that’s produced weekly or monthly to insights that can be delivered much closer to real time.

Accessibility also means making dashboards and KPIs available where people actually work.

That could mean viewing manufacturing data on a mobile device, tablet, computer browser, smart TV, or large display on the shop floor.

The goal is to give teams visibility into consistent information without requiring everyone to manually hunt for it.

Ideally, employees across the business can see the information that’s relevant to their responsibilities and work from a consistent view of the data.

How Do You Decide Which Manufacturing KPIs to Track?

Sam: Start with the business.

Whether you’re responsible for sales, customer service, production, materials management, shipping, quality, or finance, ask yourself: What measurements actually matter?

For example, if you’re responsible for quality, don’t start by asking how many charts you can build.

Ask what quality measures would actually help the organization make better decisions and improve performance.

Mark: That’s important because modern ERP systems can generate enormous amounts of data.

That’s both the good news and the bad news.

Having more information doesn’t automatically create more insight. If you’re not careful, you can create a lot of noise without giving anyone information they can actually use.

The challenge is identifying what matters and turning that information into something actionable.

2. What Makes Manufacturing Data Actionable?

Sam: That’s exactly why actionable is our second pillar.

A KPI should measure and communicate something that matters, whether that’s quality, production performance, schedule attainment, costs, delivery performance, or another important manufacturing objective.

Real-time manufacturing data should deliver information at the point of use and early enough to influence the outcome.

For example, learning that you missed an important customer shipment last week can help you understand what went wrong.

But knowing which shipments are scheduled between now and the end of this week, and whether production is currently on track to meet those commitments, gives you an opportunity to take action before a customer is impacted.

That’s actionable data.

Historical reporting is still valuable, but real-time dashboards can help manufacturers move from simply understanding what happened to influencing what happens next.

Mark: A traditional report is essentially a picture in time. The moment you print it or export it into a spreadsheet, the business may already have changed.

Some information should absolutely be historical. Financial reporting is an obvious example.

But when we’re talking about shop floor performance, we often want to know what’s happening now, where production stands, where there are problems, and what requires attention.

Which KPIs Should Manufacturers Start With?

Sam: Start small.

For each business function, identify a small number of measurements that could actually change behavior or improve decision-making.

That could apply across quoting and estimating, sales, customer service, production, quality, materials management, shipping, finance, or accounting.

Ask: What can we measure and report quickly enough that somebody can still make a difference?

How Do Manufacturers Bring Data from Different Systems Together?

Tom: There are several layers to this.

First, you need the infrastructure and devices required to collect the data.

Then you need to understand exactly which data points you’re collecting and where that information exists.

Business intelligence tools, data platforms, data warehouses, and technologies such as Microsoft Fabric can help connect information from different business systems and make it available for reporting and analytics.

The goal is to establish reliable paths between your underlying systems and the reporting tools that need the data.

One challenge is normalizing that data so the information coming from different systems can be presented consistently and accurately in your KPIs and dashboards.

Again, start small. Identify the specific data required for the dashboard or KPI you’re building, establish that connection, and expand from there.

3. What Makes a Manufacturing KPI Meaningful?

Sam: This is really where the rubber meets the road.

A modern ERP system can collect and report an incredible amount of data. But meaningful KPIs are tied directly to the strategic goals of the organization.

There’s an old principle: begin with the end in mind.

Start with the strategic objective. Then work backward to determine which KPI will help you measure progress toward that objective.

From there, work backward one more step and determine which data points are required to calculate that KPI.

In other words: start with the goal, define the KPI, then identify the data.

How Do You Connect Manufacturing KPIs to Business Goals?

Sam: Let’s use customer satisfaction as an example.

Imagine one of your company’s strategic goals is to improve customer satisfaction.

You could connect that objective to a quality KPI such as customer complaint rate.

Then you identify the information needed to calculate and monitor that KPI, such as the number, type, frequency, and severity of customer complaints.

That information may already exist in your Epicor ERP system, or it may exist in another platform.

Technologies such as Microsoft Fabric and Power BI can help combine and present information from multiple sources when the required data isn’t all stored in the ERP.

The important part is the sequence: strategic goal → KPI → underlying data.

What Happens When Manufacturing KPIs Conflict?

Sam: Senior management also needs to make sure the organization’s strategic priorities are clear because different goals can conflict with one another.

For example, a company may want to reduce inventory carrying costs while also increasing customer service levels and product availability.

Those goals can create tension.

Leadership needs to establish priorities and acceptable trade-offs so the KPIs don’t unintentionally encourage different teams to optimize for conflicting outcomes.

Mark: And if you’re creating a strategic priority but can’t define it or determine how you’re going to measure it, you may need to rethink that priority.

What Are Common Manufacturing KPIs?

Sam: There are many manufacturing KPIs worth considering, but the right ones depend on your organization’s goals.

One example might be quote activity. If the strategic objective is to increase market share or acquire new customers, you may want to track measures such as the number of quotes generated for new prospects and the resulting conversion rate.

Many of those measurements can be captured through systems such as Epicor Kinetic and then presented through ERP dashboards or business intelligence tools.

Two manufacturing KPIs that come up frequently are Overall Equipment Effectiveness and On-Time In-Full delivery.

What Is Overall Equipment Effectiveness (OEE)?

Sam: Overall Equipment Effectiveness, or OEE, is a commonly used manufacturing metric that provides insight into equipment productivity.

OEE considers three major factors: availability, performance, and quality.

Expressing those factors through a consistent metric can help manufacturers understand how effectively production equipment is operating and where opportunities for improvement may exist.

What Is On-Time In-Full (OTIF)?

Sam: Another important manufacturing KPI is On-Time In-Full, or OTIF.

OTIF measures whether customer orders are shipped when promised and in the quantity the customer requested.

For example, if a customer ordered 100 units, did you ship all 100 rather than 90 or 85? And did you ship them when you said you would?

That’s a relatively straightforward measurement, but it can provide valuable insight into operational performance, customer satisfaction, and order fulfillment.

How Can Manufacturers Visualize ERP and Shop Floor Data?

Mark: Once you’ve identified the KPI and the underlying data, you can present that information using tools such as Microsoft Power BI, Epicor dashboards, or other business intelligence platforms.

There is work involved in connecting, structuring, validating, and presenting the data, but the goal is relatively simple: give the right people visibility into the right information at the right time.

And don’t build dashboards simply because you can.

Build dashboards that help someone make a decision, identify a problem, understand performance, or take action.

How Should Manufacturers Get Started with Real-Time Dashboards?

Manufacturers don’t need to digitize every metric in the business at once.

A practical starting point is:

1. Start with a strategic business goal.
Decide what outcome you’re trying to improve, such as delivery performance, quality, production efficiency, customer satisfaction, or inventory management.

2. Choose a small number of KPIs.
Identify the measurements that best show whether you’re making progress toward that goal.

3. Identify the required data.
Determine whether the information lives in Epicor ERP, another manufacturing application, Microsoft 365, or another business system.

4. Make the information accessible.
Deliver the dashboard or KPI to the employees who need it, whether that’s on a desktop, mobile device, tablet, or shop floor display.

5. Make sure someone can act on it.
Real-time data creates the most value when employees can use it to change an outcome rather than simply explain what already happened.

6. Measure the business impact.
Evaluate whether the KPI and dashboard are actually improving decisions, processes, or business performance.

What’s Next for the Modern Shop Floor?

Mark: We’ve now covered the infrastructure foundation and how manufacturers can use real-time insights and dashboards to create better visibility into shop floor operations.

In the next part of the series, we’ll focus on streamlining manufacturing operations with ERP and automation, including how information gets from the shop floor into your ERP system.

Then we’ll bring everything together by looking at how modern shop floor technology can help manufacturers create competitive advantage.

Moderator: Thanks, Mark, Tom, and Sam, and thanks to everybody who joined us today.