Skip to content
Simio background artwork

Data-Driven Modeling & Relational Data in Simio

Adam Sneath

August 20, 2024

Unleashing the Power of Your Data

In the dynamic landscape of industry today, optimized processes and informed decision making are paramount for success. As technology continues to evolve, so does the importance of leveraging data-driven approaches in analysis and decision-making. One such realm where data-driven modeling takes center stage is discrete event simulation (DES). Once you get beyond the most basic modeling concept in Simio – placing and connecting object instances and setting the corresponding property values – use of data tables is the most important concept for building well-constructed, flexible, extensible, and reusable models.

Effective data-driven modeling starts before ever opening the software. Consider the following: you have spent the time with stakeholders to develop a functional specification, identifying specific business questions you hope to answer with the model. At this point, you now have a clear picture of the model scope, where the model should start and end, what products, lines, areas, etc. are to be considered. If your next inkling is to open the software and start placing objects in the facility view, pump the brakes!

Before Beginning Your Simulation Journey

One of the first modeling decisions often starts upstream in the modeling process. You will need to consider: how are the mix of products, pallets, patients, customers, etc. entering the system, and how should they be modeled? This is an excellent chance to let process data guide the conceptual model design. In a manufacturing or warehouse environment, you may have specific order data, with release dates/times, that are linked to finished good SKUs (stock keeping units) in a materials master. The SKU may be further linked to a routing or flow through the system. Importing this data, establishing the primary and foreign key relationships between tables, and using the data to drive the model objects can be a huge head start to your model build.

Alternatively, in a customer service environment like fast food, airports/terminals, or healthcare, you may have a set of profiles with attributes that dictate customers’ journeys through the system. Establishing each customer type as a row in a data table used to drive entity creation, routing, and processing requirements is likely the way to go! If you find that you are instead placing a handful or more of Source objects in the Facility view and establishing routes using a spiderweb of links (paths, connectors, etc.) with SelectionWeights between objects, this could be a red flag. Starting with a data-driven approach at onset will save you hours of development and debugging compared to the more hard-coded approach. 

Steps to Simulation Success

There are two key steps to data-driven modeling in Simio: getting data into Simio, then using the data with Simio model objects and processes. On the first point, Simio is a DES leader in data integration providing users with several data connectors and binding options to import data when, and from virtually wherever you would like. On the second point, Simio provides a wealth of resources to learn more about primary and foreign keys, establishing row references, and mapping object properties to table data. If these concepts are foreign to you, a quick research project on these topics may be a great benefit! For further inspiration, here are some additional benefits to data-driven modeling:

  1. Precision and Realism:

Data-driven modeling allows simulation professionals to create models that closely mimic real-world scenarios. By incorporating actual data from the operational environment, Simio users can ensure that their simulations accurately reflect the intricacies of their systems. This precision is crucial for making reliable predictions and identifying areas for improvement in processes.

  1. Improved Decision-Making:

Informed decision-making is the backbone of successful organizations. Data-driven simulation models enable stakeholders to evaluate various scenarios and assess the impact of different decisions before implementation. With Simio’s capabilities, users can analyze how changes in variables, resources, and parameters affect the overall performance of their systems, empowering the users to make strategic decisions that drive efficiency and productivity.

  1. Enhanced Flexibility:

Relational data in Simio allows for seamless integration of external data sources, enabling dynamic and flexible simulations. This feature is particularly beneficial for industries where data continuously evolves over time. Users can link Simio models to databases, spreadsheets, and/or other systems, ensuring that the simulation stays current and adaptable to changing circumstances.

  1. Time and Cost Savings:

Utilizing data-driven modeling in Simio can significantly reduce the time and resources required for simulation development. By leveraging existing data and relationships, users can streamline the model-building process, accelerating project timelines and ultimately saving costs. This efficiency is crucial for organizations aiming to stay competitive in fast-paced markets.

  1. Optimized Resource Allocation:

Simio’s support for relational data allows users to allocate resources more effectively within their simulations. By modeling relationships between entities, such as tasks and workers, users gain insights into the most efficient allocation strategies. This optimization leads to improved resource utilization, reduced bottlenecks, and enhanced overall system performance.

  1. Continuous Improvement:

The iterative nature of simulation modeling enables organizations to embrace a culture of continuous improvement. With Simio’s data-driven approach, users can easily update and refine models based on new data or changing operational parameters. This adaptability ensures that simulations remain relevant and contribute to ongoing optimization efforts.

Learn More About Simio

For in-depth perspectives about Simio’s technology, visit our Whitepaper Library.