QlikView Data Extractor
Sep'11th 2018 - Aug'22nd 2018
VWR International LLC
Project Charter
PROBLEM STATEMENT
Most of our internal teams needs extracting data from QlikView manually based on requirements and do clean up, format the data. Each step involves manual intervention from the user and it is time consuming process and there are misses in quality due to incorrect selections made by User.
OBJECTIVE
Primary Objective:
-
Eliminate manual download from QlikView
-
Eliminate complete manual steps involved which is time consuming process
Secondary Objective
-
To save time taken to download any data from QlikView.
-
Run the tool in background so that the window is available for the User for other activities.
-
Follow all the steps involved without manual intervention
-
Needs to leave the Decision-making step to the Analyst.
-
To propose an alternate method that reduces the rework rate
-
Quality check once the reports are generated.
EXPECTED DELIVERABLES
Implementing Automation, will reduce the manual steps invloved in downloading, copying and pasting, through
-
Poka-yoke
-
Run the tool in background,
-
Foreground will be available for other activities,
-
Extract data automatically from QlikView,
-
Without manual intervention,
-
Without adding additional resources,
-
Decrease time,
-
Lower human fault,
If achieved, any QlikView extraction process could be produced with greater quality in very short time.
PROJECT SCOPE- IN SCOPE
In Scope:
QlikView data extraction, Quality Management, Customer Service Satisfaction, Use of Automated tool, Time Management, Associates who extract data from QlikView, Running in Background
Out Scope:
Extracts data only from QlikView application
Work Break down Structure
The Tool has been created on Microsoft Excel VBA and incorporates the codes that interacts with QlikView application to extract data. It needs to help the user to extract the data from QlikView by hiding in background without notice, upon completion the tool needs to pop up saying "The data has been extracted successfully". In the mean time the window desktop should be available for other activities for the user. He needs to review each output files based on the status provided by the tool, thus leaving the decision making step to the user.
The Tool has been created and it performs good. The Tool is designed to extract any data from any QlikView application in background. The user needs to open the template and make the required selections and click run. It extracts data from Qlikview and It splits the files as per the selections and saves them in respective step folder. It now avoids complete manual steps involved. The user now can make the decision by formatting and incorporating the extracted data as per the business requirements.
-
The official meeting with team members and management was conducted on Sep'11th 2018
-
The Project has Gone live after getting approval with IT on Aug'22nd 2018
-
Provides an alternative method to extract data from QlikView
-
The user can input the values in the user form provided as per the requirements
-
It runs in background allowing the user to make any activities in foreground.
-
It saves time and increases the quality