Automation of data processing and data visualization

Closed Posted 6 years ago Paid on delivery
Closed 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.

Data Entry Data Processing Excel Visual Basic

Project ID: #16384785

About the project

15 proposals Remote project Active 5 years ago

15 freelancers are bidding on average €1067 for this job

ksriniravi

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

€1000 EUR in 30 days
(199 Reviews)
6.9
fabest

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 ser More

€1184 EUR in 20 days
(65 Reviews)
7.1
avinav606lx

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

€1444 EUR in 3 days
(176 Reviews)
6.5
VladimirLilenko

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

€1500 EUR in 14 days
(116 Reviews)
6.3
usmanhassan123

A proposal has not yet been provided

€1000 EUR in 1 day
(77 Reviews)
6.2
sajidkhan45

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

€1250 EUR in 20 days
(66 Reviews)
5.6
whitehorsetechn

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

€1250 EUR in 20 days
(14 Reviews)
5.2
utkarshkatiyar19

A proposal has not yet been provided

€1052 EUR in 15 days
(13 Reviews)
4.3
qasimalikgmail

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

€750 EUR in 15 days
(7 Reviews)
3.7
dexdel

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. More

€888 EUR in 20 days
(2 Reviews)
2.6
owejkuruni

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

€750 EUR in 3 days
(0 Reviews)
0.0
s84tcs

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 i More

€833 EUR in 10 days
(0 Reviews)
0.0
fredyguardiola

A proposal has not yet been provided

€1111 EUR in 3 days
(0 Reviews)
0.0