I will clean, transform, and merge data using excel power query

Egypt

I speak Arabic, English

Data Analyst Power BI Specialist

Hi, I am Rami, a Data Analyst specializing in Power BI, Excel, and Power Query. I help businesses transform messy raw data into clean models, automated reports, and interactive dashboards that drive b...
About this Gig

Are you struggling with messy, inconsistent, or unstructured data? I will clean, transform, and organize your datasets using Excel and Power Query so your data is structured, accurate, and ready for analysis or reporting.

What I Can Do For You:

  • Remove duplicates and clean unwanted spaces, characters, or empty rows
  • Fix data types (dates, currencies, text, numerical values)
  • Split, merge, and organize columns (names, addresses, IDs)
  • Unpivot and pivot data to structure it into flat, normalized tables
  • Merge and append multiple files, sheets, or tables into a single source
  • Build automated Power Query refresh pipelines (update with 1 click when new data arrives)
  • Conditional columns, lookup formulas, and data validation rules

Tools & Technologies:

  • Microsoft Excel
  • Power Query (M-Code)
  • Google Sheets

Why Choose My Service?

  • 100% data confidentiality and privacy guaranteed
  • Clean, documented, and reusable solutions
  • Fast turnaround and responsive communication

Please reach out with a sample of your file and your requirements before placing an order so we can confirm the best package for your project.

My Portfolio