Build Automated Excel Dashboard with Power Query

+Job summary · We're seeking an experienced Power Query Specialist to diagnose, stabilize, and optimize an existing Excel workbook that relies heavily on Power Query. · +ResponsibilitiesFixing complex query chains. · Refresh issues. · ...

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

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

I need a senior expert to 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 · Overdue POs. · ...

We are seeking an experienced Excel Power Query specialist to assist with data transformation and analysis tasks. · We need someone who can build an excel solution using power query. · ...

I need a POWER QUERY file to pull data from a PDF. The file needs to update monthly based on changes in the PDF. · ...

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 looking for a skilled freelancer to assist in transforming multiple Excel workbooks into Excel Power Query. · This is an excellent opportunity for someone who enjoys working with Excel and has a strong understanding of data queries and automation. · ...

Job for a Data Automation Specialist who is skilled with Excel/Power Query and generative AI. The role involves automating manual processes into elegant automated systems. Required skills include advanced Power Query, professional Excel/DAX, VBA/Macros and basic-intermediate Pyth ...

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

Data Operations Specialist responsible for data collection organization validation and documentation using Excel Power Query to support a long-term data ingestion automation workflow. · Data Ingestion Download predefined CSV datasets weekly Refresh data using Excel Power Query Pr ...

I need a Power Query for the Pipedrive API with cursor-based pagination to pull data from the Pipedrive API and loop until next_cursor returns null. · ...

We are looking for an experienced developer to create an AI-powered omnichannel system. The ideal candidate should have a strong background in AI technologies and user interface development. · PythonArtificial IntelligenceMachin Learning · ...

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

A skilled freelancer is needed to convert a TXT file into a well-structured Excel file using Power Query code. · Analyze the TXT file format · Develop necessary code to import, clean, and organize data into Excel · ...

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

The goal is to design a sophisticated, · scalable Excel-based data infrastructure · and ETL for approximately 80,000 retail SKUs, · primarily using Excel features (Power Query/VBA/Macros), Power Automate/Sharepoint, · Power Automate Desktop, · & Python. · ...

Job summary · Transform files using Excel Power Query to match supplier ordering portal requirements. · ...

Need an experienced Excel Power Query specialist to build an automated reporting workflow. · ...