Sanofi Dashboard
Sep 4'th 2018 - Sep 19'th 2018
VWR International LLC
CURRENT PROCESS
Analyst needs to run each and every query separately and update it into individual tabs of Sanofi Dashboard.
PROPOSED PROCESS
Eliminates complete manual steps involved. Stores each and evert query into the dashboard and runs at one single click extracting from SAP BEx into individual tabs of Sanofi Dashboard.
PROJECTED
Saving 20 minutes per month
The impact is significant from turnaround time, accuracy and user-friendly.
Introduced a QC mechanism to check whether the populated data is correct.
ACTUAL
20 minutes per month
Analyst must search for a single query, open it. Input all the required variables and paste the data into the respective tab for Sanofi. Needs to repeat the same steps nearly for 8 different queries and paste the data into individual tabs of Sanofi Dashboard which involves searching and validation at each data point
.
Cost Savings
Increased Efficiency
Additional Controls
No additional controls available
-
The official meeting with team members and management was conducted on Sep 4'th 2018
-
The Project has Gone live after getting approval with IT on Sep 19'th 2018
-
It Eliminates complete manual steps involved.
-
Each and every query is embedded into the Sanofi dashboard.
-
Extracts the output data into the desired template automatically.
-
Introduced a QC mechanism to check whether the populated data is correct.
-
It saves time and increases the quality.