Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi guys ,
Would appreciate some help, I’m new to qlik sense and I’m not sure what would be the best way to arrange my data into a star schema.
Here are my tables:
1) pages - holds data on all page visits (every page a visitor clicked on during his visit to the website)
2) sessions - holds data on sessions (e.g each time visitor has visited the website)
3) countries - list of the counties
4) session_users - list of the users and attributes
5) daily aggregated table based on the tables above
thanks
pages |
user_id |
session_id |
visitor_id |
session_country_id |
page |
website_type |
visitor_type |
seniority |
page_number |
end_date |
sessions |
user_id |
session_id |
visitor_id |
visit_country_id |
operating_system_id |
days_since_first_session |
session_start_date |
session_end_date |
is_returning |
session_user |
user_id |
signup_date |
account_user_id |
purchase_date |
countries |
country_id |
country_name |
session_user |
user_id |
signup_date |
account_user_id |
purchase_date |
daily aggregated table |
date |
num_of_visitor |
num_of_users |
num_of_sessions |
avg_num_of_pages |
advanced |
pricing |
What's the difference between a visitor and a user?
What's the difference between session_country and visit_country?
visitor - Anyone who has visited the website
user - After the visitor is registered , he is assigned the user_id
no difference between session_country and visit_country
Ok, then I reckon you can drop the user_id, visitor_id and session_country_id fields from the Pages table. And replace visit_country_id in the Sessions table with the country name using a mapping table and the applymap function. The tables Pages and Sessions will be linked by the session_id field and the Sessions and Session_user table by the session_user_id field. The daily aggregated table will be a data island and not connected to any other table.
think i need to change the tables to dims and facts first