Using Joins and Group Bys the right way for data warehousing
- 1. Introduction
- 2. Joins & Group bys are two of the most commonly used operations in data warehousing
- 3. Conclusion
- 4. Recommended ...
Similar Articles (10 found)
🔍 69.8% similar
What is a Data Warehouse?
- 1. Introduction
- 2. Business requirements: dashboards and analytics
- 3. What is a data warehouse
- 4. OLTP vs OLAP based...
🔍 69.3% similar
How to improve at SQL as a data engineer
- 1. Introduction
- 2. SQL skills
- 3. Practice
- 4. Conclusion
- 5. Further reading
- 6. References
1. Intro...
🔍 65.3% similar
6 Steps to Avoid Messy Data in Your Warehouse
- 1. Introduction
- 2. Six Steps for a Clean Data Warehouse
- 2.1. Understand the business
- 2.2. Make d...
🔍 63.9% similar
Understanding Modern Databricks Warehousing for the AI era: A Beginner’s Guide
The journey from Warehouse to Insights
Navigation
INTRO
- Core Componen...
🔍 62.5% similar
How to quickly deliver data to business users? #1. Adv Data types & Schema evolution
- 1. Introduction
- 2. Use Schema evolution & advanced data types...
🔍 61.7% similar
Hi, fellow future and current Data Leaders; Ben here 👋
I recently was skimming the data engineering subreddit and came across a post with a title that...
🔍 61.6% similar
How to Join a fact and a type 2 dimension (SCD2) table
- Introduction
- What is an SCD2 table and why use it?
- Setup
- Joining fact and SCD2 tables
-...
🔍 61.4% similar
Data Engineering Interview Preparation Series #3: SQL
- 1. Introduction
- 2. Step-by-step process to solve any SQL interview question
- 3. Lead the co...
🔍 61.2% similar
How to ensure consistent metrics in your warehouse
1. Introduction
If you’ve worked on a data team, you’ve likely encountered situations where multipl...
🔍 60.8% similar
Advanced SQL is knowing how to model the data & get there effectively
- 1. Introduction
- 2. SQL techniques
- 3. Query optimization
- 4. Data modeling...