Find Jobs
Hire Freelancers

Analyze some Data

R21000-35000 ZAR

Cerrado
Publicado hace más de 7 años

R21000-35000 ZAR

Pagado a la entrega
I have a delimited text file with 6 million rows of data which is fairly clean and organized. The data relates to accounting transactions of recurring customers and suppliers. The tests I need performed on the data set are as follows: 1. Duplicate customers based on customer number. 2. Duplicate suppliers based on supplier number. 3. Customer correct age (21-60 years old) based on birth date. 4. Missing customer numbers in fields or inconsistent customer numbers. 5. Duplicate transactions based on same date/amount/unique number. 6. Transactions greater than a specified limit (limit in data file). 7. Transactions not paid within 4 months of initiation. 8. No authorization number for transactions. 9. Payments to suppliers not settled within 30 days. 10. Payments paid to suppliers not loaded on the system (data file).
ID del proyecto: 11528499

Información sobre el proyecto

24 propuestas
Proyecto remoto
Activo hace 7 años

¿Buscas ganar dinero?

Beneficios de presentar ofertas en Freelancer

Fija tu plazo y presupuesto
Cobra por tu trabajo
Describe tu propuesta
Es gratis registrarse y presentar ofertas en los trabajos
24 freelancers están ofertando un promedio de R25.217 ZAR por este trabajo
Avatar del usuario
Hello, my name is Cristian, I have a degree in Business and work with excel every day. I have much experience with spreadsheets, formulas, models and macros. Check my reviews. They speak for themselves. Best regards
R28.000 ZAR en 10 días
5,0 (125 comentarios)
6,4
6,4
Avatar del usuario
----------Best Result on Time! Pro Data Processing and Matlab Expert! No Problem!-------------- Hello, dear! I'm interesting of your project because I'm expert of Data Processing and Matlab so that I have some good Experiences in this field. If you give me the chance, I'll do my Best for you so as to finish this on time with best quality. Always Ready for You! I'm waiting for your positive responding here. Best Regard...
R21.111 ZAR en 10 días
4,5 (163 comentarios)
6,7
6,7
Avatar del usuario
Hello, I’m an Excel expert and I would like to help you with your project. Please check my profile and contact me to discuss further details. Regards.
R30.000 ZAR en 10 días
4,9 (102 comentarios)
6,2
6,2
Avatar del usuario
Hi there, if you'd like to have a professional result for your for your "Analyze some Data" project , here is my introduction: I’m an Access/VBA coder, a mathematician and a full time developer with a strong background developing a wide range of accounting, economical, statistical and mixed type projects using Ms Access, Ms Excel, VBA, ADO, SQL including projects for start-up companies and small businesses For over the last 20 years I’ve worked in a variety of industries. I have a deep passion for coding and guarantee that all of developing is 100% original. I highly value professionalism and hold myself strictly accountable to represent my client’s brand. I aim to form a long-term working relationship. In my portfolio look at the screen of "Create sales and purchases database application". You can have a little view about my coding experience.... Please, let me know what is needed to secure this bid! Thank you for your consideration. Zura
R31.111 ZAR en 10 días
4,9 (22 comentarios)
5,5
5,5
Avatar del usuario
Hi. I think I will be able to do this - using Matlab which will give an output to EXCELL file. Regards.
R21.000 ZAR en 15 días
4,8 (66 comentarios)
5,6
5,6
Avatar del usuario
sir i can help u with this project i have done masters in computer engg with specilization in image processing and pattern recognition this is a dummy bid i can give u an exact estimate after we discuss the project hopping for your kind consideration
R23.333 ZAR en 3 días
4,9 (68 comentarios)
5,6
5,6
Avatar del usuario
I am very interested in your project and I can do it fully. ===================================================================================================================================================================
R31.111 ZAR en 30 días
4,9 (49 comentarios)
5,6
5,6
Avatar del usuario
Available now to contact in chat and to start the project. Also please do look at my portfolio for my past work and 100% satisfied reviews from earlier projects Quickest delivery time than anyone who will bid. You can be rest assured the quality of the project will be top class and will be delivered as per the timeliness. Also I will be available for any modifications which you require during the project.
R23.333 ZAR en 10 días
4,8 (106 comentarios)
5,2
5,2
Avatar del usuario
Dear Valued Employer, I can add value to your project, by suggesting new ideas. I am fast and reliable. For further understanding why I am the right firm for your project, kindly check my profile, reviews, rating and portfolio. With over 8 years of cross-functional experience, and helping clients world wide with diversify team, I provide genuine and innovative solutions as per your circumstances and requirements. I am MBA-Finance, M.A-Economics, and Qualified Chartered Accountant. If you feel to discuss more before you award me the project, you can send me the message. Kind regards, Rakesh
R31.111 ZAR en 30 días
4,9 (27 comentarios)
5,2
5,2
Avatar del usuario
Hello there! If you are in need of somebody to produce results based on the description that you have mentioned then I can assist you with your project! I am very good with excel and the formulas it has. Feel free to message me the details.
R27.777 ZAR en 30 días
5,0 (35 comentarios)
4,9
4,9
Avatar del usuario
Hello. 30% of employers hiring me once hired me again. I have experience in the same. I CAN do this job, and do it well!
R21.000 ZAR en 30 días
5,0 (54 comentarios)
5,1
5,1
Avatar del usuario
Hi I have been working with MSSQL for over 16 years. I am fully experienced as a developer and a DBA. Currently I am working at big financial organization in which I am responsible for the BI department. I have designed and the Developed the Organization’s Reporting Database which has been constructed with SQL Server 2008 R2 Enterprise Edition. The database is being updated daily from the core system with txt or excel files via SSIS or with direct connection at mainframe’s DB2 and a numerous of KPIS are being daily updated during the ETL. For isolation reasons the KPIS are replicated to another DB (with transactional replication) which exploits the reports via SSRS to the consumers. Some KPIS are being replicated with merged (bidirectional) replication. Also, 10 Cubes in SSAS are being daily automatically processed and the end of the ETL. Several other reports are daily automatically produced and sent via email to the recipients. Finally I have designed and developed the bank’s crm DB which is published on the intranet. The DB holds full information about the customers (Customers,Addresses , Financial Data , Contacts , campaigns , etc) and covers 4 countries. To achieve this i have made partitions over the country code. The size of the Reporting DB, is about 4TB and consists of about 4.000 objects and the replicated KPI DB is 350GB. Best Regards mpalgeo
R21.000 ZAR en 5 días
5,0 (3 comentarios)
4,7
4,7
Avatar del usuario
Wonderful project! We are pro in Data processing.. As we are masters of mathematics and control engineering, we will give you a successful result in time. Keep in touch with us,please... Thanks a lot!
R21.000 ZAR en 5 días
4,9 (24 comentarios)
4,5
4,5
Avatar del usuario
I can get loaded the 6 million data and find the inromation specific to : 1. Duplicate customers.. 2. Duplicate suppliers.. 3. Customer age.... etc.... as per the 10 data points required. I have proficiency in handling delimited values both in Excel, MS Access. Good expertise in Database handling, volumes of data for comparison. • I have very good expertise in MS Access - GUI, Data entry forms, calculations and reportings. • MS Access - Database creation, tables, forms, queries and reports. Form designing, report designing, Reports generation. • WIll provide support for the application during implementation, fix any issues if found free of cost. • Will touchbase constantly to have the progress informed, as well to sort out any queries. • Please review my portfolio on the recent projects in Excel and MS Access.
R21.000 ZAR en 10 días
5,0 (20 comentarios)
4,0
4,0
Avatar del usuario
Edit: thank you for reply. If you need to run once it's obviously simple to manage. But I would need to better understand: 1) what do yoiu mean with "duplicate customers based on customer number"? Would you like to cancel or merge? Please provide a brief example. 2) does point (6) means: "group in a new file every transaction greater than a limit that I will provide"? 3) does point (7) means to cancel or merge transactions not paid within 4 months...? I think to be the right guy for you but I need to understand well your needs. Regarding a perpetual solution, because it would be more expensive, I suggest to evaluate how many time do you think to use the tool? For example: 1 time/year - in my opinion it's better once-a-run.. 1 time/month or more frequentely - in my opinion it's better a complete tool/software. Please let me know if you desire. Dear Customer, I am interested in your project but I would like to know if you need to run this analysis on your 6-millions-row data set just one time, or if you need a software that culd analyze them each time you desire. It's important to distinguish it because, in the first case, it's a quite simple task and the price could be less than your minimum. Please contact me if you want to share with me some further details. Best Regards, Marzio
R21.000 ZAR en 10 días
4,7 (4 comentarios)
3,8
3,8
Avatar del usuario
I have bachelor and master degrees in IT. My Primary skills include Java, Python, VB/.NET, ArcGIS, and PHP. Also database skills include MS Access, MySQL, and Oracle. My Other skills include server and network administration and maintenance with Linux/Unix and Windows Networking.
R22.222 ZAR en 1 día
4,9 (14 comentarios)
3,6
3,6
Avatar del usuario
First we need to import the data into an SQL database (like MySQL open-source). From there we can develop queries that answer these questions. If you want we can connect the query results to a dashboard/reporting tool like Power BI (which is free for a single user). Please let me know a good time to discuss.
R35.000 ZAR en 20 días
5,0 (1 comentario)
3,7
3,7
Avatar del usuario
Hello, I would kindly complete all tasks for you. I will import the data in excel in 6-7 worksheets (as the limit is just over 1M rows per worksheet), then I will create an extract for each point from the description looking through the complete file using VBA. If you want to make changes I will compile all requirements and create a brand new file that suits your needs. If you are interested please open a chat with me so we could discuss more details. Kind regards, Sorin
R21.000 ZAR en 1 día
5,0 (4 comentarios)
2,5
2,5
Avatar del usuario
Hi, my name is Matt and can do a script for you (all that is needed, otherwise I have 22 years of IT development experience). I have read and understand your requirements. My proposal is: 1. Creation of the R (statistical programming language) script that will ask for the file as the input data. 2. The script will execute all tests and prepare results for each test. 3. The script will output the results with each test result in the separate sheet (tab) of the Excel workbook (prompting for a filename). As being a script with custom input and output (file) option you can run with same structured data as you wish and on demand. The requirement (installing a free R software) is easy to fulfill, along with necessary modules that will have to be installed in the R environment to run the script. I can help you do that remotely if required, you will certainly get short instructions for installations. Final script can be called also using batch jobs. Or maybe even with a simple application that would be able to accept your dragged document, sense that, do the calculation and prompt you for the output. It depends on what environment you have (Windows, Mac, Linux - I can develop for the all three yet mostly for Windows and Mac). Please provide a sample data if possible. This is important to establish the memory requirements (R uses 8 bytes for numbers etc) e.g. 6 million rows with 100 bytes per row will require 600 MB of RAM plus overhead. Looking forward to your reply, Matt
R21.000 ZAR en 3 días
3,4 (1 comentario)
2,7
2,7
Avatar del usuario
Hello I went through your project description and understand that you are looking for developers who can Write and Run various kinds of Queries on your Big Database in order to provide you with Various Aggregate informations, but still can we please discuss your specific requirement in full-detail over 1-1 chat. I have 4+ yrs of experience in Website/Software/Mobile App Development I have done projects including ERP & CRM For Transport Business, Human Resources Management, Service Center Management, websites like E-Commerce, Social Networking, Real-Estate etc. I have good experience in implementing SSL, SEO, Online-Payment, Mobile Responsive designs, CMS, Blog, Multi-Language support etc. I would really like you to allow me a chance to prove my skills to you, to do this I will be more than happy to create a demo website for you free of cost, this way you don't have to pay me anything and I get to prove my skills to you. Regarding the project itself you don't have to pay me anything in advance I am open to getting paid in milestones, my offer also includes 12 months of free maintenance after the project is over. As per freelancer policy I cannot initiate exchange of messages with you so please leave me a message so that I can provide you with a detailed proposal. please ignore the milestone request as per freelancer policy we are required to provide a minimum milestone request of 100% Thank you for taking time to read my message, hope to hear from you soon
R21.000 ZAR en 30 días
0,0 (0 comentarios)
0,0
0,0

Sobre este cliente

Bandera de SOUTH AFRICA
South Africa
0,0
0
Miembro desde sept 14, 2016

Verificación del cliente

¡Gracias! Te hemos enviado un enlace para reclamar tu crédito gratuito.
Algo salió mal al enviar tu correo electrónico. Por favor, intenta de nuevo.
Usuarios registrados Total de empleos publicados
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
Cargando visualización previa
Permiso concedido para Geolocalización.
Tu sesión de acceso ha expirado y has sido desconectado. Por favor, inica sesión nuevamente.