I will automate excel reports dashboards and data analysis using power query

Pakistan

I speak English, French

Data Analyst Excel , Power BI Specialist

I'm Muhammad Kamran — a Data Analyst, Power BI Developer & Advanced SQL Specialist with 2+ years of experience turning raw data into clear, actionable business intelligence. I've served 5+ internation...
About this Gig

I will create automated Excel dashboards and reporting systems that save your time and eliminate manual work.

I specialize in transforming raw Excel data into dynamic reports, dashboards, and automated workflows using advanced Excel features and Power Query.

What I Offer

I can help you with:

  • Excel Dashboard Creation
  • Automated Reporting Systems
  • Power Query Data Transformation (ETL)
  • Pivot Tables & Pivot Charts
  • KPI Reporting Dashboards
  • Data Cleaning & Structuring
  • Excel Data Analysis
  • Dynamic Reports with Formulas
  • Sales & Finance Reporting Sheets

Tools & Skills

  • Microsoft Excel (Advanced)
  • Power Query
  • Pivot Tables
  • Advanced Formulas (VLOOKUP, INDEX-MATCH, XLOOKUP)
  • Data Visualization
  • Basic VBA (optional automation)

Use Cases

  • Sales Reporting
  • Finance Dashboards
  • HR Attendance & Payroll Reports
  • Inventory Tracking
  • Marketing Performance Reports
  • Business KPI Tracking

Why Choose Me?

2+ years data analytics experience

Strong Excel + Power BI background

International exposure (Germany internship)

Focus on automation & time-saving solutions

Clean, professional reporting systems

Technology:

Google Sheets

Excel

Pandas

Information type:

Competitor research

Contact information

Technique:

Automated

My Portfolio