Data Orchestration with Dagster
Learn Dagster's software-defined assets, ops, jobs, schedules, and sensors. Includes a practical comparison with Apache Airflow.
26 posts · page 1 of 1
Learn Dagster's software-defined assets, ops, jobs, schedules, and sensors. Includes a practical comparison with Apache Airflow.
Master hash, range, and list partitioning strategies. Learn to choose partition keys, avoid hot partitions, and scale your data systems.
Understand Apache Iceberg's architecture, schema evolution, time travel, and hidden partitioning. Learn why table formats matter for data lakes.
Learn real-time streaming architectures like Lambda, Kappa, CDC, and event sourcing. Understand when to choose streaming over batch processing.
Speed up Pandas code with vectorization, categorical dtypes, chunked reading, eval/query, PyArrow backend, and memory profiling techniques.
Replace sensor-based waiting with Airflow Datasets. Build producer-consumer DAGs, combine time and data triggers, and design dataset URIs for production.
Idempotent pipelines, backfilling, late data handling, error patterns, multi-environment setups, and common anti-patterns to avoid in Airflow.
Learn Apache Spark: RDDs, DataFrames, SparkSQL, the execution model, PySpark basics, platform comparisons, and essential performance optimization tips.
Prepare for data engineering interviews: SQL deep dives, Python coding, system design, data modeling, behavioral questions, and take-home project tips.
Learn the five pillars of data observability, anomaly detection, lineage tracking, incident response, and tools like Elementary, Monte Carlo, and Soda.
Build CI/CD workflows for data pipelines: lint SQL, validate DAGs, run tests, deploy dbt models, and manage dev/staging/prod environments.
Learn the data testing pyramid, unit testing transformations, contract testing between stages, and how to build reliable CI/CD test suites for pipelines.
Master dbt (data build tool): project structure, models, materializations, testing, Jinja templating, and how dbt became the standard for analytics engineering.
Master Kimball dimensional modeling: fact table types, advanced dimension techniques, the bus matrix, grain decisions, and a complete e-commerce example.
Learn what Apache Airflow is, why Airbnb created it, how DAGs work, and when to use Airflow for orchestrating data pipelines, ETL workflows, and ML operations.
Understand the difference between batch and stream processing, when to use each pattern, and how Lambda and Kappa architectures combine them.
Understand the differences between data lakes, data warehouses, and the modern lakehouse architecture — when to use each and how they work together.
A comprehensive guide to the modern data engineering tool landscape — ingestion, transformation, orchestration, storage, quality, and governance tools.
Learn Kimball, Inmon, and Data Vault modeling approaches for analytics — star schemas, normalized models, and modern patterns like the Activity Schema.
Learn the six dimensions of data quality, how to implement quality checks with Great Expectations and dbt, and the pillars of data governance.
Understand the difference between ETL and ELT pipeline patterns, when to use each, and how modern cloud warehouses changed the default choice.
Learn the fundamentals of data warehousing — star schemas, snowflake schemas, fact tables, dimension tables, and slowly changing dimensions with examples.
Understand what data engineers do, how they differ from data scientists, the core skills required, and why this role is one of the most in-demand in tech.
A practical introduction to Apache Kafka — what it is, why it exists, its core concepts, and how it differs from traditional message queues. Includes your first producer and consumer code.
Build serverless ETL jobs with AWS Glue. Learn the Data Catalog, crawlers, Spark and Python shell jobs, partitioning, bookmarks, and how to avoid surprise DPU bills.
Hands-on pandas patterns for cleaning messy real-world data, covering missing values, types, duplicates, strings, and a reliable cleaning pipeline.