BizInt Cookbook of Reports & Visualizations

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

Recipes Using This Cookbook........................................................................................................................... inside cover PIPELINE Extracting the Highest Phase for an Indication [Pipeline DP-4]. .................................................................. 2 Highest Phase for an Indication – Database Summary [Pipeline DP-5]...................................................... 4 Creating Pipeline “Piano Charts” in PowerPoint [Pipeline DP-13]................................................................. 6 Visualizing the Pipeline with a Bullseye [Pipeline DP-16] .............................................................................. 8 Creating a Butterfly Chart [Pipeline DP-17]. ....................................................................................................10 Analyzing Companies by Phase with a Bubble Chart and Multi Donut Chart [Pipeline DP-18].........12 TRIALS Training (1): Creating a trial “Piano” Chart [Trials CT-11]...............................................................................14 Training (2): Trial Completion Timeline [Trials CT-12]....................................................................................16 Summarizing Clinical Trial Enrollment [Trials CT-4]. ......................................................................................18 Creating a Milestone Timeline [Trials CT-13]. ..................................................................................................20 PATENTS Creating a Motion Bubble Chart [Patents PT-14]............................................................................................22 Analyzing Companies by Therapeutic Activity with a Bubble Chart [Patents PT-12]............................24 Summarizing Sequence Locations in a Patent Family [Patents PT-8]........................................................26 Filtering the Patent Family by Authorities [Patents PT-3].............................................................................28 TECHNIQUES Technique: Using List Cleanup. ...........................................................................................................................30 Technique: Extracting Year...................................................................................................................................32 Technique: Working with Thesauri.....................................................................................................................34 Technique: Extracting Keywords.........................................................................................................................36 Technique: List Comparison.................................................................................................................................38 Technique: Classifying Records. ..........................................................................................................................40

For More Information.... ........................................................................................................................................42

1 PAGE