Friday, December 08, 2023
Dimensional Modeling Principles using Oracle SQL Developer Data Modeler
Most BI tools require a dimensional model but how do you go about designing that kind of model? What's a star schema, fact or dimension table? In this session we will start with the basics of dimensional modeling including a retail dimensional model example. Then we will take a look at building the model in Oracle SQL Developer Data Modeler. This free tool from Oracle has basically all of the same features as licensed data modeling tools. By the end of this session, you should be comfortable building a simple dimensional model in Oracle SQL Developer Data Modeler.
Michelle Kolbe, Oracle Ace
Michelle Kolbe is the Manager of Data & Insights at Backcountry.com. In this role she guides all business intelligence projects at Backcountry. She mentors her team to ensure team growth and learning, consistency, and "doing things the right way."
Michelle spent over 7 years at Intermountain Healthcare as a Senior Data Architect in their Enterprise Data Warehouse department. At Backcountry & Intermountain, she has overseen the requirements gathering, design, development and maintenance of numerous data warehousing projects.
Michelle is also an Adjunct Professor at the University of Utah teaching a senior level Relational Database course. This course covers data modeling and SQL on Oracle databases.
Michelle has a BS in Computer Science from Winona State University and an MBA from Utah State University. She currently serves as President for the Utah Oracle Users Group and also on the board of the Independent Oracle Users Group. She previously held a Board Position on the Healthcare Data Warehousing Association. Michelle also serves on the Advisory Council of the MIS Department at Utah State University and is a Contributing Editor on the Select Journal published by the Independent Oracle Users Group.
Michelle is recognized as an Oracle ACE and is a frequent speaker at conferences including Oracle OpenWorld, Collaborate, UTOUG, and the Oracle OTN Latin America Tour.