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
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
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
You could also consider (but it has a charge) i2Base
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:
jaclaz
try to use microsft power bi: https://powerbi.microsoft.com/en-us/
the base licence is free
Â
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:
Not seen either of those, but they both look good, will research.
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.
Excellent suggestions, thanks looking at them all!