Data Warehousing: How to Create a Star Schema from Relational Schema?

Описание: This video is recording of part of my class, explaining how to create a Star Schema in Data Warehouse. Here is the learning outcome:
Using a real-world example to build a simple star schema, starting from the ER model and relational schema.
Multidimensional Modeling
Learning Fact and Dimension tables
Star Schema with Multiple Facts

We used ERDPLUS to create the star Schema because it is Free and easy to use. You can even create star schema without creating an account, but I'd recommend to sign up because then you can save your diagrams and access them later. Here is the link: https://erdplus.com