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

Gen1us2k
Gen1us2k
Most of the IT projects imply constant cooperation between the team members and customers. Although it might be often overlooked, the role and the importance of the client within the project is very crucial. Thus, it is in your interest to build a strong relationship based on trust. However, gaining trust on a single occasion is not a dealmaker &md...
0 Responses
emorphistechno
emorphistechno
Introduction In today's world, most enterprises work aggressively to achieve a higher level of business growth, which is made possible by leveraging one of the best automation technologies. One such technology is Robotic Process Automation (RPA) that plays a vital role in streamlining the customer experience in the most profitable manner.&nb...
0 Responses
Nick Stowers
Nick Stowers
Introduction   When I was introduced to scrum, the burndown chart was a tool that was highly emphasised however I feel the purpose has changed from it being a tool to predict (to a certain level) timescales for delivery to a tool that measures a team’s productivity…..in other words, the focus is on the number of points clear...
0 Responses






Latest Articles

From an Intermediate to a Strategic Senior Business Analyst
Aug 09, 2020
0 Comments
It is strange how something that is supposed to be simple is actually so complex.  Something that is supposed to be a matter of linear career pro...
Copyright 2006-2020 by Modern Analyst Media LLC