Amir K.

If your Power BI reports are broken, your data isn’t trustworthy, or you need a BI system built properly from scratch, you've come to the right place. Most Power BI freelancers stop at pretty visuals. I fix what’s broken underneath. 🔧 I’m Muhammad Amir Khan, a Data & BI Team Lead and Senior Business Intelligence Engineer with 7 years of experience building Power BI solutions that executives actually trust and use. While most developers focus only on dashboards, I work from the data layer upward: source-level cleanup, Power Query transformations, semantic modeling, advanced DAX, Row Level Security, refresh, deployment, governance, and performance optimization. Currently, I lead the Data & BI function for a $20M ARR aviation company in the Middle East, where I’ve built 15+ production Power BI dashboards that eliminated 90%+ of spreadsheet-based reporting for executive leadership. 💡 What I Do Best Power BI Rescue & Optimization If your report has incorrect totals, duplicate rows, slow refreshes, broken DAX, RLS issues, or numbers that don’t match the source data, I diagnose and fix it. Common issues I solve: • Duplicate rows and grain mismatches • Broken DAX and incorrect aggregations • Refresh failures and performance bottlenecks • RLS not filtering correctly • Timezone and date logic inconsistencies • Dashboard data not matching source data These are the problems most freelancers struggle to isolate. End-to-End BI Solutions I build complete BI systems, not just reports. From business requirements through data modeling to executive dashboards, I create scalable single sources of truth. Recent example: built QualDerm Partners’ Triage & Referral Dashboards with 30+ DAX measures on Snowflake, including full semantic model documentation. Advanced DAX & Data Modeling • Context transition, time intelligence, and debugging • Field Parameters and dynamic reporting • Row Level Security across multi-entity structures • Star schema design from messy operational data • Performance optimization for large models Multi-Source Data Consolidation I unify data from: • Excel files, SharePoint lists, and document libraries • Azure SQL, SQL Server, and on-prem databases • REST APIs and SaaS connectors • BigQuery, Snowflake, and Fabric • Power Query ingestion with proper refresh and error handling 🛠️ Technical Stack • Power BI: DAX, Power Query, RLS, Field Parameters, DirectQuery, Deployment Pipelines, Power BI Service, Governance, Security • Data: SQL, BigQuery, Snowflake, PostgreSQL, MySQL • Engineering: Python, Pandas, NumPy, ETL/ELT, Airbyte, Git, REST APIs, AWS, GCP • Visualization: Power BI, Looker Studio • Modeling: Star Schema, Semantic Modeling, Data Warehouse Design, Dimensional Modeling • Certifications: PL-300 | DP-600 in progress 📊 Real Client Outcomes The Helicopter Company Built 15+ Power BI dashboards with RLS and DirectQuery, replacing 90%+ of spreadsheet reporting and giving leadership real-time visibility into mission-critical KPIs. QualDerm Partners Built Triage, Call Center, and Referral dashboards with 30+ advanced DAX measures, full semantic documentation, and ongoing refresh in Power BI Service. Raus Diagnosed a 25% KPI variance caused by API changes, rebuilt Power Query pipelines, and reconciled numbers back to source with a documented validation pack. Munchies Optimized dispatch analytics, reducing delivery time by 15%. GoMotive Built telemetry and reliability dashboards that helped engineering teams drive a 25% reduction in product error rates. 🎯 Who I Work Best With You’re a strong fit if you: • Have a Power BI report with wrong numbers or broken logic • Need a complete BI solution from data to dashboard • Are migrating from Excel, Tableau, Looker, or other tools to Power BI • Need advanced DAX, RLS, performance optimization, or governance • Want a fractional BI lead for 10–20 hours per week I work primarily with mid-market companies across the US, UK, Australia, and Europe. 🤝 How I Work I diagnose problems live on discovery calls instead of relying on long questionnaires. I communicate in plain English unless you want technical depth, and I focus on building systems that are accurate, scalable, and actually used. 🚀 If your Power BI reports are broken, your data isn’t trustworthy, or you need a BI system built properly from scratch, reach out and let’s discuss your project.