Case Study 1 - Session Calculation Advance Test

Requirement 

Calculate  

1. Number of Sessions 

Write in your own words

1. Why is your answer correct or wrong?

2. List down exact steps and factors you accounted for getting to that answer?

3. Have you missed any step or not take into account any factor?

How are you being judged?

1. The solution should be broken into steps. Not one big Measure of a Wrong Answer.

   1. By steps here we mean - It should be broken into multiple columns/measures.

   2. It should clearly demonstrate why you did each step to understand your thinking.

      
      

2. You are being judged on QC. Meaning Quality Check. Meaning, "How well have you cross-checked if the answer shown is a correct answer."

   
   

3. You are being judged on how good can you think that surface level calculations is not the correct way to complete a project and is clearly not acceptable in DataRoars.

   
   

Note on the Data

1. "Data" table is the fact table. It has got date time and user id. The Date and Time columns can give you the timestamp of each and every interaction. 

2. If the idle time for a user’s continuous timestamp is greater than 10 minutes or 600 seconds then it counts as a new session. 

Download the assignment (pbix file)

Download

Session definition - In simple terms: 

A session on a website or app is like a single visit or interaction period by a user. 

Imagine walking into a store: 

• Entering the store = Starting a session 

• Browsing products, talking to staff, and making a purchase = Actions within the session 

• Leaving the store = Ending the session 

On a Website or App: 

• A session starts when you open the website/app. 

• It continues while you're clicking, scrolling, or interacting with it. 

• It ends when you close the tab, log out, or stay inactive for a certain period (like 10 minutes). 

  
  

In short, a session tracks everything you do during one visit.