Automate Data import and Cleaning from any valid sources using Excel's Power Query
$35
Explore the marketplace!
What you get with this Offer
You will receive an Excel file that will be able to connect to the data source and import new data, all the reports will be updated. Power Query will load and clean all the new data when the connection is refreshed, all you will have to do is to hit the refresh button.
The services included in this price consists of:
- data import and cleaning based on your specifications. Source data can be almost any file or web site, database. The price is per source, this means that 1 data source will be processed in this price. The services provided for this hourlie should not exceed 2 hours, if the tasks requested will take more time, the extra time will be charged separately.
- the output can be a simple pivot table report or a Power Pivot report, with up to 3 KPI calculated.
The completed excel application will be delivered within 1 day.
Please note that Power Query is available only in Excel for Windows, 2010 or newer.
The services included in this price consists of:
- data import and cleaning based on your specifications. Source data can be almost any file or web site, database. The price is per source, this means that 1 data source will be processed in this price. The services provided for this hourlie should not exceed 2 hours, if the tasks requested will take more time, the extra time will be charged separately.
- the output can be a simple pivot table report or a Power Pivot report, with up to 3 KPI calculated.
The completed excel application will be delivered within 1 day.
Please note that Power Query is available only in Excel for Windows, 2010 or newer.
What the Freelancer needs to start the work
I can write the import queries for you, with dynamic parameters, to import and transform your raw data, until it looks exactly as you need it to be. Guaranteed.
You will need to provide:
- the source data
- the expected result layout.
Compatible operating system: Windows only.
Excel versions: 2010 and newer.
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