You will get a connecting, cleaning and manipulating data in Excel
Project details
Power Query (Get & Transform data in Excel) is a true game changer. It can simplify and automate various data activities. The key benefits of Power Query are,
Connect to any type of data source and fetch data
Define process for data cleansing and transformation
Combine datasets (table joins, appends)
Automate data collection & management tasks (refresh etc.)
Power Query offers easy and useful column profiling options. Use them to investigate how good your data is and fix problems with a click.
Connect to any type of data source and fetch data
Define process for data cleansing and transformation
Combine datasets (table joins, appends)
Automate data collection & management tasks (refresh etc.)
Power Query offers easy and useful column profiling options. Use them to investigate how good your data is and fix problems with a click.
Data Tool
Microsoft ExcelWhat's included $10
These options are included with the project scope.
$10
- Delivery Time 7 days
- Number of Revisions 1
Optional add-ons
You can add these on the next page.
Fast 1 Day Delivery
+$5About Vinoth
Excel Expert|VBA Expert|PDF Conversion Expert
Bengaluru, India - 4:30 pm local time
---------------------------------------------------------------------------------------------
If you feel investing lot of time in Excel work, and you wanted to automate the daily basis task which consumed more manual effort, I can help you in automating the same to reduce the manual effort and time with minimal error or No Error in the final Report Automation result.
Quick Introduction about me:
I have around 13 years of experience in various capacities (Data Analyst, Senior VBA Programmer, Power Query, Power BI And SQL Database)
I'm offering my expert level Excel and VBA Macro coding skills for any adhoc/custom project work.
Anything from developing a Macro, to a full fledged macro enabled spreadsheet that can be used to assist in automating and removing human error from day to day tasks such as data extraction, updating and validation
If Excel is able to perform the task/solution you require, then it is more than likely that I'm capable of delivering it for you.
Strength:
Whatever the work I do, will do with 100% commitment and Love to do with perfection. I will not compromise on quality of work which I deliver.
Project Details:
Worked with various clients as individual contributor with technologies involving macro, SQL Database and PowerBI Reporting
Accomplishment:
Able to convert manual task to Automation framework with enhanced features in Reporting and able to deliver the project before deadline.
Education:
Completed Computer engineering with Anna University in Chennai. Completed Master of Business Administration in Finance.
Steps for completing your project
After purchasing the project, send requirements so Vinoth can start the project.
Delivery time starts when Vinoth receives requirements from you.
Vinoth works on your project following the steps below.
Revisions may occur after the delivery date.
What is use of Power Query?
Power Query is for connecting, cleaning and manipulating data. You do this by applying steps on your data.