Power Query-Driven PDF Bill Automation Specialist
Budget: $30 – $250 USD
Job Title: Power Query Expert - Tailor-Made PDF Bill Automation & Visualization
Project: I need a skilled Power Query specialist to build a customized solution for automating the extraction and organization of electricity and water bill data (PDF format) into a specific Excel structure. We will provide sample bills AND a detailed mockup of the desired final output format. This ensures your solution directly addresses our exact needs.
Data Points (extracted from PDFs):
Company Name
Flat/Shop Number
Account Number
Disconnection Notices (flag/status)
Electricity, Water Consumption
Municipality
Period Start Date, End Date
Previous Balance, Total Amount Due
Key Requirements & Deliverables:
Automated Extraction & Formatting: Develop a Power Query workflow to:
Pull data points reliably from PDFs according to the provided format guide .
Structure the extracted data into Excel sheets exactly matching our desired output mockup . This includes company-specific segmentation.
Video Tutorial (Comprehensive): Create a step-by-step video demonstrating:
Setting up Power Query, connecting to PDFs, and every stage of data transformation until the final formatted output is achieved. The tutorial should mirror the exact solution and logic used.
Maintainability & Refinement: The solution should be scalable for monthly updates with new bills and adaptable to minor format changes.
Payment Terms:
50% Deposit upon acceptance and receipt of the sample bills/output format.
Remaining 50% released upon delivery of the working Power Query solution and the comprehensive video tutorial.
Ideal Candidate: Proven Power Query expertise, PDF data handling skills, strong attention to detail, and a commitment to delivering a tailored, documented solution.
By providing upfront examples, we ensure clarity and a solution precisely aligned with your vision.
Project: I need a skilled Power Query specialist to build a customized solution for automating the extraction and organization of electricity and water bill data (PDF format) into a specific Excel structure. We will provide sample bills AND a detailed mockup of the desired final output format. This ensures your solution directly addresses our exact needs.
Data Points (extracted from PDFs):
Company Name
Flat/Shop Number
Account Number
Disconnection Notices (flag/status)
Electricity, Water Consumption
Municipality
Period Start Date, End Date
Previous Balance, Total Amount Due
Key Requirements & Deliverables:
Automated Extraction & Formatting: Develop a Power Query workflow to:
Pull data points reliably from PDFs according to the provided format guide .
Structure the extracted data into Excel sheets exactly matching our desired output mockup . This includes company-specific segmentation.
Video Tutorial (Comprehensive): Create a step-by-step video demonstrating:
Setting up Power Query, connecting to PDFs, and every stage of data transformation until the final formatted output is achieved. The tutorial should mirror the exact solution and logic used.
Maintainability & Refinement: The solution should be scalable for monthly updates with new bills and adaptable to minor format changes.
Payment Terms:
50% Deposit upon acceptance and receipt of the sample bills/output format.
Remaining 50% released upon delivery of the working Power Query solution and the comprehensive video tutorial.
Ideal Candidate: Proven Power Query expertise, PDF data handling skills, strong attention to detail, and a commitment to delivering a tailored, documented solution.
By providing upfront examples, we ensure clarity and a solution precisely aligned with your vision.