Website audit --Web analytics using qliksense

[Anonymous]

Hi,

Help me come up with the dashboard design

I'm new to qliksense and the task i have is to create the dashboard for analyzing the users and usage

below is just example

Users:

A dashboard should give a How many users are active 

Total users count-

Sessions:

Table view

Which user -- on which module (main link-), # of hits ---per day basis

                     -- No of screens(sub link) and which screen and url

(total # of hits of each hit on Screen and Screens)

condition for joining three tables

select distinct yser_id from USERS  a,  U_LOGINS  b, USAGE_METRICS  c

join on a,userid=b.serid  and b.SESSION_ID = c. session_id

below are the columns used.

Users	U_logins	Usage_metrics
userID	login seq id	metrics_id
FN	userID	Audit_time
LN	login time	remote_ip
created_date  //access given to user to login to website	created by			logout time	remote host
last_update date	login_ip	url
last_updated_by	session_id	module name // first link
user_band	status	screen name // second link
title	appid	response time
active		userID
location		sessionID //
location address		Referer
location type

[Anonymous]

Hello,

So to get the monthly active users, you can do a count distinct on the user ID by creating a year(login time) & "- "& month( login time).

So basically you would have a dimension called month(Login Time) and a measure count(DISTINCT userID)

You can also do as a dimension class(login seq id, 5) to group the number of times they have logged in, add location, and verify on status active.

On the url,  I guess this is the entry url and referrer url, you can do the same with count (distinct sessionID) you understand how many visits landed into your site by entry url or by referrer as dimensions.

To understand how many users come back to your site, repetead visits, you would check how many userID contain more than one sessionID.  You could also check the time between sessionID to understand if they come back on the same day or different days.

Here is an example of Google analytics.

[Anonymous]

users table is the all the users

User_logins is the one  has licence holders and usage matrics shows the logged

License holders that have not logged in within the period of report - (running report

   License holders that have never logged in within 90 days - (running report)