Hello, I'm
I don't just build dashboards — I deliver complete Business Intelligence solutions from raw data to boardroom-ready insights. Every layer. Every time.
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.
Every engagement covers what's needed — nothing more, nothing less.
Interactive dashboards and reports with advanced DAX, custom visuals, row-level security, and optimised data models that load fast and answer the right questions.
Robust, maintainable data pipelines that extract from APIs, databases, flat files and cloud sources — transformed and loaded reliably into your target layer.
Scalable star and snowflake schemas with properly designed fact tables, conformed dimensions, and SCD handling — the foundation every fast BI layer needs.
Complex queries, stored procedures, views, and performance tuning across SQL Server, PostgreSQL, MySQL and cloud databases. Clean, documented, fast.
Data processing scripts, API integrations, PDF/OCR extraction, AI-assisted pipelines and automation tools using Python, pandas, and OpenAI.
Visually compelling, user-centred report layouts that guide decision-makers to what matters — clear hierarchy, brand alignment, and accessibility built in.
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.
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.
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.
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.
Have a specific issue? Describe it and I'll tell you exactly what I'd do.
Get a Free Diagnosis →A selection of client work across the full BI stack. Click any project to see the full case study.
Executive KPI dashboard tracking regional sales, pipeline, and forecast accuracy across multiple business units with drill-through and RLS.
View Case Study →P&L, balance sheet, and cash flow reports with YoY comparisons, drill-through pages, and automated month-end refresh pipeline.
View Case Study →Complete HR solution covering attrition, headcount trends, and salary benchmarking — built on a star-schema HR data mart.
View Case Study →Automated pipeline ingesting REST APIs, Excel exports, and SQL databases into a centralised SQL Server data warehouse on a scheduled basis.
View Case Study →Pipeline extracting structured financial data from scanned PDF income statements using OpenAI Vision, storing results in SQLite with full audit trail.
View Case Study →End-to-end star schema for a multi-store retailer — fact tables, conformed dimensions, SCD Type 2 customer history, and full documentation.
View Case Study →Migrated legacy Access database to SQL Server, redesigned queries with proper indexing strategy — delivered 10× query performance improvement.
View Case Study →Branded, reusable Power BI template with custom theme, corporate colours, intuitive navigation, and conditional formatting guidelines.
View Case Study →Full solution: source system ETL → dimensional model → Power BI reports for inventory, logistics KPIs, and supplier performance tracking.
View Case Study →
3-page Power BI dashboard analysing Amazon India fashion sales for Q2 2022 — order status, city-level breakdowns, and category-level revenue trends.
View Case Study →
Multi-channel marketing ROI dashboard comparing Online, Social, Stores, and Outlet performance across US states and three product brands.
View Case Study →
Enterprise-grade single-page dashboard covering $1.01bn in global Contoso sales across FY97–FY99 — time intelligence, regional breakdown, and dark executive design.
View Case Study →
4-page financial dashboard for a Saudi aviation company — P&L, balance sheet, and procurement KPIs with full budget vs actual tracking in SAR.
View Case Study →
5-page workforce analytics platform tracking 739 employees — headcount, Saudization compliance, gender diversity, attrition analysis, and workforce cost.
View Case Study →
Analysing 130 restaurants and 138 consumer profiles across Mexico — cuisine preference matching, demographic rating patterns, and bookmark-based navigation.
View Case Study →
Live weather dashboard powered by OpenWeatherMap API — Python pipeline ingests real-time data for Pakistani cities into SQLite, Power BI delivers the analytics.
View Case Study →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.
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.
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.
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.
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.
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.
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.
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!
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.
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.
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.
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.
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.
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.