Through the process of learning dimensional model design we’ll also dig deeper into more complex concepts like degenerate, junk, and role-playing dimensions. You’ll also learn how to design the different variations of Fact tables including: transactional, periodic, and accumulating snapshot.
If your business requires more complex relationships like many-to-many or parent-child relationships, this course will guide you through the process of solving these problems as well. We’ll also cover how to talk with the business, explain the business process and how to translate the business process into a dimensional design.
This course is taught by one of our experts on data modeling, Mitchell Pearson. If data modeling is new to you or maybe you’re self-taught and need to affirm the concepts you’re implementing are correct, then this course is for you.
Don't forget to check out the Pragmatic Works' on-demand learning platform for more insightful content and training sessions on Data Modeling and Microsoft applications. Be sure to subscribe to the Pragmatic Works YouTube channel to stay up-to-date on the latest tips and tricks.
Click below to start your 7-day free trial now.