The Risk Map: Architecting an Obsolescence-Immune Data Foundation

1. The Flat Table Trap (Excel is Dead) Managing an industrial Bill of Materials (BOM) through spreadsheets is a structural deficiency. Excel provides a two-dimensional environment for a three-dimensional problem. Hardware engineering and manufacturing dependencies operate under a graph logic. When the procurement department receives an End of Life (EOL) alert for a component, calculating the volumetric impact by searching text across multiple static documents introduces operational latency. The UNE-EN IEC 62402:2019 standard, in its Clause 8.10 (Data Acquisition), establishes the requirement to maintain “a list of configuration sub items within an item” alongside “the identification of the items and sub items details: manufacturer, part number and specification”. Achieving the level of parametric traceability demanded by the standard requires the design of a relational data model. ...

April 18, 2026 · Datalaria

S&OP Engineering III: The End of Excel (Linear Programming for Supply Planning)

“We always want 4 weeks of coverage.” This phrase, repeated like a mantra in every S&OP meeting on the planet, is financially toxic. Why? Because it’s a fixed rule applied to a dynamic system. If your demand in January is 200 units and in July is 20, you’re forcing yourself to maintain 800 and 80 units respectively “just in case.” January falls short. July immobilizes capital for no reason. The alternative isn’t more sophisticated intuition. It’s mathematics. ...

March 13, 2026 · Datalaria

S&OP: Why Your Excel Is Lying to You (and How to Interrogate It with Python)

In S&OP (Sales & Operations Planning) meetings, opinions are often discussed instead of facts. “I think we’ll sell more”, “Last month was weird”. The root problem is not the lack of business vision, it’s the lack of signal integrity. Most supply chains are managed on spreadsheets that accept anything: dates as text, blank spaces, and typos that turn a 100-unit order into 100,000. When you feed your prediction algorithm with that “garbage,” you get amplified garbage (the financial Bullwhip effect). ...

February 28, 2026 · Datalaria

From Zero to Hero: Create a Cyberpunk Snake Game with Real-Time Ranking using Supabase and Vanilla JS

Remember classic Snake? We’ve brought it to the future with a Cyberpunk aesthetic and connected it to the cloud. In this ‘From Zero to Hero’ tutorial, you’ll learn to build ‘Neon Snake’ using Vanilla JS for the game and Supabase to persist scores in real-time, without needing a complex backend server.

February 14, 2026 · Datalaria