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
Option | Remarks |
---|---|
1 | Database connection |
2 | Full Screen |
3 | Dark and Light mode |
4 | Customize the app colors |
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.
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.
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 |