4 Replies Latest reply: Dec 5, 2016 9:50 AM by Jonathan Tago RSS

    best way to arrange my data - star schema

    Jonathan Tago

      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