Automation of data processing and data visualization
€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.
Project ID: #16384785
About the project
15 freelancers are bidding on average €1067 for this job
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 More
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 possibl More
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 th More
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 More
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
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