Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

best way to arrange my data - star schema

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

4 Replies
Gysbert_Wassenaar
Partner - Champion III
Partner - Champion III

What's the difference between a visitor and a user?

What's the difference between session_country and visit_country?


talk is cheap, supply exceeds demand
Anonymous
Not applicable
Author

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



Gysbert_Wassenaar
Partner - Champion III
Partner - Champion III

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.


talk is cheap, supply exceeds demand
Anonymous
Not applicable
Author

think i need to change the tables to dims and facts first