Trial and Repeat Dashboard
Apr 5'th 2011 - Dec 12'th 2011
VWR International LLC
CURRENT PROCESS
The existing trial and repeat report does not have illustrations and it is not user friendly. The data needs to be populated from various databases that have connection problems.
PROPOSED PROCESS
The dashboard to be designed with charts and info graphics. Generate a database list and establish automatic connections to avoid connection problems.
PROJECTED
Saving 10 minutes per report
The impact is significant from turnaround time, establishing connection, accuracy and user-friendly. The report can be portrait-ed with charts and info graphics that will help users to understand more about it.
Introduced a connection list that establishes connection automatically based on the category name.
ACTUAL
30 minutes per report
The current trial and repeat report does not have illustrations and it is not user friendly. The data needs to be populated from various databases that have connection problems, which involves searching and validation at each data point.
Cost Savings
Increased Efficiency
Additional Controls
Manually need to check the connection
-
The official meeting with team members and management was conducted on Apr 5'th 2011
-
The Project has Gone live after getting approval with IT on Dec 12'th 2011
-
It Eliminates complete manual steps involved in establishing the connection.
-
Stores a table of existing connection category list.
-
It introduces more charts and info graphics that helps the report understand well.
-
It saves time and increases the quality.