Exploring Soda Data Quality Testing on Databricks

Use Case For my current engagement I’m tasked with developing an automated data quality framework for a large industrial enterprise in the renewable energy sector. The client has over a hundred independent SCADA systems from various vendors gathering energy production data. All this data has to flow in one central repository to be analyzed with Databricks. The client is obligated to ensure high data quality for contractual reporting to external parties. Failure to deliver incurs high financial penalties. ...

February 14, 2025

Developing a Qtile VPN Widget

I often work from WeWork, which is a public co-working space with a shared WIFI-network. Securing my connection For security and privacy reasons, I therefore work behind a VPN. I purchased an AirPVN subscription and configured it as an OpenVPN connection in NetworkManager1: NetworkManager’s terminal user interface nmtui This way, even if I’m working from Prague, my location will always be shown as Belgium2. This was important because my current enterprise client’s IT-security team kept receiving alarms that my location was changing all over Europe. ...

February 13, 2025

🎧 Smart Metals Podcast E13: From the Shop Floor to the Cloud: AI in Metal Manufacturing

In this episode of the Smart Metals Podcast Denis and I, dive into the topic of transferring shop floor data to the cloud and leveraging AI for predictive maintenance and other use-cases in the metals industry. We discuss essential components like the Unified Namespace (UNS) and Data-Centric AI, highlighting why smaller manufacturers shouldn’t shy away from cloud technology. We also break down common misconceptions about AI, particularly for SMBs, and explore the benefits of cloud services. You’ll hear a step-by-step approach to implementing predictive maintenance and get practical advice on how to start using AI-driven insights—without excessive costs or complexity. ...

January 31, 2025

🎧 Smart Metals Podcast E12: Navigating the Future of Factory Connectivity with Russ Waddell

This week at Smart Metals Podcast, we, the hosts Denis Gontcharov and Luke van Enkhuizen, had a fascinating conversation about the future of factory connectivity with Russ Waddell, an expert in industrial connectivity. We explored the challenges of integrating manufacturing systems, the importance of cultural and technological shifts, and how to leverage AI and data science to unlock the full potential of manufacturing processes. We delved deeper into topics like the evolution of industrial connectivity, unified namespaces, and strategies for starting your digital transformation journey. If your current challenge is connecting your manufacturing systems, scaling digital projects, or understanding how to use your data effectively, then listen to this episode when you have a moment. ...

January 13, 2025

🎧 Smart Metals Podcast E11: Unifying Manufacturing with Unified Namespace: A Conversation with Brian Pribe

This week at Smart Metals Podcast, we, the hosts Denis Gontcharov and Luke van Enkhuizen, had a conversation about implementing Unified Namespace (UNS) in manufacturing environments with Brian Pribe, founder and president of MACH Controls LLC. We explored how to make advanced manufacturing technology accessible to businesses of all sizes. We delved deeper into practical implementation of UNS, the combination of MQTT and Kafka, and making these solutions affordable for smaller manufacturers. If your current challenge is connecting your manufacturing equipment or implementing a unified namespace solution, then listen to this episode when you have a moment. ...

November 25, 2024