Question
From a website analytics system, you receive data extracts about user interactions such as downloads, link clicks, form submissions, and video plays.
The data contains the following columns:
| Name | Sample value |
| --- | --- |
| Date | 15 Jan 2021 |
| EventCategory | Videos |
| EventAction | Play |
| EventLabel | Contoso Promotional |
| ChannelGrouping | Social |
| TotalEvents | 150 |
| UniqueEvents | 120 |
| SessionsWithEvents | 99 |
You need to design a star schema to support analytical queries of the data. The star schema will contain four tables including a date dimension.
To which table should you add each column? To answer, select the appropriate options in the answer area.
Explanation
EventCategory goes in DimEvent, because it is a descriptive attribute of the event, alongside EventAction and EventLabel. It describes what happened rather than when or through which channel.
ChannelGrouping goes in DimChannel, because it describes how the visitor arrived, and it is the descriptive attribute that table exists to hold.
TotalEvents goes in FactEvents, because it is a numeric measure that is aggregated in queries. Measures belong in the fact table, and dimensions hold the attributes used to filter and group them.
