Build Automated Excel Dashboard with 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. · ...

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

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

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 · ...

Data Operations Specialist - Excel / Power Query (Long-Term). I'm looking for a detail-oriented Excel / Power Query specialist to support a long-term data ingestion and automation workflow. · The long-term goal is to build a clean, repeatable, well-documented data pipeline that c ...

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 ...

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

We're a boutique consulting firm specializing in intelligent automation for companies across Mexico and LATAM. · We're looking for a SPANISH SPEAKING (NON-NEGOTIABLE) DATA AUTOMATION SPECIALIST* who's equally skilled with Excel/Power Query and generative AI. ...

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

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

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. · ...

I need to transform Purchase Orders from my ERP in a fixed format using Excel Power Query so they match the different heading and structure requirements of multiple supplier ordering portals. · ...

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 ...

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 ...

Data Architect required for designing scalable Excel-based data infrastructure and ETL for approximately 80,000 retail SKUs. · Design sophisticated and scalable Excel-based data infrastructure. · ...

+We need an experienced Excel Power Query specialist to build an automated reporting workflow. · ...