Excel operations in SQL: 40 examples
Excel is a great tool. I love it. But let’s say you want to play with lots of data from lots of different files, and you want to do a lot of operations on that data. Or maybe you need…
Category: Data science [EN]
Inventory simulation for optimized stock
Inventory optimization refers to reducing excess inventory, avoiding lost sales due to unavailability of items in stock, well-defined safety stocks and reorder points, and much more. In this article I demonstrate how simulation can be used to master the challenges…
Heuristic optimization in Python
Following the previous articles on interfaces (+) and (exact) solvers (+) for optimization in Python, in this article, I introduce some packages that provide an easy-to-use “interface” for artificially intelligent algorithms (AIAs) (e.g., heuristics, meta-heuristics, math-heuristics, learn-heuristics, hyper-heuristics, or sim-heuristics).…
Simmer in R for discrete-event simulation
There are various simulation techniques of importance to supply chain data analysis and modelling. One of them is discrete-event simulation. Discrete-event simulation is especially useful for higly dynamic and interdependent systems, as is often the case in complex manufacturing systems…
Monte-carlo animation with gganimate
In this article I implement a monte-carlo animation using gganimate in R. In one of my previous posts I introduced monte-carlo simulation. Monte-carlo simulation is one of the widely applied simulation techniques in supply chain management and operations management. I…