BizInt Cookbook of Reports & Visualizations

www.bizint.com/Cookbook | © 2023 BizInt Solutions, Inc., 06 /2023 Cookbook of Reports & Visualizations

Technique: List Comparison You can use VP-SCE to identify items that appear on two different lists. One list needs to be a field in your current dataset. The other can be a field in any open dataset or a text file. Here we show an example useful for identifying Key Opinion Leaders (KOLs). We will compare authors from a literature search in PubMed to investigator names from relevant clinical trials in Sitetrove. This technique can also be used with any list, such as a speaker list from a conference.

0

5

10

15

20

25

30

35

Kindler, Hedy Lee

29

Baas, Paul

17

O'brien, Mary E R

17

Van Meerbeeck, Jan P

15

Krug, Lee M

13

Rusch, Valerie W

13

Sterman, Daniel H

12

Giaccone, Giuseppe

11

Tsao, Ming-Sound

11

Pass, Harvey I

10

Santoro, Armando

10

Hassan, Raffit

9

Fitzgerald, David J

8

de Perrot, Marc

7

Stahel, Rolf A

7

Taub, Robert N

7

38 PAGE