Cloud Agnostic Data Platform with DBT, Trino, Iceberg and MinIO
Explore a hands-on, cloud-agnostic data pipeline using TrinoDB, DBT, MinIO, and Apache Iceberg for scalable and lightweight analytics, suitable for both cloud and on-premise solutions.
DBT and Python - How to Write Reusable and Testable Pipelines
Develop reusable and testable data pipelines using DBT and Python. Learn best practices for version control, DAGs, and unit testing in SQL and Python-based models.
DAX Fundamentals in Power BI and Power Pivot - 2.5 Hour Course
Comprehensive tutorial on DAX fundamentals in Power BI, covering calculated columns, measures, context, functions, and advanced techniques for efficient data analysis and reporting.
Deeper BI Integrations with Databricks SQL
Explore advanced BI integrations for Databricks SQL, including seamless connections with Power BI and Tableau, data model syncing, and updates on drivers and connectors.
Data Warehousing Performance, Scale and Security with Databricks SQL
Explore high-performance data warehousing with Databricks SQL, focusing on scalability, security, and resource management for enterprise environments. Learn about latest advancements in scheduling and caching.
Snowflake Concepts and Architecture: Introduction to Cloud Data Warehousing
Explore Snowflake's architecture, benefits, and unique features for cloud-based data warehousing. Learn how it compares to other tools and implements in Azure.
Building Realtime Data Warehouses from Scratch - End-to-End Data Engineering Project
Design and implement a real-time data warehouse with Apache Airflow, Kafka, and Pinot. Create custom hooks, ingest batch and streaming data, and visualize evolving data using Apache Superset.
Extreme Self-Service: Turning Data Consumers into Data Constructors
Empower data consumers to create their own products with minimal training. Learn best practices, community building, SQL literacy promotion, and guard rail establishment for self-service analytics.
Behind the Hype - Architecture Trends in Data
Explore current data architecture trends with a seasoned engineer, cutting through industry hype to uncover underlying principles and ideals.
The Metadata-Driven Data Warehouse
Streamline data warehouse development using metadata-driven approaches. Learn efficient techniques for Insert/Update/Delete operations and pipeline management.
What's New and Cool in Azure Synapse Analytics
Discover recent updates and new features in Azure Synapse Analytics for end-to-end analytics, with practical demonstrations and scenario-based applications.
Breaking Out of the Habit of Bulk Loading Everything - Lessons from Streaming Data Integration
Explore transitioning from bulk loading to streaming data integration, leveraging Azure services for real-time analytics and long-term storage in data warehousing.
Building Tomorrow's Warehouse Today - Modern Data Warehouse Modelling Insights
Explore fundamental shifts in data warehousing architecture and processing design principles for modern, efficient data management and analysis.
Instancing to Curves with Grease Pencil and Geometry Nodes in Blender
Explore powerful instancing techniques in Blender, combining Grease Pencil and Geometry Nodes to create stunning snowflakes and flowers with randomized scales and animations.
Projectile Motion in Soccer Goal Scoring - Part 8
Explore projectile motion through soccer goal scoring, using VPython to simulate and analyze trajectories. Learn practical applications of physics in sports.
Serverless Scaling with BigQuery - Overview, Architecture and Real-World Applications
Discover BigQuery's enterprise data warehouse capabilities, from its serverless architecture to real-time streaming, machine learning integration, and practical marketing applications.
DuckDB: Features, Architecture, and Use Cases in Analytics
Dive into DuckDB's powerful analytics capabilities, architecture, and key features while exploring its unique syntax, connectors, and practical use cases in modern data analysis.
Reducing Complexity and Increasing Performance with Trino
Discover how Trino's distributed SQL query engine revolutionizes data processing, featuring new capabilities like table procedures, polymorphic functions, and modern SQL features for enhanced performance.
Building a Fully-Managed OSS-Compatible Lakehouse with BigLake Managed Tables
Discover how BigLake Managed Tables enhances open lakehouse formats by combining BigQuery infrastructure with OSS compatibility for improved data management, access control, and high-throughput streaming.
Meet MySQL RAPID - Distributed, In-Memory, Columnar, Query Processing Engine by ORACLE
Explore MySQL RAPID: Oracle's distributed, in-memory columnar engine for OLAP & OLTP workloads. Learn its architecture, data loading, and how it revolutionizes data warehousing and ETL processes.
Master Using SQL with Python - Create a Data Warehouse with SQLite
Learn to build a local SQLite data warehouse by extracting and transforming data from SQL Server and PostgreSQL, simplifying your data analysis workflow with Python.