I will clean and transform your excel data using power query
Power BI and Power Automate Specialist
About this Gig
Need clean, reliable Excel data without manually repeating the same steps?
I will use Microsoft Excel Power Query to clean, transform and prepare your data for analysis and reporting.
I can help with:
- Removing duplicates and unnecessary data
- Fixing data types and inconsistent values
- Filtering and restructuring data
- Combining and transforming tables
- Creating repeatable Power Query steps
- Preparing data for dashboards and reports
- Making your data easier to refresh and maintain
What you will receive:
- A clean and organised Excel workbook with the Power Query transformations applied to your data, making repetitive data preparation easier to manage and refresh.
Packages are based on the number of Excel tables included, with additional tables available as a Gig Extra.
Please message me before ordering if your data is particularly large or complex, so I can confirm the scope is suitable.
I focus on practical, reliable solutions rather than unnecessary complexity.
Technology:
Excel
Expertise:
Data manipulation
•
Data validation
•
Transformation
My Portfolio
FAQ
What type of files can you work with?
I work primarily with Excel workbooks and tables. Please contact me if you're unsure whether your file is suitable.
Can you work with multiple Excel tables?
Yes. Each package includes a set number of tables, and additional tables can be added as a Gig Extra.
Will the Power Query steps be refreshable?
Yes. The Power Query transformations will be set up so the data can be refreshed using the same transformation steps.
Can you connect Power Query to external data sources?
This Gig focuses on Excel data. Please message me first if you need an external data connection.
Can you build a dashboard as well?
This Gig focuses on data cleaning and transformation. I can discuss dashboard requirements separately if needed.

