I will make Source System Analysis based on my Bus Matix
DATE it is firs Dimension from bus matrix
I will use TRCK_TrackingWebsiteSystem field TRCK_UTCDateTimeCreated to get Date measure.
Please see first two pictures below.
To get PAGE dimension we can use three tables:
KEYWORD is the third dimension on bus matrix
there are two tables containing keyword:
COUNTRY fourth dimension can be taken from dbo.IP2Country from Field IPCountry
Please see below.
Next fifth dimension WEBSITE exist with two tables:
If PageURL and PreviousPageURL contain the same data
then it is Internal Visit otherwise it is External Visit.