Hello, I'm

Amir Khan.

End-to-End BI Solutions Architect

I don't just build dashboards — I deliver complete Business Intelligence solutions from raw data to boardroom-ready insights. Every layer. Every time.

Power BI DAX Star Schema ETL / ELT SQL Python
Scroll

The Full Picture,
Not Just the Dashboard

I'm a Business Intelligence professional who operates across the entire BI stack. From architecting data warehouses and building clean ETL pipelines, to modeling data into performant star schemas and delivering pixel-perfect Power BI reports — I own every layer of the analytics workflow.

On Upwork I've helped businesses across multiple industries turn raw, fragmented data into clear, actionable intelligence. My clients get one expert for the whole journey — no gaps, no handoffs, no excuses.

And when the problem isn't starting from scratch — when a report is showing wrong numbers, a pipeline keeps silently breaking, or a data model is so slow it's lost the team's trust — I step in, find the root cause, and fix it properly. I audit, optimise, and rescue existing BI infrastructure just as readily as I build it.

Power BIDAXPower Query SQLPythonREST APIs Star SchemaETL/ELTData Warehousing Report DesignSCD Type 2OpenAI
50+ Projects Delivered
5+ Years Experience
100% End-to-End Delivery
30+ Happy Clients

End-to-End BI Services

Every engagement covers what's needed — nothing more, nothing less.

Power BI Development

Interactive dashboards and reports with advanced DAX, custom visuals, row-level security, and optimised data models that load fast and answer the right questions.

DAXPower QueryCustom VisualsRLS

ETL / ELT Pipelines

Robust, maintainable data pipelines that extract from APIs, databases, flat files and cloud sources — transformed and loaded reliably into your target layer.

PythonSQLPower QueryAPIs

Data Modeling

Scalable star and snowflake schemas with properly designed fact tables, conformed dimensions, and SCD handling — the foundation every fast BI layer needs.

Star SchemaSnowflakeSCD Type 2Dimensions

SQL & Database

Complex queries, stored procedures, views, and performance tuning across SQL Server, PostgreSQL, MySQL and cloud databases. Clean, documented, fast.

SQL ServerPostgreSQLIndexingOptimisation

Python & Automation

Data processing scripts, API integrations, PDF/OCR extraction, AI-assisted pipelines and automation tools using Python, pandas, and OpenAI.

pandasAPIsAutomationOpenAI

Report & UX Design

Visually compelling, user-centred report layouts that guide decision-makers to what matters — clear hierarchy, brand alignment, and accessibility built in.

UI/UXBrandingThemesAccessibility
Already have BI infrastructure?

I don't just build it —
I fix it too.

Slow dashboards, broken pipelines, wrong numbers, silently failing ETL — if your existing BI is causing pain, I'll diagnose it, trace it back to the root cause, and deliver a proper fix with documentation.

BI Audit & Health Check

A systematic review of your Power BI reports, DAX measures, data model relationships, and ETL pipelines — documenting every inefficiency, incorrect measure, and hidden bottleneck with a clear remediation plan.

  • → Report & data model structural audit
  • → DAX review for correctness & efficiency
  • → ETL / pipeline logic review
  • → Documented findings + priority fix list
Power BIDAXData ModelETL

Debugging & Root Cause Analysis

Numbers that don't match. Measures that return blank. A pipeline that worked last Tuesday and doesn't now. I trace every issue back to its actual root cause — not just the symptom — and fix it so it stays fixed.

  • → Wrong totals / conflicting report numbers
  • → Broken or misfiring DAX measures
  • → Pipeline failures & silent data drops
  • → Root cause documented, fix delivered
DAXPower QuerySQLPython

Performance Optimisation

Reports taking 3 minutes to load. Queries scanning millions of rows they don't need. ETL jobs that run for hours. I refactor the model, rewrite the DAX, and tune the queries so your team isn't waiting on their own tools.

  • → Slow Power BI report & model optimisation
  • → DAX query plan analysis & rewrite
  • → SQL query & indexing optimisation
  • → ETL pipeline efficiency refactor
DAXSQLPower QueryIndexing

Have a specific issue? Describe it and I'll tell you exactly what I'd do.

Get a Free Diagnosis →

Featured Projects

A selection of client work across the full BI stack. Click any project to see the full case study.

What Clients & Colleagues Say

Real feedback from Upwork clients and LinkedIn connections — across freelance projects, full-time roles, and everything in between.

★★★★★
"

Amir is a Power BI whiz! He developed Power BI with all the tools and even let me learn throughout the process. Automated multiple HR analytics jobs really well and delivered right on target. Highly recommend for any Power BI automation work.

C
Client
Power BI Developer to automate HR Analytics
Upwork · ★ 5.0
★★★★★
"

These guys did the Power BI for me. Well done and looks 100% complete. He answered all questions throughout the job and communication was excellent the whole way through. Very satisfied with the dashboard delivered.

C
Client
Power BI Developer – BigQuery API & Multi Source Data
Upwork · ★ 5.0
★★★★★
"

This RLS issue was unbelievably difficult to resolve. Amir showed great expertise diagnosing why blank data was showing instead of filtered rows in Power BI. Delivered a clear fix with a proper explanation. Excellent communication throughout. Would definitely work with again.

C
Client
Power BI RLS Rule Showing Blank Data Instead of Filtered Rows
Upwork · ★ 5.0
★★★★★
"

Fast turnaround on an urgent Power BI report request. Delivered exactly to spec with the logistics background mask applied correctly. Clean output, zero back-and-forth needed. Will hire again for future urgent tasks.

C
Client
[Urgent] Power BI Report · Logistics Background Mask
Upwork · ★ 5.0
★★★★★
"

Delivered clean, automated monthly and weekly reporting for our logistics submission workflow. Professional, accurate, and understood the data structure without needing hand-holding. Everything formatted exactly as required. Great freelancer.

C
Client
Logistics Monthly & Weekly Use Submission
Upwork · ★ 5.0
★★★★★
"

Urgent DAX, filter, and formatting fixes needed in our Power BI dashboard — Amir jumped in immediately and resolved every issue quickly and correctly. Good communication under a tight deadline. Exactly what you need when things are broken and time matters.

C
Client
Power BI Dashboard Fix – DAX, Filter & Formatting Issues (Urgent)
Upwork · ★ 5.0
★★★★★
"

Solid Power BI development work for our gowork.bi platform. Understood the requirements clearly, built a well-structured report, and delivered on time. Professional throughout and easy to work with. Would recommend to anyone needing reliable Power BI work.

C
Client
Power BI Development · gowork.bi
Upwork · ★ 5.0
Colleague · Same Team
"

For over a year, I had the chance to work along with Amir. I can honestly say he's a gem of a person. Always trying to go beyond and help out his fellow colleagues. Apart from that professionally, he has in-depth knowledge and know-how of how to do the task at hand. Would definitely recommend him for any future prospect. God speed!

QH
Qaiser Hassan
Senior Data Engineer · Databricks, AWS, Azure, GCP
LinkedIn Recommendation
Manager · Same Project
"

I worked with Mr. Amir for one project where he joined as a trainee resource. He took up responsibility and started learning — showing continuous learning and delivery attitude. He became an active developer in no time and started actively supporting development activities. He has a positive learning attitude and shows ownership and responsibility for delivery. Being a Project Manager, I'd find a guy like him as an asset and would keep him in my team.

AA
Ali Ashraf
Agile Coach & Leader · ICI-ACC Coach
LinkedIn Recommendation
Colleague · 1.5 Years Together
"

Amir and I worked in the same team for more than 1.5 years and during this time I found him very professional. He is a very good team player — always on time for standups, meetings, and other team activities. His analytical skills are impressive and the machine learning models he worked on really helped the product. Moreover, I took his Data Science training sessions from him and found his way of teaching splendid.

HS
Hafsa Saleem
Product Analyst & Data Analyst
LinkedIn Recommendation
Colleague · 4–5 Years
"

During the last 4–5 years we collaborated on a number of projects. I noticed that Amir Khan is very good and humble with people and has the ability to maximise his potential in every field. He was always very committed to his tasks and focused on delivering on time — a top performer in every project. I was impressed by his Python, SQL, Data Analytics, and Data Science skills. Anyone would be lucky to have Amir Khan as a colleague.

MH
Muhammad Hamza
Principal Consultant · Development @ Systems Limited
LinkedIn Recommendation
Senior Colleague
"

It's rare that you come across standout talent like Amir. I had the pleasure of recently crossing his path, and I've been impressed by his knowledge and expertise in data science, data analytics, and Node.js. Amir would be a great choice for any company eager to grow its business and gain a competitive advantage over other players in the same industry. I would recommend anyone to get in touch with him.

NA
Nasir Abbas
Senior Full Stack JavaScript Engineer · React.js, Node.js
LinkedIn Recommendation
Mentor
"

Amir Khan is self-motivated, forward-thinking and eager to learn new things and technologies. As a senior software developer I found him active, a dynamic thinker and very cooperative in team work — clear concepts, solid knowledge, positive attitude, and truly passionate about his work. Amir earns my highest recommendations in his field.

MB
M Bilal Khan
Sr Software Developer · Java, Spring Boot, Node, AWS
LinkedIn Recommendation
Direct Manager
"

Amir is a great individual. Although he was here for just an internship, I must say he is really enthusiastic towards learning and growing himself. He is a quick learner and will be a good asset to whomever he works for.

SQ
Sheikh Abdul Qadir
Board Member @P@SHA · CEO @IDRAK.AI
LinkedIn Recommendation

Have a BI Project
in Mind?

Whether you need a complete BI solution from scratch, a Power BI overhaul, a reliable data pipeline, or a rock-solid data model — reach out and let's talk scope.