I will automate excel using formulas, power query and power pivot

K
khaled_assadi
K
khaled_assadi
Khaled A
automate excel using formulas, power query and power pivot
Full Screen
automate excel using formulas, power query and power pivot

About this gig

Welcome to your solution for advanced Excel data modeling and automation!


As an Industrial Engineer & BI Developer with 6 years of experience, I build scalable data models and dynamic tools that turn raw operational data into actionable business intelligence.


If you are tired of manual data entry, broken formulas, or messy reports, I am here to streamline your workflow.


What I Offer:

Data Automation: Seamless pipelines using Power Query to clean, merge, and transform messy raw data.

Data Modeling: Efficient relational models using Power Pivot to handle large datasets seamlessly.

KPI Dashboards: Visual executive reports with dynamic charts, filters, and slicers.

Formula Optimization: Expert troubleshooting for complex logic (XLOOKUP, INDEX/MATCH).


Why Work With Me?

Engineering Background: I understand operations, supply chain, and workflows, ensuring data makes operational sense.

Fully Automated: Built with best practices so you can update everything with a single click.

Clean & Organized Architecture.


Let's transform your data today! Please message me before ordering to discuss your project.

  • Tool

    • Excel

  • Chart type

    • Processes
    • KPI
    • Bar chart
    • Analytics

Get to know Khaled A

Khaled A

Industrial Engineer, EXCEL Expert and BI Developer

  • FromIsrael
  • Member sinceJan 2026

  • Languages

    English, Arabic, Hebrew
Hi, I’m Khaled, an Industrial Engineering graduate (B.Sc.) and certified BI Developer. Since 2020, I’ve specialized in bridging the gap between raw data and operational efficiency. I build fully automated Excel data models and interactive BI dashboards to eliminate manual work. My expertise: --> Advanced Excel formulas (VLOOKUP, XLOOKUP, INDEX/MATCH, etc), Power Query & Power Pivot --> Robust Data Modeling & Relations --> Dynamic KPI Dashboards & Automation Let's transform your messy spreadsheets into clear, actionable business insights. Reach out today!

Related tags