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

m_anst
m_anst
What Does Success Look Like? I challenge Business Analysts to view requestors’ requirements as an opportunity to define success. Too often, teams fall into a trap focused on requestors’ prescriptive requirements that are meant to serve as roadmaps for developers and testers. When you limit your view of requirements to this prescripti...
0 Responses
Mariya Kotsupalova
Mariya Kotsupalova
They say the best criteria of Business Analyst’s success are a happy customer (business) and a happy engineering team. But what does it mean? How can we break down happiness and measure it? These are precisely the questions my 8 BAs team and I tried to answer this year. The result was a surprisingly efficient pair of surveys we developed and ...
0 Responses
Rajesh-N
Rajesh-N
Explore the Benefits of RPA's Adoption Across Segments In the past few years, we have seen steady growth in Robotic Process Automation (RPA). It gathered momentum in 2019 and became a hot topic in IT and business circuits in 2020. The power of process automation will be felt even more strongly, propelling its adoption as a replacement f...
0 Responses






Copyright 2006-2020 by Modern Analyst Media LLC