Đã Đóng

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.

Kĩ năng: Excel, Xử lí dữ liệu, SQL, Excel Macros, Excel VBA, Microsoft Access

Xem nhiều hơn: 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

Về Bên Thuê:
( 0 nhận xét ) San Francisco, United States

ID dự án: #20890369

60 freelancer đang chào giá trung bình $1045 cho công việc này

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. Thêm

$1200 USD trong 5 ngày
(333 Nhận xét)
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 trong 7 ngày
(141 Nhận xét)
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 Thêm

$950 USD trong 7 ngày
(286 Nhận xét)
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 Thêm

$1000 USD trong 5 ngày
(260 Nhận xét)
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 Thêm

$900 USD trong 3 ngày
(311 Nhận xét)
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 Thêm

$1058 USD trong 7 ngày
(111 Nhận xét)
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 Thêm

$1125 USD trong 7 ngày
(113 Nhận xét)
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 Thêm

$1000 USD trong 5 ngày
(53 Nhận xét)
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 Thêm

$1250 USD trong 7 ngày
(120 Nhận xét)
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 trong 10 ngày
(136 Nhận xét)
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 Thêm

$750 USD trong 3 ngày
(73 Nhận xét)
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] Thêm

$750 USD trong 10 ngày
(125 Nhận xét)
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 trong 7 ngày
(52 Nhận xét)
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 Thêm

$1000 USD trong 7 ngày
(21 Nhận xét)
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 trong 4 ngày
(33 Nhận xét)
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 Thêm

$1000 USD trong 7 ngày
(24 Nhận xét)
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 Thêm

$1125 USD trong 7 ngày
(31 Nhận xét)
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 Thêm

$1125 USD trong 20 ngày
(3 Nhận xét)
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 Thêm

$1200 USD trong 3 ngày
(29 Nhận xét)
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 Thêm

$1111 USD trong 7 ngày
(27 Nhận xét)
4.8