Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

jt0803aa
New Contributor

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

Re: best way to arrange my data - star schema

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
jt0803aa
New Contributor

Re: best way to arrange my data - star schema

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



Re: best way to arrange my data - star schema

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
jt0803aa
New Contributor

Re: best way to arrange my data - star schema

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