Automation of data processing and data visualization
Budget €750-1500 EUR
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.
20 freelancers are bidding on average €1054 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
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
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
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
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 [url removed, login to view] you!
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
Dear sir. Your project attracted my attention at first glance, because I've really rich experience in Data Processing Programming. I'm really confident about your project, and very eager to join your project. If we 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 would like to help you with my expertise on DATA ENTRY, EXCEL etc. Please refer my portfoilo for my sample work. Leave a message. Thank you
Knowing and doing: [url removed, login to view] Assisstant [url removed, login to view] Analysis and modeling [url removed, login to view] and Control according To Agile, Scrum [url removed, login to view]: word, Excel, primavera 6,Microsoft Project,Visio, Minitab, SPSS,CMMS,MT4 Relevant Skills a More
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