Dec 11, 2023

8 example projects to master real-time data engineering

Looking to hone your real-time data engineering skills? Here are 8 end-to-end projects (with code) to help you learn and advance.
Cameron Archer
Product Marketing Manager

Whether you're an experienced data engineer or just starting your career, you must keep learning. It's more than just knowing the basics like how to build a batch ETL pipeline or run a dbt model; you need to adopt skills based on where the field is headed, not where it currently stands.

If you want to add forward-looking skills to your resume, real-time data engineering is a great place to focus. By gaining experience with real-time data tools and technologies like Kafka, ClickHouse, Tinybird, and more, you'll develop in-demand skills to help you get that promotion, land a new gig, or lead your company to build new use cases with new technology.

If you want to add forward-looking skills to your data engineering resume, try learning how to work with real-time data.

In this blog post, you'll find 8 real-time data engineer projects - with source code - that you can deploy, iterate, and augment to develop the real-time data engineering skills that will advance your career.

But first, let's cover the basics.

What is real-time data engineering?

Real-time data engineering is the process of designing, building, and maintaining real-time data pipelines. These pipelines generally utilize streaming data platforms and real-time analytics engines and are often built to support user-facing features via real-time APIs. 

While "real-time data engineering" isn't necessarily a unique discipline outside the boundaries of traditional data engineering, it represents an expanded view of what data engineers are responsible for, the technologies they must understand, and the use cases they need to support.

Real-time data engineering isn't a unique discipline, but rather an expansion of scope and skills on top of traditional data engineering.

What does a real-time data engineer do?

Real-time data engineers must be able to build high-speed data pipelines that process large volumes of streaming data in real time. In addition to the basics - SQL, Python, data warehouses, ETL/ELT, etc. - data engineers focused on real-time use cases must deeply understand streaming data platforms like Apache Kafka, stream processing engines like Apache Flink, and real-time databases like ClickHouse, Pinot, and/or Druid.

They also need to know how to publish real-time data products so that other teams within the organization (like Product and Software) can leverage real-time data for things like user-facing analytics, real-time personalization, real-time visualizations, and even anomaly detection and alerting.

What tools do real-time data engineers use?

Real-time data engineers are responsible for building end-to-end data pipelines that ingest streaming data at scale, process that data in real-time, and expose real-time data products to many concurrent users.

Real-time data engineers lean heavily on streaming data platforms, stream processing engines, and real-time OLAP databases.

As a real-time data engineer, you'll be responsible for building scalable real-time data architectures. The main tools and technologies used within these architectures are:

  1. Streaming Data Platforms and Message Queues. Apache Kafka reigns supreme in this category, with many managed versions (Confluent Cloud, Redpanda, Amazon MSK, etc.). In addition to Kafka, you can learn Apache Pulsar, Google Pub/Sub, Amazon Kinesis, Rabbit MQ, and even something as simple as streaming via HTTP endpoints.
  2. Stream Processing Engines. Stream processing involves transforming data in flight, sourcing it from a streaming data platform, and sinking it back into another stream. The most common open source stream processing engine is Apache Flink, though other tools like Decodable, Materialize, and ksqlDB can meet the need.
  3. Real-time OLAP databases. For most real-time analytics use cases, traditional relational databases like Postgres and MySQL won't meet the need. These databases are great for real-time transactions but struggle with analytics at scale. To be able to handle real-time analytics over streaming and historical data, you'll need to understand how to wield real-time databases like ClickHouse, Apache Pinot, and Apache Druid.
  4. Real-time API layers. Real-time data engineering is often applied to user-facing features, and it might fall on data engineers to build real-time data products that software developers can utilize. While API development is often the purview of backend engineers, new real-time data platforms like Tinybird empower data engineers to quickly build real-time APIs that expose the pipelines they build as standardized, documented, interoperable data products.

Below is a table that can help you understand the types of tools and technologies that you'll use for real-time data engineering that expand upon a traditional data engineering stack.

Of course, these lists aren't mutually exclusive. Data engineers are called upon to perform a wide range of data processing tasks that will invariably include tools from both of these toolsets.

TRADITIONAL DATA ENGINEERING REAL-TIME DATA ENGINEERING
Coding Languages & Libraries
  • Python
  • Pandas
  • Polars
  • SQL
  • Scala
Streaming Data Platforms and Message Queues
  • Apache Kafka
  • Apache Pulsar
  • Redpanda
  • Confluent Cloud
  • Amazon Kinesis
  • Amazon MSK
  • Google Pub/Sub
  • RabbitMQ
  • Amazon SQS
Distributed Computing
  • Apache Spark
  • Apache Hive
Stream Processing Engines
  • Apache Flink
  • Kafka Streams
  • ksqlDB
  • Apache Beam
  • Google Cloud Dataflow
Traditional Databases
  • Postgres
  • MySQL
  • Apache Cassandra
  • MongoDB
Real-time OLAP Databases
  • Tinybird
  • ClickHouse
  • Apache Pinot
  • Apache Druid
Orchestration
  • Apache Airflow
  • Dagster
  • Prefect
Real-time Data Platforms
  • Tinybird
Cloud Data Warehouses/Data Lakes
  • Snowflake
  • Google BigQuery
  • Amazon Redshift
  • Azure Synapse Analytics
  • Databricks
API Development
  • FastAPI
  • Express.js
  • Hyper
  • Gin
  • Tinybird
Object Storage
  • Amazon S3
  • Azure Blob Storage
  • Google Cloud Storage
Business Intelligence
  • Looker
  • Tableau
  • PowerBI
  • Redash
Data Modeling
  • dbt
  • Fivetran
Customer Data Platforms
  • Segment
  • Amplitude

A list of end-to-end real-time data engineering projects

Looking to get started with a real-time data engineering project? Here are 8 example projects to get you started. For each one, we've linked to various resources including blog posts, documentation, screencast, and source code.

Build a real-time data analytics dashboard

Real-time dashboards are the bread and butter of real-time analytics. You capture streaming data, build transformation pipelines, and build visualization layers that display live, updating metrics. These dashboards may be for internal, operational intelligence use cases, or they may be for user-facing analytics.

Build a real-time dashboard step by step

Here are some real-time dashboarding projects you can build:

  1. Build a real-time dashboard with Tinybird, Tremor, and Next.js
    1. Blog Post
    2. GitHub Repository
  2. Build a real-time Python dashboard with Tinybird and Dash
    1. Blog Post
    2. GitHub Repository
  3. Build a real-time web analytics dashboard
    1. Blog Post
    2. GitHub Repository

Build a real-time anomaly detection system

Anomaly detection is a perfect use case for real-time data engineering. You need to be able to capture streaming data from software logs or IoT sensors, process that data in real time, and generate alerts through systems like Grafana or Datadog.

Build a real-time anomaly detection algorithm with SQL

Here is a real-time anomaly detection project you can build:

  1. Build a real-time anomaly detector
    1. Blog Post
    2. GitHub Repo
  2. Use Python and SQL to detect anomalies with fitted models
    1. Blog Post
    2. Google Collab Notebook
  3. Create custom alerts with simple SQL, Tinybird, and UptimeRobot
    1. Live Coding Session

Build a website with real-time personalization

Real-time personalization is a common application for real-time data engineering. In this use case, you're building a data pipeline that analyzes real-time web clickstreams from product users, comparing that data against historical trends, and providing an interface (such as an API) to provide a recommended or personalized offer to the user in real time.

Real-time Personalization

Here's a real-time personalization project that you can build:

  1. Build a real-time personalized eCommerce website
    1. Live Coding Session
    2. GitHub Repo

Build a real-time fraud detection system

Fraud detection is classic real-time analytics. You must capture streaming transaction events, process them, and produce a fraud determination - all in a couple of seconds or less.

Building and visualizing real-time fraud prevention

Here's an example real-time fraud detection project you can build:

  1. How to build a real-time fraud detection system
    1. Blog Post
    2. GitHub Repo

Build an IoT analytics system with Tinybird

IoT sensors produce tons of time series data. Many real-time data engineers will be tasked with analyzing and processing that data for operational intelligence and automation.

Here's an example IoT analytics project for you to build:

  1. Build a complete IoT backend with Tinybird and Redpanda
    1. Live Coding Session
    2. GitHub Repo (1 and 2)

Build a real-time API layer over a data warehouse

Cloud data warehouses are still the central hub of most modern data stacks, but they're often too slow for user-facing analytics. To enable real-time data over a cloud data warehouse, you need to export it to a real-time data store.

Build a real-time dashboard over BigQuery

Here's an example of building a real-time dashboard over BigQuery by first exporting the data to Tinybird:

  1. Build a real-time dashboard over BigQuery with Tinybird, Next.js, and Tremor
    1. Blog Post
    2. GitHub Repo
  2. Build a real-time speed layer over Snowflake
    1. Live Coding Session

Build a real-time event sourcing system

Event sourcing is classic real-time data engineering. Rather than maintain state in a traditional database, you can use event sourcing principles to reconstruct state from an events stream. Event sourcing has a number of advantages, so it's a great project for aspiring real-time data engineers.

Event sourcing with Kafka

Here's an example event-sourcing project:

  1. A practical example of event sourcing with Apache Kafka and Tinybird
    1. Blog Post (with code)

Build a real-time CDC pipeline

Change data capture shouldn't be new to most data engineers, but it can be used as a part of a real-time, event-driven architecture to perform real-time analytics or trigger other downstream workflows.

Real-time change data capture with Postgres

Here are some example real-time change data capture pipelines you can build for three different databases:

  1. A practical example of real-time CDC with Postgres
    1. Blog Post
  2. A practical example of real-time CDC with MySQL
    1. Blog Post
  3. A practical example of real-time CDC with MongoDB
    1. Blog Post
Do you like this post?

Related posts

Real-time data platforms: An introduction
How to do Real-time Data Processing
Real-Time Data Ingestion: The Foundation for Real-time Analytics
Real-time streaming data architectures that scale

Tinybird

Team

Jul 21, 2023
Tinybird is out of beta and open to everyone
Real-Time Analytics: Examples, Use Cases, Tools & FAQs

Tinybird

Team

Mar 17, 2023
What is the best database for real-time analytics?
Using Tinybird for real-time marketing at Tinybird
Why iterating real-time data pipelines is so hard
Real-time Databases: What developers need to know

Build fast data products, faster.

Try Tinybird and bring your data sources together and enable engineers to build with data in minutes. No credit card required, free to get started.
Need more? Contact sales for Enterprise support.