I have a large database of information, approximately 3 million rows and over 30 columns. I would like to do multiple cuts of the data - conditional sums, pivot tables, etc. - but the data is too large to effectively run those formulas. I will then need to build charts and exhibits with that data. The number of permutations I need is TBD as preliminary cuts will result in new questions that require secondary analyses.
I consider myself a very strong user of Excel, but essentially need help with managing the sheer volume of data. Not sure if Access or SQL or some other program would provide for a better solution. If working outside of Excel, I will need an expert who can respond quickly to requests to run multiple queries on short notice.
60 freelancers are bidding on average $1045 for this job
Dear Client, We are interested in your project and ready to go for it. Please let us know when you are available and we can discuss further. Kind Regards, Safeer Ali
Please review my profile as i have relevant skills and experience required for this project. Kindly send me a message to discuss further. Thanks, Asad Khan
Hi Let to try it via Excel- In parallel via ms acces. Which will be best way for you we will adjust it for final version. Regards, Zura- ms access/vba coder sinse ms office 97 released
Hello! l know how to solve your problem, and I have several wonderful tools for this aim: MS Access, RapidMiner, R-script, or Python - l could try any that fit you best, and you may use it in your future projects.