Phone number "Hot S...
 
Notifications
Clear all

Phone number "Hot Sheet" ideas?

8 Posts
4 Users
0 Reactions
1,943 Views
Styers
(@styers)
Eminent Member
Joined: 7 years ago
Posts: 27
Topic starter  

I am looking for a cost effective time efficient way to build a "hot sheet" of common contact numbers used by narcotics suspects.

Basically I download a lot of low level dealer phones and we have a ton of data but other than old fashion comparison i have not found a quick way to identify common contacts between them. I have messed around with spreadsheet pivot tables and that is as far as I have taken it. We are want to find "the big guy" hopefully by comparing all the low and mid level contacts we can locate a common source or two. Our area like many of you i am sure, has been hit by a lot of overdose deaths.

Wondering if any of you guys had any ideas or knew of a reasonable priced software that could help out. 

 

Thanks in advance, B. Styers


   
Quote
jaclaz
(@jaclaz)
Illustrious Member
Joined: 18 years ago
Posts: 5133
 

Something like this?:

http://www.molbiotools.com/listcompare.html

Loosely what you need is a Venn diagram generator, but usually they accept a limited number of lists, you may want to look for "intersection" on multiple lists or common data in multiple files and for "upset" diagrams:

https://asntech.github.io/post/time-to-make-venn-diagram-upset/

https://asntech.shinyapps.io/intervene/

jaclaz


   
ReplyQuote
(@trewmte)
Noble Member
Joined: 19 years ago
Posts: 1877
 
Posted by: @jaclaz

Something like this?:

http://www.molbiotools.com/listcompare.html

Loosely what you need is a Venn diagram generator, but usually they accept a limited number of lists, you may want to look for "intersection" on multiple lists or common data in multiple files and for "upset" diagrams:

https://asntech.github.io/post/time-to-make-venn-diagram-upset/

https://asntech.shinyapps.io/intervene/

jaclaz

@Styers the above are good ones highlighted by jaclaz.

You could also consider (but it has a charge) i2Base

https://www.ibm.com/uk-en/marketplace/data-management


   
ReplyQuote
jaclaz
(@jaclaz)
Illustrious Member
Joined: 18 years ago
Posts: 5133
 
Posted by: @trewmte

You could also consider (but it has a charge) i2Base

https://www.ibm.com/uk-en/marketplace/data-management

Yep, similar:

https://www.xanalys.com/link-explorer-6-1-released/

no idea of the costs, however.

Check the video here:

https://www.youtube.com/watch?v=xY-YiKszf5A

These are more like "network data" visualization tools or "SNA", Free/Open source there is Gephi:

https://gephi.org/

jaclaz


   
ReplyQuote
 dega
(@dega)
Reputable Member
Joined: 11 years ago
Posts: 267
 

try to use microsft power bi: https://powerbi.microsoft.com/en-us/

the base licence is free


   
ReplyQuote
(@trewmte)
Noble Member
Joined: 19 years ago
Posts: 1877
 
Posted by: @jaclaz

 

https://www.xanalys.com/link-explorer-6-1-released/

These are more like "network data" visualization tools or "SNA", Free/Open source there is Gephi:

https://gephi.org/

Not seen either of those, but they both look good, will research.


   
ReplyQuote
(@trewmte)
Noble Member
Joined: 19 years ago
Posts: 1877
 
Posted by: @giandega

try to use microsft power bi: https://powerbi.microsoft.com/en-us/

the base licence is free

I should have thought of this one as I have Brett Powell's book on Power Bi. There is a Code download that accompany's the book.


   
ReplyQuote
Styers
(@styers)
Eminent Member
Joined: 7 years ago
Posts: 27
Topic starter  

Excellent suggestions, thanks looking at them all!


   
ReplyQuote
Share: