Data Automation Specialist Needed: Power Query

We are seeking an experienced Power Query Specialist to diagnose, stabilize and optimize a current Excel workbook that relies heavily on Power Query for data transformations. · ...

We need a standardized Power Query and automated vendor-specific Excel output files generated monthly. · Creating efficient data handling processes · ...

Hi I'm a Group Finance Controller working with Oracle R12 and a legacy ERP. · ...

I am looking for a senior expert who can coach me live via screen share for a few hours per week in Power Query and Power Pivot. · ...

I want to build a Power BI scheduling dashboard that automatically shows:This Week's upcoming POs · Next Week's upcoming POs · Following Week's upcoming POs · The goal is a clean "dispatch / scheduling board" style view that's easy to use daily. · ...

We seek an Excel Power Query specialist for data transformation and analysis tasks. The ideal candidate will have a strong background in using Power Query to clean, reshape, and merge complex datasets. · ...

I need a POWER QUERY file pulling from a PDF. I will update the PDF once every month so the file has to update accordingly. · I need to add a JOB CODE column to the table. · The correct salaries must be found taking into account that sometimes some employees are working in diffe ...

I am seeking assistance in creating a consolidated measures workbook which uses Power Queries to automatically update and refresh various measures from file folders. · Creating a consolidated measures workbook using Power Queries · ...

We are looking for a skilled freelancer to assist in transforming multiple Excel workbooks into Excel Power Query. · ...

We are a nonprofit organization seeking an experienced Excel Power Query specialist to build an automated data cleaning and transformation system. Our goal is to create an Excel template where subgrantees can paste raw export data and click Refresh to get clean standardized outpu ...

We are seeking a skilled freelancer to update macroeconomic tables and optimize our power query script. The ideal candidate will have experience in data analysis and be proficient in power query. Responsibilities include ensuring data accuracy and efficiency in data import proces ...

I need an Excel expert to build an automated performance tracking dashboard. · ...

I need a Query for Power BI/Power Query to pull data from the Pipedrive API. · Pagination · , API Integration · , Power Query · ...

Hello · I have a need for a refreshable power query. I have one spreadsheet with a tab called MASTERDATA with several columns of data. Two specific columns are: InvoiceID and Inv Date. (Dates are pre=populated through 2024. Dates from 2024 to today have the InvoiceID, but no date ...

We are looking for an experienced developer to create an AI-powered omnichannel system for our company.This system will enable users to intelligently query and visualize internal KPIs enhancing decision-making and reporting capabilities. · ...

We are seeking a skilled freelancer to assist with creating a live link in an Excel document using Power Query linked to Pipedrive. The main challenge we are facing involves pagination issues that need to be resolved. The ideal candidate will have experience working with Excel Po ...

We're a small consulting firm looking for an experienced Excel and Power Query expert to refine our existing project tracker and invoice workflow. · We currently use a master project tracker that feeds into Power Query–based invoice reports. The system works, but we need to clean ...

A skilled freelancer is sought to assist in writing Power Query code for converting a TXT GL file into a well-structured Excel file. ...

Overview · We are raising a private fund and use Airtable as our CRM. · We need an experienced Excel/Power Query specialist to build a fully automated dashboard on excel that connects directly to Airtable via API. · No manual CSV exports. · Excel must pull live data from Airtable ...

We are seeking an Excel automation specialist to streamline our data processing workflow. The project involves using Power Query to extract data from three different sources, applying automated formulas, and creating a final output sheet. Additionally, the data should be split in ...