|
|
|
|
|
|
|
|
Inventory Database
The Inventory Database tracks the dispensing behavior of about 1000 veterinary clinics
in the United States. The Inventory database can be used to generate product, region
and diagnosis reports of dispensing data. See the Inventory Tracking Study for more information about
these reports.
|
|
|
|
There are two main types
of data cleaning that is performed on the Inventory database to ensure integrity.
• New Integrity: locates and identifies errors
• Outliers:
|
• Highlights adnormal deviations for a given clinic
• Shows the dispensed amount for the same clinic up to
a year back.
• Calculates averages on a per vet basis.
• Abnormal dispensed clinics are placed in exclusion table.
|
|
|
|
|
Screen Shot of Inventory Database
Main Menu
|
|
|
|
|
|
|
|
Screen Shot of Inventory Database Master Screen
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|