Build Automated Excel Dashboard with Power Query

+We are looking for a skilled Power Query & Excel Developer with expertise in data transformation and standards management within the life sciences domain. · + · + · (Automate repetitive tasks and simplify workflows) · (Ensure data quality and adherence to life sciences standar ...

We are seeking an experienced Power Query Specialist to diagnose, stabilize and optimize an existing Excel workbook that relies heavily on Power Query for data transformations, consolidation and reporting.The ideal candidate will be a hands-on expert in modern Excel data tools wi ...

Our ERP exports monthly rebate data. We need a standardized Power Query and automated vendor-specific Excel output files generated monthly. · ...

I'm a Group Finance Controller working with Oracle R12 and a legacy ERP. · Stronger financial controls, · reporting speed and data reliability, · a controlled Power Query model from ERP exports are my goals.Build controlled refreshable Power Query models from ERP exports. · ...

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

I have a SharePoint-hosted Excel workbook that tracks open sales orders across multiple customer tabs (each tab is structured the same). I want to build a Power BI scheduling dashboard that automatically shows: · ...

We are seeking an experienced Excel Power Query specialist to assist with data transformation and analysis tasks. · The ideal candidate will have a strong background in using Power Query to clean, reshape and merge complex datasets. · You will be responsible for optimizing querie ...

I need a POWER QUERY file that pulls data from a PDF and updates monthly. The file should have columns for job codes and employee numbers. · A new tab is required to show new employees added to the PDF. · Mandatory skills: Microsoft Excel · ...

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

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

Necesitamos un freelance senior para diseñar e implementar un sistema en Excel 365. · Power Query (ETL, limpieza, consolidación) · Power Pivot/DAX · VBA · ...

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. · This role is focused on data collection, organization, validation, · and documentation. ...

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 looking for a Spanish speaking Data Automation Specialist who's equally skilled with Excel/Power Query and generative AI. · We work on real projects like Automate reinsurance calculations for insurance companies (Power Query + DAX), Transform 3day Excel processes into 5min ...

We are looking for a skilled freelancer to assist in transforming multiple Excel workbooks into Excel Power Query. · Data manipulation and transformation using Power Query features. · ...

+Job summaryConvert TXT GL file into a well-structured Excel file using Power Query code. · +Analyze the TXT file format and develop necessary code to import, clean and organize data into Excel for easy analysis. · ...

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

I need a Query for Power BI/Power Query to pull data from the Pipedrive API. The larger data sets use cursor-based pagination with a limit of 500 records per page. · ...

I export Purchase Orders from my ERP (Odoo v18) in a fixed format and need to use Excel Power Query to transform these files so they match the different heading structure and formatting requirements of multiple supplier ordering portals. · ...