BizInt Cookbook of Reports & Visualizations

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

Creating Pipeline “Piano Charts” in PowerPoint [Pipeline DP-13]

This recipe describes how to build a piano chart visualization of a drug pipeline, which shows one box for each drug, boxes color-coded by field values, and boxes labeled by multiple fields. In this example we have built a “type of molecule” category using data found in different fields in different databases. We used this to color code the boxes.

If you have already followed the steps in the Bullseye recipe, you can skip to step 15 and build the piano chart.

Search results were exported from multiple pipeline databases to BizInt Smart Charts Drug Development Suite and then integrated with Reference Rows. VantagePoint - Smart Charts Edition (VP-SCE) was used to extract indication phase, create a category field, and clean-up and simplify drug and company name. The chart is then built using the “Create Piano Chart” dialog shown below and exported to PowerPoint (or Excel) where it can be further customized.

6 PAGE