I am new to BI and qlikview

[#1]

This is my first post as a Qlikview BI Student. I have read so many content about data warehousing and their structures,  OLAP,star schemas, snowflake schemas, fact and dimension tables e.t.c  I have also practised the online lectures. I quite understand what BI and BW is all about. I also understand that a cube can have more than one fact table.  I have this relational database model  which is i got from one of the qlikview online tutorials. I would be happy if anyone can convert the relational model to a star schema model. I don't mind if you provide more variations of the star schema , such as modelling it to have more than one fact tables. Please click on the image below to see a bigger version. Thanks.

[miikkaqlick]

Hi!

Write script like this (pseudo code):

Fact:

Load *

From Orders;

Join

Load *

From OrderDetails

Join

Load *

From Shipments;

Join

Load *

From Shipper;

Customers:

Load *

From Customers;

Join

Load *

From Division;

Products:

Load *

From Products;

Join

Load *

From Categories;

Load also calendar, offices, employees and suppliers. Maybe you can map suppliers to fact -table. You can also join offices and employees.

Above will produce reasonable star schema.