I will automate and consolidate excel reports using power query

India

I speak English, Hindi, Punjabi, Telugu

Data ANALYST

Hi, I'm Gagandeep, a Data Analyst specializing in Excel, Power Query, Power BI, and SQL. I help businesses turn repetitive and manual reporting processes into automated, refreshable solutions. My expe...
About this Gig

Are you spending hours manually combining and cleaning multiple Excel files?

I can automate your Excel reporting workflow using Power Query so you can spend less time on repetitive data preparation.

What I can help with:

  • Consolidating multiple Excel files
  • Automating data cleaning and transformation
  • Standardizing columns and data formats
  • Removing duplicates and handling revised files
  • Creating refreshable master reports
  • Building KPI summaries
  • Preparing Excel reports for Power BI
  • Setting up folder-based Power Query workflows

What you will receive:

  • Automated Excel/Power Query solution
  • Clean and consolidated data
  • Required transformations
  • KPI/reporting section if needed
  • Testing of the workflow
  • Basic instructions for future refreshes

I focus on creating practical, easy-to-maintain solutions that reduce repetitive manual reporting work.

Please message me before ordering so I can understand your files, reporting requirements, and scope.

Technology:

Excel

•

Power BI

•

PostgreSQL

•

Power Query

•

Other

Analysis type:

Quantitative analysis

Expertise:

Automation

Programming language:

Other

Tools:

Microsoft Excel