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.
Course taught by expert instructors
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.
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
Try these prep courses first
- Learn
- Fundamentals and vocabulary of data modeling
- Simple but powerfully document relationships in your data ecosystem
- Data Bus Matrix
- Database documentation
- Learn
- Frameworks for approaching data modeling problems
- Involving business partners in the data modeling process
- Conceptual/Logical Data Model
- Entity Relationship Diagram
- Learn
- Build a consistent and definitive reporting structure that can be easily queried by business partners
- Wireframing
- Entity Relationship Diagram
- Pseudo SQL queries
- Learn
- 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.
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.
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.
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!
