Layering Your Data Warehouse

What’s a dbt?

What are “Data Layers”, and why use them?

#1 The Root Layer

#2 The Logic Layer

#3 The Dimension and Activity Layer
This layer is where we begin to surface data models for others to use and create their own analysis

#4 The Reporting Layer
The reporting layer is needed for all your analysis and visualization needs

Some Lessons Learned

--

--

--

Analytics Engineer currently working at Spotify.

Love podcasts or audiobooks? Learn on the go with our new app.

Recommended from Medium

The Data Economy is here. Now what?

Theoretical and Practical Aspects of Logistic Regression

The New School: How Machine Learning Levels Up from Traditional Modelling

Random Forest Algorithm

Normal Distribution — Properties, Z Scores, Area Under the Curve and Central Limit Theorem.

Gosloto 6–45 Morning Results: Wednesday 02 March 2022

Gosloto 6-45 Morning Results: Wednesday 02 March 2022

Telecom Churn Prediction — EDA

Inferential Statistics.

Get the Medium app

A button that says 'Download on the App Store', and if clicked it will lead you to the iOS App store
A button that says 'Get it on, Google Play', and if clicked it will lead you to the Google Play store
Mitchell Silverman

Mitchell Silverman

Analytics Engineer currently working at Spotify.

More from Medium

🥫Canned Reports vs. 🥣 Self-Serve Reporting

Real-time BI transactional systems

How a Major Manufacturer Creates Responsible Self-Service Data with Datameer

How Big Data Analytics and Data Management Can Fuel Business Growth