Forums for the Business Analyst

 
  Modern Analyst Forums  Business and Sy...  General  Ways to extract a metric?
Previous Previous
 
Next Next
New Post 6/17/2020 10:33 AM
Unresolved
User is offline eci
1 posts
No Ranking


Ways to extract a metric? 

Hi,

I have a business dataset, which has a few columns:

 DeviceModel, DeviceSN, Bin, DurationInMin

The DurationInMin tells how long the device stay in each Bin. The range of Bin is from 1 to 20.  Normally most devices stay in the lower bin for a long time. We want to know the difference of the duration in each bin by each device model. 

What's the best way to find a metric to find the distribution of the data?  My first attempt is to calculate percentage of time each device spend in each bin, then sum it up by bin. The cons for this method is if  we have devices always stay in one bin for long time, it will blow up our data. I need help with finding other ways help with this problem.

 

Thanks,

 Eci

 

 

 

 

 

 

 

 
Previous Previous
 
Next Next
  Modern Analyst Forums  Business and Sy...  General  Ways to extract a metric?

Community Blog - Latest Posts

How to Write Business Analyst Resume
Business analysts must have an up-to-date, visually appealing resume to be able to stand out from the competition. A strong business analyst resume should accurately reflect your skills, experience and qualifications while also highlighting your accomplishments and successes. We will provide invaluable advice on how to build a strong, effective bus...
Are you testing your product in the most effective way?
Today covid-19 pandemic has completely flipped the business model. Various conventional Business models like banking and health had to adopt the digital era. Even the school and colleges have to create various applications so that they can provide online learning for their students. All these statements justify the modern business model as complete...
Offshore development has become an increasingly popular model for businesses looking to expand their reach and reduce costs. With this model, businesses can hire a team of developers located in a different country or continent, often in regions where labor is cheaper. However, managing an offshore development team can be challenging, especially ...

 






 

Copyright 2006-2023 by Modern Analyst Media LLC