4 PrAnaViz

4.1 Introduction

The aim of this tool is to visualize and analyze the prescription data to calculate total prescribed quantity of different APIs and to explore spatio-temporal trends of different APIs for wider use.

We have created, PrAnaViz, in a familiar dashboard layout with two tabs: (1) Targeted API, (2) Non-targeted API, to visualize total quantity of different APIs at CCG region with resolution to individual postcode.

4.2 Database connection string

  • The demo version of the in-built PrAnaViz enables users to input their database credentials to link the processed prescription dataset.
  • This can added by clicking the database icon in the right side of the navigation bar, 1 as in Figure: 4.1.
  • A drop down menu as in Figure: 4.2 will be generated to input the database connection strings such as, username, password and hostname
Right Navigation Bar

Figure 4.1: Right Navigation Bar

Option Remarks
1 Database connection
2 Full Screen
3 Dark and Light mode
4 Customize the app colors
Database Connection String

Figure 4.2: Database Connection String

4.3 Targeted Approach

  • In this tab, user can input a list of APIs, and find out the total prescription quantity of each API in the selected year, at the selected CCG region, as in the Figure: 4.3.
  • This tab also visualize the total quantity of APIs prescribed by month, GP, Chemical form, and Medicinal form for a CCG region in a selected year, Figure: 4.4.
PrAna Targeted Approach.

Figure 4.3: PrAna Targeted Approach.

PrAna Targeted Approach.

Figure 4.4: PrAna Targeted Approach.

Option Remarks
1 Select Targeted or Non-Targeted Approach
2 Upload targets i.e., APIs in .csv format
3 Select Year
4 Select Region
5 Select Setting Type
6 Select month-wise or year-wise plots
7 Action button to generate the plot
8 Plot generated based on user selection
9 Download buttons to download the generated plot as .pdf or .eps and data as .csv format
10 Maximize and minimize the tab
11 More insights on a selected API, visualize total prescribed quantity of the API per month, GP practice, postcode and medicinal form (click on a particular API on the barplot to generate these plots)
12 Download buttons to download the generated plot as .pdf or .eps and data as .csv format
13 Maximize and minimize the tab

4.4 Non-targeted Approach

  • Total prescription quantity of an individual API at different postcode per month at a CCG region, can be rendered in this tab, as in the Figure: 4.5.
  • The calculated total prescription quantity of an individual API at postcode level helps to find the hotspots.
  • User can download data as .csv file and publication ready image .eps and .pdf files.
PrAna Non-targeted Approach.

Figure 4.5: PrAna Non-targeted Approach.

Option Remarks
1 Select Targeted or Non-Targeted Approach
2 Select API in the drop-down menu
3 Select Region
4 Select Year
5 Select a month
6 Button to generate the plot
7 Plot generated based on user selection, click on a particular postcode to generate further plots
8 click on a particular postoode on the plot to generate these plots)
9 Visualize the total prescribed quantity of the API per month on the selected postcode
10 Download buttons to download the generated plot as .pdf or .eps and data as .csv format