Find Jobs
Hire Freelancers

Sales Data Conversion to Excel & Extraction of some KPIs

₹1500-12500 INR

Ditutup
Disiarkan hampir 3 tahun yang lalu

₹1500-12500 INR

Dibayar semasa penghantaran
We have sales data in text files delimited by pipe (|). There are about 20 files for sales of each month, the files contain about 30-50k rows each and 20 columns. We need all that data converted into a single Excel in separate tab per month, and then some Key Performance Indicators extracted from it, like most profitable product, product category with most turnover and a few others. Also around 10 charts need to be generated on the sales data to represent growth/decline in sales and profit. We are open to suggestions for chart representations.
ID Projek: 30528295

Tentang projek

26 cadangan
Projek jarak jauh
Aktif 3 tahun yang lalu

Ingin menjana wang?

Faedah membida di Freelancer

Tetapkan bajet dan garis masa anda
Dapatkan bayaran untuk kerja anda
Tuliskan cadangan anda
Ianya percuma untuk mendaftar dan membida pekerjaan
26 pekerja bebas membida secara purata ₹7,796 INR untuk pekerjaan ini
Avatar Pengguna
Hi, I am well versed with Excel formulas, chart and automation in Excel using VBA and can help to convert data in text files to Excel and provide the required KPIs. It would help to discuss further on this. Looking forward to your response. Thanks
₹20,000 INR dalam 7 hari
4.9 (216 ulasan)
6.9
6.9
Avatar Pengguna
Dear employer, Hi As you said you are open for suggestions, I have one for you. I can develop a Python code with a simple dashboard (GUI) in which you can load the folder that contains the sales data files and then, click a button. After clicking, it generates an Excel file with your required template and also shows the key performane indicators that you want in a new page (or in the Excel file based on your decision). Also, it can generate the charts that you want in both Excel file and in separate images. I am an expert in Python and this kind of projects. You can read the reviews of other employers on my profile. I can help you with your project. Would you please send me a message so that we can talk about it more accurately? I am a computer programmer with more than 10 years of working experience using Python, C#, VB.Net, C++, MATLAB, FORTRAN, etc. I can develop your required code with the highest quality and the lowest price. Believe me one time and you will start hiring me as a long term employee. Regards, Abbas
₹10,000 INR dalam 3 hari
5.0 (12 ulasan)
4.0
4.0
Avatar Pengguna
I am offering my services on short notice. Relevant skills and experience please consider me and give me a chance to impress you by my quality services.
₹7,000 INR dalam 3 hari
0.0 (0 ulasan)
0.0
0.0
Avatar Pengguna
Hi there, I am proficient in data management.I ve read your job description and found myself fit for the job.I want your contiguity in chat box for starting the first job as freelancer.
₹3,333 INR dalam 2 hari
0.0 (0 ulasan)
0.0
0.0
Avatar Pengguna
What ever you want, will be done very well
₹6,000 INR dalam 3 hari
0.0 (0 ulasan)
0.0
0.0
Avatar Pengguna
I am an IT student. and i think i am eligible for this job. My typing speed is also quite good then others. so i hope u will consider my honesty towards thyis job. waiting for your reply. thank you
₹7,000 INR dalam 7 hari
0.0 (0 ulasan)
0.0
0.0
Avatar Pengguna
We have sales data in text files delimited by pipe (|). There are about 20 files for sales of each month, the files contain about 30-50k rows each and 20 columns. We need all that data converted into a single Excel in separate tab per month, and then some Key Performance Indicators extracted from it, like most profitable product, product category with most turnover and a few others. Also around 10 charts need to be generated on the sales data to represent growth/decline in sales and profit. We are open to suggestions for chart representations.
₹7,000 INR dalam 7 hari
0.0 (0 ulasan)
0.0
0.0
Avatar Pengguna
I am Qualified Accountant With 5 year Experience...I Can maintain your sale data in excel file fluently & Make sale chart for You according to your requirements, Discuss me for the project to make sure timely work Thanks & Regard. M Kamran
₹5,000 INR dalam 7 hari
0.0 (0 ulasan)
0.0
0.0
Avatar Pengguna
My Name Is Korim Ali and i think i am eligible for this job. My typing speed is also quite good then others. so i hope u will consider my honesty towards thyis job. waiting for your reply. thank you
₹7,000 INR dalam 7 hari
0.0 (0 ulasan)
0.0
0.0
Avatar Pengguna
I will do that asap at your preferred date also I have 1 year experience in data entry and in excel too
₹7,000 INR dalam 3 hari
0.0 (0 ulasan)
0.0
0.0
Avatar Pengguna
Hi! At my actual work, i do jobs at excel like that you need. Is an Hospital and we make a lot of charts,we analize prices, consumption and transit for making the biddings.
₹12,500 INR dalam 7 hari
0.0 (0 ulasan)
0.0
0.0
Avatar Pengguna
hello there, i have read the above requirements , i can provide you this data file within desired time period . would love to hear back from you soon. regards.
₹10,000 INR dalam 2 hari
0.0 (0 ulasan)
0.0
0.0
Avatar Pengguna
I am Qualified, With 7 year Experience...I Can maintain your sale data in excel file fluently & Make sale chart for You according to your requirements, Discuss me for the project to make sure timely work Thanks
₹1,600 INR dalam 7 hari
0.0 (0 ulasan)
0.0
0.0
Avatar Pengguna
"Hi, Hope you are doing well! Thanks for sharing your project requirement with us. It will be our great pleasure to work on your project. I have checked your requirement, yes we can do it, because we already work on similar requirement in past. We have right skills to work on this assignment. We will complete the work as per requirement
₹7,000 INR dalam 7 hari
0.0 (0 ulasan)
0.0
0.0
Avatar Pengguna
I am confident in my ability to produce results. Of course, situations happen when the results aren't ideal, and when that does happen, I do my best to tip the hat in a positive direction.
₹7,000 INR dalam 7 hari
0.0 (0 ulasan)
0.0
0.0
Avatar Pengguna
Greetings! I’m very much interested to your requirements and Job openings. I am a Professional in Google Sheet with over 5 years of experience, therefore, I can easily do this job. You can message me to discuss the detail. Why me? My goal is to offer services to you that are profitable. I don’t want you to place an order once and that’s it. For me to be successful, I need you to come back and order again. Give me the opportunity to work on your project. I wish to build a long-term relationship with you. We can have further discussion in chat. Thanks! Warm Regards, Bhargav.d
₹3,000 INR dalam 3 hari
0.0 (0 ulasan)
0.0
0.0
Avatar Pengguna
I Have just finished with a project, and do not have any more in the pipeline at the moment. If I am hired for this project, I will be able to give it my full attention and will deliver on time. Apart from this, I possess all the skills that you have outlined, and can effectively work towards tight deadlines.
₹1,750 INR dalam 4 hari
0.0 (0 ulasan)
0.0
0.0
Avatar Pengguna
I am a better resource for this project. An absolute expert in handling and editing Excel and PDF documents. Also, I have been part of information technology industry since last 13 years. My career started with data mining continued with software testing which requires data management & maintaining repository of documents. Career followed by Project management which requires management of scope and budget using excel and word files. Having all these year experience, I believe I should able to delight you with your scope and comfortably deliver the project without any hassle.
₹7,000 INR dalam 7 hari
0.0 (0 ulasan)
0.0
0.0
Avatar Pengguna
Hello, Hope you are well. I read your job post and demand . so don't worry, I can do perfectly. I well promote your Refall link I have huge knowledge in this job. Please give me a chance. Thank you so much.
₹1,500 INR dalam 7 hari
0.0 (0 ulasan)
0.0
0.0
Avatar Pengguna
Dear employer, I am Malik, energy efficiency engineer working as a KPI analyst for photovoltaic power plants. I am interested in the job that you are describing, as all of what you have mentioned is something that I do on daily basis, where I need to do one click, and watch Excel bring the huge amount of data, calculate the KPIs, highlight any needed data and draw the graphs, as all what you have mentioned are things that I personally needed for my work and have done it. I can provide you with a macro that you can use forever, one click to do all what you have described. This can also be more personalized if you need more specific tasks and more options. Preferred time for delivery is 3-5 days (depending on required personalization and amount of KPIs), but if needed, it can be done in one day. Looking forward to solve this problem! Regards, Malik Al-Momani
₹10,000 INR dalam 3 hari
0.0 (0 ulasan)
0.0
0.0

Tentang klien

Bendera INDIA
Kota, India
0.0
0
Ahli sejak Jun 14, 2021

Pengesahan Klien

Terima kasih! Kami telah menghantar pautan melalui e-mel kepada anda untuk menuntut kredit percuma anda.
Sesuatu telah berlaku semasa menghantar e-mel anda. Sila cuba lagi.
Pengguna Berdaftar Jumlah Pekerjaan Disiarkan
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
Memuatkan pratonton
Kebenaran diberikan untuk Geolocation.
Sesi log masuk anda telah luput dan telah dilog keluar. Sila log masuk sekali lagi.