h3xagnh3xagn
  • blog
  • about
  • x
  • reddit

azure

Data Engineering

Designing a modern industrial data stack – Part 1

With the increased need to extract and analyse data over the last couple of years and the convergence of OT and IT systems, new possibilities are available to improve the traditional industrial data stack. This has the potential not just to make data available securely, but also reduce complexity, latency, Read more

By Coenraad Pretorius, 1 yearJune 5, 2025 ago
Data Engineering

Extract dark data from SQL Server

Many systems exist today that were simply not optimised for time-series data analysis and machine learning. People may not even know the data is being collected regularly as part of day-to-day operations. This is often referred to as dark data. As the hunger for data increases, data engineers are tasked to make this dark data available.

By Coenraad Pretorius, 4 yearsAugust 21, 2022 ago
Data Engineering

Building an ETL pipeline from device to cloud (bonus part) 

Over this six plus one blog series we covered many different technologies and integrations, as we built our data pipeline. While there are standard patterns we can often use, sometimes we need to be able to flexible and use what is available.

By Coenraad Pretorius, 4 yearsMay 14, 2022 ago
Data Engineering

Building an ETL pipeline from device to cloud (part 6)

In this part we set up our big data platform, Azure Data Explorer, and create ingestion events to continually ingest our transformed data. Finally, we add context to our data by creating a data model and exporting it to our data lake.

By Coenraad Pretorius, 4 yearsMay 7, 2022 ago
Data Engineering

Building an ETL pipeline from device to cloud (part 5)

We discuss the importance of proper data management upfront and the need to always be in control of data sharing. We send the appropriate data automatically to our vendor via an Azure Function App.

By Coenraad Pretorius, 4 yearsApril 30, 2022 ago

Posts pagination

1 2 Next

Recent Posts

  • Designing a modern industrial data stack – Part 2November 8, 2025
  • Designing a modern industrial data stack – Part 1June 5, 2025
  • Blazingly fast dashboards with InfluxDBMay 24, 2025
  • Optimising my clevrHome energy consumptionJune 24, 2024
  • Building a home energy monitoring dashboard for your clevrHomeJune 11, 2024

Categories

  • Data Engineering
  • Data Science
  • Energy Efficiency
  • Internet of Things

Don’t miss another post

We don’t spam! You can unsubscribe anytime.

Check your inbox or spam folder to confirm your subscription.

  • blog
  • about
  • x
  • reddit
Hestia | Developed by ThemeIsle