Excel Expert to analysis 5,000 lines of raw data to find the root cause of a problem.
$10-30 USD
Pagado a la entrega
I need an Excel data mining expert to analysis 5,000 lines of raw data to find the root cause of a problem. The task at hand is to show the passrate issue / history and then to analysis the date in order to hone in on the problem.
Know Your Customer (KYC) is a process of proving a financial institution is aware of who their customers are. When a customer opens an online bank account
they go through this two step process.
1. Document Check: To verify a government issued photo ID is valid and authentic (by look at a number of things on the document to prove it is real)
2. Facial Similarity Check: Otherwise known as a selfie check; To verify that the face in the picture is the same with that on the submitted ID
This data has been provided by our supplier so that we can determine why Passrates have been decreasing substation in a recent period (provided in the data)
Passrate = the number of customers who pass both the dcoument authentication and facial recognition (column C and Column W are "Clear")
divided by the number of customers who attempt the process
Two raw reports are provided which I have merged into one.
Please Note: Column R is a download string of 5 properties which are essential for the analysis. I would like these 5 properties to be extracted into 5 columns.
It would be great if this can be done with an excel formula? If not, it would be great to explain how this could be done otherwise.
I've created two tabs (Passrate History and Root cause Analysis) with more detailed information on how I wish to see the data
With the results I need to create a short report so please keep this in mind as I would like to paste the graphics and charts into another document.
Nº del proyecto: #19836014
Sobre el proyecto
17 freelancers están ofertando un promedio de $30 por este trabajo
Hello. I understand the requirements of this project and I am interested to work on it. I am a reliable freelancer, proficient in Excel and focused on quality. Kindly consider my proposal. Thank you.
Hi, I am quite familiar with finding the root cause of the problem that decrease the passrate of the KYC. I believe I can clearly find the rootcause of the issue. Thanks, Shanthi
hi I have a lot of skills in processing data in excel VBA. You will get accurate and fast data...................
I am quite confident in excel. And think I should be able to assist you find the problem. Looking forward to hearing from you
i am a professional And seinor Accoutant And Auditor as a Multinational Company and part time Job in a software House as a Mobile Apps Developer
Dear Sir/Mam, Greetings. I'm professional Accountant, working in Hospitality industry since more than 18 years. I am proficency of MS Office package. I can find your problem and solve it. Thanks.
I have been learning in this field for a quite long time and I have done multiple projects of some similarity and I can deliver the result in time. Hope to be working with you. Thank You Vedant
Hi am interested with working for you I am a management accountant with over 8 years of experience in financial reporting meaning I have vast experience with excel I know all the formulas and how to work data on spre Más
i am a professional And seinor Accoutant And Auditor as a Multinational Company and part time Job in a software House as a Mobile Apps Developer
Hi, Greetings, I feel I am a suitable match for the Job, I have 5 years of experience in data entry and Microsoft excel. I have excellent skills in Data entry, Web research and Microsoft Office. I have enough experi Más
i can help using power pivot and power query send me data and i see what i will do to you as long as the data is in excel or importable to excel
Actually I can work much faster on this data. I sued to work with more than 25000+ records all the time. so it will be easy for me to close this project in shorter period.
Hello, Greetings, i really fits with that job. i am an expert at Visual Basic For Applications ( EXCEL ). I have experience woking with vba excel for almost 3 years. I hope i can help you. THANK YOU.
