Automate Data import and Cleaning from any valid sources using Excel's Power Query

$35
1
Delivery in
1 day
Response time
within a few hours

  • Views 86
  • Sales 1
   
  • 0

What you get with this Hourlie

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.

What the Seller 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.