Video Course Landingpage

Today’s BI is more than just loading data and creating dashboards. It’s about understanding how business value is created, and designing data models that truly support analysis, decisions, and growth.

BI Modeling in a nutshell is your compact, practical course in business-first data modeling. Whether you’re building your first star schema or refining a scalable core warehouse, this course helps you master the path from business process to digital data asset.

Course Modules

Why Modeling Matters – Introduction to the modeling mindset
Entity Relationship Modeling – Structure the business world
Multidimensional Modeling – Dimensions, facts, and KPIs
Star Schema Design – Clear, analytical data structures
Historization – Keep track of change over time
Core Data Warehouse Concepts – Scalable, flexible architectures
Wrap-Up – Connecting business processes to BI success

What You’ll Learn

How to translate business processes into business objects into Entities
Laying foundations for scalable Core Data Warehouses (3NF, Data Vault, hybrid)
Managing change with Historization & Slowly Changing Dimensions

What makes this course special:

Many BI professionals struggle to bridge the gap between business needs and technical solutions, leading to models that are hard to scale, explain, or maintain. This course puts modeling at the center of BI success.
You’ll learn how to move from business process to structured data models that actually support analysis, decisions, and change. It’s fast, focused, and grounded in real-world practice.

Read what enthusiastic customers say here:

Training sessions / workshops / direct collaboration in projects have always shown Dr. Hahne's expertise and extensive experience and have had an extremely positive influence on our projects. Openness and fairness in personal contact were always a matter of course.
Lars Giesler
Mr. Hahne has integrated seamlessly into our existing processes and teams and has always worked in a goal-oriented manner. Thanks to his many years of experience, he has always been able to support us with advice and action on both an operational and strategic level. Particularly noteworthy is his ability to come up with innovative solution options for various problems by mutual consensus. This has not only made collaboration significantly easier, but has also significantly improved the quality of the results.
Marcel Stasik
The seminars with Dr. Hahne laid the foundation for my knowledge of BI, data warehouse and analytics. He was able to supplement complex relationships with easily understandable analogies and always addressed questions from the course pragmatically and with practical examples. He always encouraged me to change my perspective or ask the question differently, which is an essential skill in BI: to think about different roles. With his knowledge of the "SAP world" (SAP BW) and also the classic DWH (Kimball, DataVault), both technically and conceptually (e.g. ADAPT) coupled with his open, friendly manner, the course was very helpful for me: I am still building on this knowledge today.
Patrick Schmitz
Since I already knew Dr. Michael Hahne from some of his publications in the data modeling environment, I also attended a training course on this topic with him in 2020. This gave rise to the idea of involving him in a new conception of our data warehouse architecture as a trainer, consultant and coach, which was then successfully implemented in 2022. I value Michael very much for his comprehensive expertise in the field of BI analytics, his pragmatic advice and his open, authentic manner. That is why we continue to work together as partners.
Lars Schreiber
Pepperl + Fuchs SE

Why this course is right for you:

Business Intelligence success starts with smart modeling, yet many data initiatives struggle due to unclear structures, mismatched models, and a disconnect between business and data. In this course, you’ll learn how to design meaningful, scalable models that reflect real business processes and support long-term success. With our clear, business-first approach, you’ll avoid common pitfalls and build a strong foundation for sustainable, value-driven BI.