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.
19 freelancers are bidding on average €1070 for this job
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
Hi, I am an advanced excel expert in VBA. Please discuss in detail over chat so that I can help you. Please check my project completion ratio and [login to view URL] you!
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