Automation of data processing and data visualization
€750-1500 EUR
Closed
Posted about 6 years ago
€750-1500 EUR
Paid on delivery
We need to automate the processing and visualization of standardized input data
We are a marketing research agency and create data analysis reports on a daily basis. We have standard research methodologies (for example a standard set of questions with which we test TV advertising).
We would like to automate the process of data processing and data visualization:
1. Input a set of raw data with standardized structure.
2. The tool automatically processes the raw data into aggregated data (%s) and fills in standardized set of chars in PPT with this data.
Ideally the tool will have the following characteristics:
- Many chart types available for each type of variable
- Option to predefine a standard set of output charts per methodology and save this as a template
- Flexibility within the template – sometimes a question may have 5 answers, sometimes – 8 answers
- Option to add ad hoc questions to this template for specific research projects. These will be of the same variable types and chart types as all the rest, but will be defined each time by the researcher
- Option to filter the data (ex., the data charted only for men, only for women or in a comparison)
- Integrated statistical testing (statistically significant differences between pairs of %s, statistician will be involved as a consultant)
- Option to add data processing functionalities – nets, averages, etc. (we can explain this in detail during discussions)
- Charts directly transferable and adaptable in PPT, or created in PPT
We are open to discuss which software/program for development of the tool will work best.
Greetings!
I have reviewed your detailed requirements and understand all of them. I am an Engineer with 18+ years of experience. As part of my professional career, I have been part of a Six Sigma Black Belt Project and lead and been part of several Six Sigma Green Belt Projects. I understand what you are aiming for through this automation.
I can develop the required solution using Excel since it would be easy to maintain and share while requirements for training once the solution is ready would be very minimal . Being a full time freelancer working exclusively on Excel based projects, I work on such Excel based Solutions every single day. I have 18 years experience in using Excel as part of my daily work life. In the process I have implemented lot of automation similar to what you are expecting as well as dashboards for Management Reporting. In fact, over the last 21 MONTHS , I have spent at least 250 HOURS on automation in Excel every month.
If awarded, I can get your work completed to your fullest satisfaction.
Have a Great Day!
Srinivasan
Dear, we are Team of French + US.
I checked your project description, and I confirm I can develop your program.
I will focus on user friendly interface.
As you can see I have very good rate, you can be sure I am serious.
Regards,
Fabrice
Hi There,
I have created more than 500 macros so far and this looks feasible as well.
I am an expert in Excel VBA with over 5+ years of experience.
Ping me to discuss more.
Thanks
Aman
Hello, dear sir!
I registered at the forum not so long ago, but I already have several completed projects on www.freelancer.com. I am ready to carry out your project in the reasonable price and in the shortest possible time and with the highest quality!
From the Excel, PowerPoint and vba, of course, familiar.
Give me a chance to show what I can do!
Hey,
I made something similar for a client here where he puts in the details and milestones are created on the next page. That was a project management program using excel. I am an excel VBA expert and you can go through my reviews to be confident about me.
I would like to discuss more.
Thanks
Sajid Khan
Greeting,
I have understood your Automation of data processing and data visualization task and can do it with your 100% satisfaction. Please ping me for more discussion.
I have more than 5 years of experience in Data Entry, Data Processing, Excel, Visual Basic
Dear client,
I can build such a data processing and visualization tool in Excel using VBA macros. The visualization will be portable and can be copied into powerpoint file.
Looking forward to hear from you
Hello,
Greeting for the day!
I’ve carefully gone through your job posting "Automation of data processing and data visualization" and very much interested in the same.
I have 7 years experience in Data Entry.
I have extensive knowledge of using MS programs such as:
- Spreadsheets
- PowerPoint
- Excel
- Word
-Copywriting
-Data processing
-Copy typing
I have excellent writing and grammatical skills with the ability to enter data without errors. I also possess outstanding reading comprehension and active listening skills. I understand the importance of confidentiality and adhere to the highest ethical standards at all times. I am confident that I can be a great asset to your company and I hope to soon be the newest member of your team.
Thank you for your consideration,
Best Regards,
Raj
HI,
I'am a Data Entry, Data Processing, Excel, Visual Basic
expert. I have read your project description carefully. I am interested to do your Job. I think I am the best person for your project.
THANKS
though new @ freelancer, but i am six sigma blackbelt and PMI certified project manager working in top consulting firm with 15 years of work exp. i am good at excel, if you would like your tool in excel then i can do it for you. i am also Automation Anywhere certified RPA professional and have experience in working with top banks as consultant and delivery manager. u can expect a professional experience and my aim to achieve your goal with in your timelines
