About Ammar Analytics

I build the reporting that executives actually open

Most BI projects die the same way. Someone builds a beautiful dashboard. It's technically correct. Nobody uses it, because it answers questions nobody was asking, and the numbers don't reconcile with what the finance team already has in Excel.

I've spent my career learning why that happens and how to prevent it. The method is unglamorous: verify before you build. Understand what decision the report is supposed to change. Reconcile every figure against the source system before anyone sees a chart. Then, and only then, design.

That's it. That's why my dashboards get used.

Where I work now

I'm embedded as a BI Engineer at Foxtons, London's largest estate agency, reporting to the Head of Business Analytics and working across the organisation's two highest revenue departments.

Marketing Analytics. A 12 dashboard suite spanning Direct Mail, Aggregators, Website, and a Marketing Overview. It tracks 40+ KPIs including conversion rates across Rightmove, Zoopla, and OnTheMarket, Letters per Valuation Booked, and Paid Search against Organic performance across 7 divisions. It replaced fragmented manual reporting that nobody trusted.

Property Services. A second 12 dashboard suite measuring Move Consultant productivity across teams, divisions, weeks, and days. Outbound call activity, Valuations Booked, lead quality, instruction conversion, all with year on year benchmarking. Senior management can now see field performance in real time and intervene on an underperforming team the same week rather than the next quarter.

The infrastructure underneath. Automated SQL pipelines cut weekly and monthly report turnaround by 80 percent. Scheduled Power BI dataset refreshes keep everything live. Row Level Security enforces division and role based access. Every .pbip file is version controlled in Azure DevOps. The reporting is secure, auditable, and self service. No analyst sits in the middle of it.

That environment is the reason I'm useful to you. When a number is wrong at Foxtons, a C level executive notices within the hour. I've been on the hook for accuracy at that level, not just aesthetics.

Selected work

  • IKEA (via Flow). Four end to end Power BI proofs of concept. Requirements, data modelling, dashboard design, and the final stakeholder presentation.

  • PowerTrack Africa. Lead BI Engineer. Three dashboards delivered end to end, from requirements through to stakeholder ready handover.

  • US healthcare startup. Built the entire analytics function on AWS QuickSight. Patient flow, revenue by service, doctor rebooking rates, hospital reputation, staff performance. They went from no visibility to a leadership view.

  • US advertising startup. Worked directly with the CTO to stand up Power BI reporting across Marketing Performance, Traffic and Conversions, and Profit and Loss.

  • Austrian enterprise client. Full ownership from requirements to delivery. Power BI with SharePoint integration and Microsoft Teams embedding, so reporting lived where the team already worked.

  • VentureDive, internal CRM and Finance. Rebuilt internal reporting and removed 60 percent of the manual work in the CRM process. Presented the finance work directly to the executive team, which changed how resources were allocated the following quarter.

  • Zyne Ventures. Migrated 50 million records. Rebuilt the Python and SQL pipelines and orchestrated them in Airflow. Automated roughly 70 percent of the analytics team's repetitive work at no additional tooling cost.

How I work

  1. Diagnose. The first conversation is about decisions, not data. What are you arguing about in meetings? What gets rebuilt by hand every week? What number does nobody trust?

  2. Verify. Before I build anything, I reconcile your figures against your source systems. Almost every engagement surfaces at least one discrepancy nobody knew existed. This step is where trust gets earned, and it's the step most people skip.

  3. Build. Power BI, with a proper semantic model underneath so the report doesn't collapse the first time someone asks a question you didn't anticipate. Row Level Security, scheduled refresh, version control, documentation.

  4. Hand over. Data dictionary, refresh schedule, and a walkthrough so your team owns it. I don't build dependency.

The stack

Power BI at the core: DAX, Power Query, Row Level Security, scheduled refresh, semantic modelling. Underneath it, SQL Server, Azure Synapse, Azure Data Factory, Microsoft Fabric, Python, and Apache Airflow. Tableau, AWS QuickSight, and Looker Studio when a client already lives there.

Microsoft Certified Power BI Data Analyst (PL 300). Certified Data Engineer, Karachi.AI. BS Computer Science from FAST NUCES, two time Dean's List. MS Computer Science in progress at IBA. IELTS Academic, 8.0.

Let's find out whether this fits

Book a 20 minute call. I'll ask what decision you're trying to make and tell you honestly whether I'm the right person to help. If I'm not, I'll say so, and I'll usually know who is.

Contact

Experience

VentureDive

Business Intelligence Engineer

Zyne Ventures

  • Worked with clients based in Texas, Houston

  • Created all of the company’s dashboards from scratch to streamline all of their processes. Effectively did requirement gathering and involved the stakeholders including business analysts and CEO.

  • Wrote custom Python and SQL ETL Pipelines and debug the old ones for the new data. Streamlined the ETL Pipelines using Airflow. Managed Big data migration of around 50 Million records.

  • Automated about 70 percent of the repetitive tasks using Custom Python and SQL at no additional cost. This increased the productivity and time efficiency of the entire business analyst team

2024 - 2025

Data Scientist

  • Developed an authentication system using ASP.NET, Bootstrap, and PostgreSQL in collaboration with the .NET team.

  • Worked closely with the business team to pitch projects to clients.

  • Ensured seamless integration of the authentication system with existing applications and databases.

.Net Developer

TechSurge Inc
Inseyab Consulting & Information Solutions LLC

Machine Learning Engineer

  • Design, build, and deploy machine learning models.

  • Handle large datasets, develop algorithms, and optimize models using frameworks like scikit-learn.

  • Collaborate with data scientists and software engineers to integrate models into production systems, ensuring scalability and performance.

Foxtons

2025 - Present

Business Intelligence Engineer

  • Embedded as a BI Engineer within Foxtons — London’s largest real estate company — reporting directly to the Head of Business Analytics and collaborating with senior stakeholders across the organisation’s two highest-revenue departments; functioned as a fully integrated member of the internal team, translating complex business requirements into enterprise-grade Power BI solutions that shaped data-driven decision making at leadership level.

  • Designed and delivered a 12-dashboard Marketing Analytics suite across Direct Mail, Aggregators, Website, and Marketing Overview sections — tracking 40+ KPIs including channel conversion rates across Rightmove, Zoopla, and OnTheMarket, Letters per VBO, and Paid Search vs Organic performance across 7 divisions; replaced fragmented manual reporting and improved cross-channel marketing visibility by ∼35%, enabling faster, evidence-based budget and campaign decisions.

  • Built a 12-dashboard Property Services suite measuring Move Consultant (MC) productivity across teams, divisions, weeks, and days — tracking outbound call activity, Valuations Booked (VBO), lead quality, and instruction conversion rates with YoY benchmarking; delivered real-time field performance visibility to senior management, contributing to a ∼30% improvement in MC performance monitoring and enabling faster intervention on underperforming teams.

  • Engineered automated SQL pipelines for scheduled weekly and monthly reports, reducing turnaround by ∼80%; configured automated Power BI dataset refreshes for live data across all dashboards; implemented Row-Level Security (RLS) to enforce division- and role-based access; and version-controlled all .pbip files via Azure DevOps — ensuring secure, auditable, and self-service reporting across multiple organisational tiers without analyst dependency.

  • Applied structured dashboarding frameworks across all 24 dashboards — each suite organised into 4 sections, with a dedicated summary page and 3 deep-dive analytical pages per section; enforced consistency in design, narrative flow, and stakeholder usability from executive-level overviews down to granular performance breakdowns.

  • Led VentureDive’s CRMC + Finance analytics end-to-end (requirements → delivery), delivering Power BI dashboards that reduced CRMC manual work by 60%, optimized resource planning, and improved deal closure rates.

  • Built an end-to-end CRMC analytics module that strengthened client insights and helped secure $1.25M in quarterly deals, while improving profit strategy and saving significant cost.

  • Owned a US healthcare startup analytics module in AWS QuickSight, coordinating directly with the client/BA team and delivering dashboards covering patients trends, revenue by services, rebookings, hospital reputation, and employee performance.

  • Worked on The Helicopter Company (Saudi Vision 2030), helping build the analytics module and operational dashboards from the ground up to support data-driven operational decision-making.

  • Independently delivered Power BI dashboards for an Austrian client, including SharePoint integration and embedding in Microsoft Teams for seamless stakeholder access and adoption.

  • Independently delivered a Tableau POC for a French client, from requirements to implementation, including stakeholder-ready presentations.

  • Developed custom Python + SQL ETL pipelines and automated transformations at scale (including 50M+ records), using advanced SQL (views, window functions, aggregates) to ensure reliable reporting.

  • Built high-impact Power BI dashboards with drill-downs, bookmarks, role-based security (RLS), and custom maps—designed to make insights instantly usable for decision-makers.

  • Delivered professional-grade analytics execution: data dictionaries, maintainable documentation, website/dashboard integration, and accurate cost estimations for analytics solutions.

My Certifications

Location

Karachi, Pakistan

Contacts

+92 336-2349646
ammarullahkhan5@gmail.com

Expertise

Transforming data into impactful stories for my clients