From the Detailing Table to the Dashboard
CIOREVIEW >> Data Analytics >> NEWS

Red Cedar Steel

Cassandra Butzler, Director of Innovation and Analytics

From the Detailing Table to the Dashboard

Cassandra Butzler, Director of Innovation and Analytics
Cassandra Butzler, Director of Innovation and Analytics, Red Cedar Steel

Cassandra Butzler

Data-Driven Improvement Champion

I started my professional journey as a Structural Steel Detailer in a small fabrication shop in southern Wisconsin. Since then, I've held a variety of positions in companies that vary greatly in size, business structure, and people.

The one constant everywhere I've worked is that there were opportunities for improvement, both for me and for the organization. Identifying those opportunities, then finding and implementing solutions, is what has brought me to where I am today. It is also what shapes how I approach innovation and analytics: pay attention to where things could be better, measure it and do something about it.

Finding the Opportunities

There are three key ways I identify opportunities where data and analytics can make a real difference.

The first is to understand the data we're already collecting and start tracking how it changes. Most organizations are sitting on more information than they realize, and there's a lot to learn from watching the trends.

The second is to start with pain points and find ways to track meaningful data around them. For example, we suspected that our pending Change Order Requests were becoming significant, but we didn't have a clear picture. We developed a system for company-wide tracking and reporting, and that created the visibility we needed to tackle the problem.

The third relates to implementations. Before we implement a change, it's important to understand its impact, and the best way to do that is through data analytics. Identify the data points (KPIs) that may be impacted by the change, then measure them and identify trends before the implementation. After implementation, monitor those KPIs and watch how the measurements and trends change. This ensures that follow up decisions to keep, adjust or roll back a change are based on results, not opinions.

The Danger of Bad Assumptions

One of the biggest challenges in turning analytical insights into business decisions is misinterpreting the data. The numbers may be accurate, but the assumptions we make about why they look the way they do often aren't.

The best prevention I've found is group discussion with the people who are upstream from the data, the people whose work creates it. Here's an example. We noticed that we were going way over budget on equipment fuel. Fuel prices had recently gone up, so we assumed that was the whole story.

  Innovation doesn't have to start with a big technology investment. It starts with noticing where things could be better, measuring what matters, checking your assumptions with the people who know the work, and following through.  

When we went over the data with the group, we found that approximately half of our Project Managers, all of them the newest ones, weren't transferring the fuel dollars from the estimate to the budget. Higher fuel prices were making an impact, but not nearly as much as the data suggested.

If we had acted on our first assumption, we would have chased the wrong problem. Instead, we fixed a process gap that would have kept skewing our numbers. For leaders, the lesson is simple: before you act on what the data says, sit down with the people closest to it and ask what it means.

What's Coming for the Steel Industry

I anticipate that we'll see more robotics and AI analysis of data from sources we never had access to before. 3D scanners, drones with cameras and robotic tools will track productivity, monitor safety and perform any tasks that can be automated. That opens up a level of insight into the shop and the field that just wasn't practical a few years ago.

I also expect that we'll be less dependent on subscription software services as we transition to building our own custom systems. The tools to build software around how we actually work are more accessible than ever.

AI's ability to analyze data will only improve, but the interpretations will always require human review and understanding. The fuel budget story is a good reminder: the data was accurate, but it took people who understood the process to explain what was really going on.

Advice for Data-Driven Leaders

My advice to anyone looking to do more data-driven leadership is practical: learn Claude (with an Enterprise license) and Power Query. Use Power Query to analyze your financial data and use Claude to develop dashboards for presentation to leadership. Together, they get you from raw numbers to a clear story much faster than was possible before.

Just as important, understand your audience. There is likely a combination of leaders who want just the conclusions and leaders who prefer to have all of the data points and draw their own conclusions. Build your presentations so both get what they need: the conclusions up front, with the supporting detail available underneath.

What Stays Constant

Innovation doesn't have to start with a big technology investment. It starts with noticing where things could be better, measuring what matters, checking your assumptions with the people who know the work, and following through. That's been true for me since my days as a detailer, and I expect it will stay true no matter how much the technology changes.

The articles from these contributors are based on their personal expertise and viewpoints, and do not necessarily reflect the opinions of their employers or affiliated organizations.