Sold out, but you can still join the waitlist!
Course logo

Data Modeling for the Modern Warehouse

This course provides an introduction to data modeling using concepts of the Kimball methodology. Students will learn to build scalable business intelligence systems given source data realities and business requirements. You will develop a vocabulary to describe the different elements of business processes, create artifacts to elucidate and document the business intelligence system, and learn how to handle common data modeling use cases. Though we have not designed the course to be tool specific, there will be references to dbt throughout.

Instructor profile photo
Eva Jaumann
Data Scientist at YNAB
US$ 400
or included with membership
Coming soon
Sold out, but you can still join the waitlist!

Course taught by expert instructors

Instructor Photo
Affiliation logo

Eva Jaumann

Data Scientist at YNAB

Eva is a versatile data professional with experience working in different industries and data teams of varying sizes. Through implementing a business intelligence system from scratch, she learned to value data modeling as a translator of business processes to data structures. This enables communication and collaboration between all different departments, leading to more informed decisions. She is excited to share her learnings with you!

The course

Learn and apply skills with real-world projects.

Who is it for?
  • New Analytics Engineers looking to formalize their data modeling philosophies.

  • Data Scientists, Business/Data Analysts, or Product Managers who want to bring some clarity to their data warehouse.

  • Intermediate SQL skills

  • Familiarity with relational databases

Not ready?

Try these prep courses first

  • Fundamentals and vocabulary of data modeling
  • Simple but powerfully document relationships in your data ecosystem
  • Data Bus Matrix
  • Database documentation
  • Frameworks for approaching data modeling problems
  • Involving business partners in the data modeling process
  • Conceptual/Logical Data Model
  • Entity Relationship Diagram
  • Build a consistent and definitive reporting structure that can be easily queried by business partners
  • Wireframing
  • Entity Relationship Diagram
  • Pseudo SQL queries
  • Work backwards from end reporting requirements to guide modeling processes
  • Strategies for dealing with common enterprise applications, including subscriptions and web events.
  • Integrate a new data source into an existing reporting structure

A course you'll actually complete. AI-powered learning that drives results.

AI-powered learning

Transform your learning programs with personalized learning. Real-time feedback, hints at just the right moment, and the support for learners when they need it, driving 15x engagement.

Live courses by leading experts

Our instructors are renowned experts in AI, data, engineering, product, and business. Deep dive through always-current live sessions and round-the-clock support.

Practice on the cutting edge

Accelerate your learning with projects that mirror the work done at industry-leading tech companies. Put your skills to the test and start applying them today.

Flexible schedule for busy professionals

We know you’re busy, so we made it flexible. Attend live events or review the materials at your own pace. Our course team and global community will support you every step of the way.


Completion certificates

Each course comes with a certificate for learners to add to their resume.

Best-in-class outcomes

15-20x engagement compared to async courses

Support & accountability

You are never alone, we provide support throughout the course.

Get reimbursed by your company

More than half of learners get their Courses and Memberships reimbursed by their company.

Hundreds of companies have dedicated L&D and education budgets that have covered the costs.


Course success stories

Learn together and share experiences with other industry professionals

Every analyst should take this course to understand how the data they query is modeled.

Jimmy LuongData Scientist, California State University

I enjoyed spending time getting to know data models with Miles and everyone in the course. I got to learn more about data modeling, its use in many business-focused exercises, and perspectives on its impact to real-world scenarios. I think what made this course unique was the added benefit of sharing this course with like-minded professionals and learning from them.

Stefano Cascavilla Data Engineering, Cloud Academy

I attended a data-modeling lecture by Miles where he went above and beyond to deliver a stellar learning experience for myself and 100+ other data professionals. He clearly understands the modern data stack and how to effectively model data in 2022. After the lecture, I followed up with several questions regarding career advice and was incredibly grateful when he took the time to understand where I was before thoughtfully answering each one.

Jason DexterAnalytics Engineer, Sr. Data Analyst

Miles’ contributions on data modeling for the dbt course have been so valuable and are always a hit each time he presents—he has a very practical and modern approach on how to model data in 2022!

Jake HannanSenior Analytics Engineer, Sigma Computing

Frequently Asked Questions

Still not sure?

Get in touch and we'll help you decide.