Lukket

Excel Support

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.

Evner: Excel, Databehandling, SQL, Excel Macros, Excel VBA, Microsoft Access

Se mere: transfer data excel multiple sheet access table, excel vba odbc access open driver, programmer excel visual basic access programming, exporting report excel free sample access database, uploading excel file net access database, excel multiuser vba access table, converting excel macros vba access, getting data excel file putting access file, select data excel vba form access, kind simulation excel support, reading excel file writing access table, excel vba as400 access, excel vba upload access, netread excel file save access, read excel file save access net, freelance excel support, excel add client access, read excel spreadsheet write access table, freelance access and excel support

Om arbejdsgiveren:
( 0 bedømmelser ) San Francisco, United States

Projekt ID: #20890369

60 freelancere byder i gennemsnit $1045 på dette job

schoudhary1553

Hello, I have gone through your job posting and become very much interested to work with you. I am an expert in this field. I have already completed several projects like this. For evidence you can see my profile. Flere

$1200 USD in 5 dage
(333 bedømmelser)
8.0
Eagles90

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

$1500 USD in 7 dage
(141 bedømmelser)
7.8
seaanddream

Hi, my name is Selim. I am from UK. I read your `Excel Support` project descriptions carefully before bidding. I checked your requirements as well... I got what you need and ready to go ahead as soon as we can clarify Flere

$950 USD in 7 dage
(286 bedømmelser)
7.8
paris2785

Hi, there! My name is Paris, and I was glad to see that you're looking for an Excel developer. According to your brief, you want to have an Excel application that will get pivot tables and graphs out of millions of row Flere

$1000 USD in 5 dage
(260 bedømmelser)
7.5
P0L

Hello, I am an Excel/VBA expert and I would like to help you with your project. I can use all means necessary to process and analyze your data, including PowerPivot. Please check my profile and contact me to discuss fu Flere

$900 USD in 3 dage
(311 bedømmelser)
7.3
shoguna2m

Hi there, This Mauricio, I'm the data, VBA Excel expert from Trascender Global Team with 4 years of experience in handling large amount of data with multiple techniques. I've checked your project and I'm interested i Flere

$1058 USD in 7 dage
(111 bedømmelser)
6.9
periyannas

Hi, Nice to know your requirement. I am an excel vba, vb6 professional and have delivered over hundred excel vba projects in the last one year. I am also a sql expert. Willing to take up your project. Let me see Flere

$1125 USD in 7 dage
(113 bedømmelser)
6.3
dvcontact

Hi, Would you like to see a quick demo of your project on conducting data analysis on your large database completed before you award the project? You can consider it professionally done with the use of a perfect tool l Flere

$1000 USD in 5 dage
(53 bedømmelser)
6.4
shikhamehta

Hey, As you rightly mentioned, Excel will not be able to handle that volume of data. Even if you load it in multiple books or sheets, it will not be able to do calculations or even slice the data effectively. There ar Flere

$1250 USD in 7 dage
(120 bedømmelser)
6.5
asadkhan3533

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

$750 USD in 10 dage
(136 bedømmelser)
6.5
mateenbhatti94

Dear sir I have read the requirements and completely understand the project.I will do it using the sql as it quick and will build you complete program. I have been in this industry for 1 year and such jobs are my dail Flere

$750 USD in 3 dage
(73 bedømmelser)
6.2
aubrey03

I am an Excel and VBA specialist with a lot of experience in creating complex automation tools, formulas, databases, queries and macros. You may check some of my projects here: [login to view URL] Flere

$750 USD in 10 dage
(125 bedømmelser)
5.9
zu02

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

$1666 USD in 7 dage
(52 bedømmelser)
6.1
SergioAlfaroV

Hello! I am a Computer Engineer, with a Master of Business Administration and a MCSA SQL Server 2014, with 12 years of experience using SQL, queries, reports and dashboards design and construction, data analysis, data Flere

$1000 USD in 7 dage
(21 bedømmelser)
5.7
vladishat

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.

$750 USD in 4 dage
(33 bedømmelser)
5.2
VBAautomation

Hi, I am a professional MS Access and SQL database developer. I can understand you issues. in excel with huge data if run any calculation the response time would be very high. I can create a Access database interface Flere

$1000 USD in 7 dage
(24 bedømmelser)
5.2
Logo199

I have total 7 years of working experience in process mapping , process documentation , data entry , data analysis and expert in MS office application including MS word , MS powerpoint , MS excel , Photoshop , Adobe Flere

$1125 USD in 7 dage
(31 bedømmelser)
4.5
shivmirthyusl

IT FLEX SOLUTIONS has focused exclusively on the Web Development/Designing projects with 10+ years of service. Our Web Development/Designing expertise has helped clients to create e-commerce, social networking, real-es Flere

$1125 USD in 20 dage
(3 bedømmelser)
4.6
bhupendrayadav

I can run queries and cut data based different rules and formulas along with chart and dashboard, this can be achieved in power pivot under excel only, which can handle huge data also. Let initiate chat for detail disc Flere

$1200 USD in 3 dage
(29 bedømmelser)
4.8
supergana

Hi - 3 million records and 30 columns is certainly something that would kill excel. You need a database, access or mysql if you are looking for free stuff. If you are willing to spend money for database oracle or mssql Flere

$1111 USD in 7 dage
(27 bedømmelser)
4.8