The Fellowship of the Star Schema: Transforming OLTP Data for Power BI

Speaker: Kristyna (Hughes) Ferris

Summary: One does not simply build reports on OLTP data. Join us on an epic journey from the depths of raw, normalized tables to the shining halls of a well-modeled star schema fit for Power BI greatness. We’ll demystify the differences between OLTP and OLAP, reveal the secrets of dimensional modeling, and show you how to forge relationships (and maybe even a few Slowly Changing Dimensions) that rule them all. Whether you’re a data wizard, a curious hobbit, or somewhere in between, you’ll walk away with practical techniques to build models that are as powerful as the One Ring but far less corrupting.