Advice to step up analysis from Excel modelling to Power Pivot or other software
- or -
Post a project like this£37/hr(approx. $46/hr)
- Posted:
- Proposals: 9
- Remote
- #2273249
- Expired
TOP PRO - Excel, Word, PowerPoint, VBA, Google Sheet, Outlook, Access, Database, Scripting
Bay Minette
Data Modeling in Excel & Power BI With Power Pivot, Power Query, DAX and Google Data Studio Expert.
Dhaka
IT Consultant |Virtual Assistant| graphics| | Website design | social media management .
Nairobi
126446396475967889133358416528641946714199199920989662548881
Description
Experience Level: Expert
Estimated project duration: 1 day or less
I am looking for advice on what software I should learn to perform typical excel functions and modelling on more data than excel can handle.
At present I have input data of hundreds of rows that is then analysed with millions of calculations to create output data of hundreds of thousands of rows. The model uses standard functions in excel such as vlookups, sumifs, index matches, if statements etc.
However, I need to up the volume of data by a factor of 100. Hundreds of thousands of input rows to tens of millions of output rows. I think that Power Pivot might be the solution but I am interested to hear other solutions.
I would like to have a phone call (an hour or two) with someone to discuss the modelling I'm currently performing and options for taking it to the next level. I would then like to understand the requirements for me to train up, how best to do so and any other tips you might have! There is the potential for follow up work as my project progresses.
At present I have input data of hundreds of rows that is then analysed with millions of calculations to create output data of hundreds of thousands of rows. The model uses standard functions in excel such as vlookups, sumifs, index matches, if statements etc.
However, I need to up the volume of data by a factor of 100. Hundreds of thousands of input rows to tens of millions of output rows. I think that Power Pivot might be the solution but I am interested to hear other solutions.
I would like to have a phone call (an hour or two) with someone to discuss the modelling I'm currently performing and options for taking it to the next level. I would then like to understand the requirements for me to train up, how best to do so and any other tips you might have! There is the potential for follow up work as my project progresses.
Joel V.
100% (1)Projects Completed
1
Freelancers worked with
1
Projects awarded
0%
Last project
25 Jan 2019
United Kingdom
New Proposal
Login to your account and send a proposal now to get this project.
Log inClarification Board Ask a Question
-
There are no clarification messages.
We collect cookies to enable the proper functioning and security of our website, and to enhance your experience. By clicking on 'Accept All Cookies', you consent to the use of these cookies. You can change your 'Cookies Settings' at any time. For more information, please read ourCookie Policy
Cookie Settings
Accept All Cookies