Data Warehousing
Design and build a data warehouse with dbt, Snowflake, or BigQuery.
0%
Confidence · no data yet
After this skill you can…
- Model a star schema with dbt
- Optimise BigQuery queries with partitioning and clustering
- Implement data quality tests in dbt
Prerequisites
Watch (10 videos)
Simplifying Medallion Implementation with Materialized Views in Fabric | DEM566
→ Implement data warehouses with Materialized Views→ Optimize data transformations with Spark SQL
Integrate your data lake with Amazon Redshift for powerful insights (Hebrew)
→ Integrate Amazon Redshift with a data lake→ Run complex analytical queries
SCD Type 2 in Fabric Warehouse With Surrogate Keys (Kimball Pattern)
→ Implement SCD Type 2 in Fabric Warehouse→ Use surrogate keys in Fabric Warehouse
AI-Ready Data on Databricks: How TK Elevator Uses Context and Meaning to Make AI Agents Work
→ Create AI-ready data on Databricks→ Process IoT telemetry data for AI agents
Start Building with Amazon Redshift's New Features - AWS Virtual Workshops
→ Build a petabyte-scale data warehouse with Amazon Redshift→ Run real-time analytics on data with Amazon Redshift
Want Peace of Mind? Here's How to Back Up ALL Your Clio Manage Data (Clio Manage Data Escrow)
→ Set up automatic backups of Clio Manage data→ Ensure data escrow for law firms
Transfer your Mainframe Data to GCP BigQuery using Google's Mainframe Connector
→ Transfer mainframe data to BigQuery→ Set up a data warehouse
Modernize Your Data Warehouse with Amazon Redshift - AWS Online Tech Talks
→ Design a scalable data warehouse with Amazon Redshift→ Run queries across large datasets
What's New with AWS Lake Formation: Securing and Governing Your Data Lake - AWS Online Tech Talks
→ Build and secure data lakes with AWS Lake Formation→ Optimize data governance with Governed Tables
How IHG Hotels modernize through a Teradata to BigQuery migration
→ Migrate data to cloud storage→ Optimize data analytics workflows
Read (10 articles)
📄
DeepCamp AI