Phone number "Hot S...
 
Notifications
Clear all

Phone number "Hot Sheet" ideas?

Styers
(@styers)
New Member

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
Topic starter Posted : 20/11/2020 3:52 pm
jaclaz
(@jaclaz)
Community Legend

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
Posted : 20/11/2020 7:01 pm
trewmte
(@trewmte)
Community Legend
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
Posted : 21/11/2020 11:31 am
jaclaz
(@jaclaz)
Community Legend
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
Posted : 21/11/2020 3:09 pm
giandega
(@giandega)
Active Member

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

the base licence is free

ReplyQuote
Posted : 21/11/2020 7:25 pm
trewmte
(@trewmte)
Community Legend
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
Posted : 22/11/2020 2:38 pm
trewmte
(@trewmte)
Community Legend
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
Posted : 22/11/2020 2:39 pm
Styers
(@styers)
New Member

Excellent suggestions, thanks looking at them all!

ReplyQuote
Topic starter Posted : 29/04/2021 1:21 pm
Share: