h3xagnh3xagn
  • blog
  • about
  • x
  • reddit

python

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
Internet of Things

Give your cleverHome one voice

You have too many apps on your phone already and many smart home devices each come with their own app as well. We are going to unify these notifications and create our own customised messages via a Telegram bot for our cleverHome.

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

Create a streaming log viewer using FastAPI

Many times, you need to view the latest log entries generated by your app to check that everything is working or see what is currently broken. We will be creating a FastAPI app that will stream our latest log files entries over websockets.

By Coenraad Pretorius, 4 yearsJune 16, 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

Posts pagination

Previous 1 2 3 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