Expenditure data collecting, cleansing, and analyzing
The Company:
The client is a leading manufacturer of household items based in UK
Industry:
Data Collection
Company Headquarters:
London, UK
The Challenges
- Spend files with 1000+ links were received per week.
- As per the given instructions, 100+ links were required to be processed according to the format and this was really a challenge.
- The file with .pdf extension were required to be converted to csv format.
- This complicated task was to be delivered in tight schedule.
- For insuring on time delivery of the project, the team of trained and skilled experts worked 24/7.
- It was required to review the spread sheets thoroughly so as to edit the minutest details such as amendment of sheets having ? in place of £.
Advantages
- The procurement cost is reduced with the result of spend analysis and this helps the client to improve the efficiency.
- With the team of professionals having in-depth knowledge and experience in the field, such voluminous data was also handled with expertise and delivered with the estimated time.
- 100% error free data is provided and this factor is assured by the quality check done by senior experts.
- The clients received data in digital format that was easy to access and could be used efficiently for other purposes.
Solutions
- The received spend files with 1000+ links were processed and the document was downloaded by under respective name and format.
- The spend report file was created after with different fields such as last data collection month, number of researched documents, work on date, month of receiving data from the site.
- In the Issue query log, comments were kept for the documents that were not downloaded.
- Any additional headings were removed so that the first line item starts with the spend data.
- The total columns were removed from the spreadsheets.
- The format of date field was changed to DD/MM/YYYY.
- The amount/value field was changed to number field.
- The spreadsheets having negative values were amended to have positive value.
- The document is saved as “authority name _month” in the CSV format.
- With the find and replace option, the value of ? in the sheets was changed to £.
- The project was delivered within the specified time frame with best quality and zero errors.
TESTIMONIALS
100% communication throughout the entire process! looking forward to sending all my business directly to their team.
I am extremely happy to say that your devoted staff and manager, processes and services are totally fabulous.
I will highly recommend to Infinity BPO Services to anybody who’s looking for long term partner they help them grow the business.
Thanks for providing great solutions for my entire data entry needs. Your team did great job for us. Thanks for everything.
Excellent! Clear communication, prompt responses, and a true appreciation for quality work.
The team has the ability to manage large and complex projects. Highly recommend for long-term projects.
Previous
Next
Let Us Help You Overcome
Business Data Challenges
What’s next? Message us a brief description of your project.
Our experts will review and get back to you within one business day with free consultation for successful implementation.
Our experts will review and get back to you within one business day with free consultation for successful implementation.
Want to improve your data quality? discuss your next project?
We are Waiting! Outsource to US Now.
Looking for reliable outsourcing services? If yes, you are at the right place. Infinity BPO Services is the leading name in outsourcing industry offering finest services with the experience of years. With the services offered by us, clients are able to make huge savings in time and cost.
