Open to BI roles & freelance projects · Lahore, PK

Turning Messy Data Into
Decisions Leaders
Act On The Same Day

I'm Muhammad Faizan, a BI Developer. I build the star schemas, DAX and dashboards that replace 5-hour weekly MIS routines, and now full data systems built with AI, where every number is checked.

Retail sales Power BI dashboard
Executive cash flow dashboard
Project control ERP
COD recovery system
Sector rerouting dashboard
ERP project controls charts
3 Years in BI & analytics
40+ Dashboards shipped
70% Reporting time cut
3 Full systems built with AI
Industries I've worked in
Real estate Construction E-commerce Courier & logistics Food & supply chain Marketing Distribution and more
What I do

Turn Raw Data Into
Decisions People Trust

Four skills that stack into one system: clean data, a model that answers the same way every time, dashboards leaders actually open, and tools that run the routine work for you.

01
40+
Dashboards shipped

Power BI Dashboards

Executive views that answer one question each: where the money is, what is late, and what needs a decision this week.

DAX measuresTime intelligenceRow-level securityDrill-throughPower BI Service
02
70%
Reporting time cut

Data Modeling & SQL

Star schemas, clean joins and tested numbers, so every report agrees with every other report.

Star schemaSCD Type 2Bridge tablesCTEs & window functionsPower Query ETL
03
3
Systems built with AI

AI-Built Data Systems

Full web apps for data entry, approvals and reporting, built end to end with AI-assisted development and feeding live dashboards.

Data entry appsApproval workflowsRole-based accessAI assistantNode.js
04
5+ hrs
Saved every week

MIS Automation & KPIs

KPI frameworks and automated pipelines that replace copy-paste reporting and catch problems before the meeting does.

KPI frameworksAutomated refreshReconciliationExcel & Google SheetsAlerts
How I work

Four Steps From Messy Sheets To Trusted Numbers

01

Discover

Sit with the people who decide, find the number they check every Monday, and why today's version doesn't work.

02

Model

Design the star schema, facts, dimensions and bridge tables, so every report answers the same way.

03

Build

Write the DAX, build the visuals, wire up security and drill-throughs, and test edge-case dates and filters.

04

Ship & Train

Publish, schedule refresh, and walk the team through it until they trust and actually use the number.

Selected work

Work That Speaks For Itself

Three systems I built end to end with AI, shown with fictional data, plus a real client project and Power BI case studies. Open any card for the full breakdown.

AI + BI

I Build With AI, And I Check Every Number

AI writes a lot of my code now. My job is the part it can't do: knowing what the business actually needs, and proving the number is right before anyone acts on it.

AI-built apps

Web apps for data entry, approvals and attendance, built with AI-assisted development and feeding live dashboards.

Ask your data

An assistant managers can question in plain English or Roman Urdu, answering from live data.

Number checks

Every AI answer is checked against the source totals before it is shown. No made-up figures.

Faster delivery

Ideas go from a sketch to a working tool quickly, so the team gets the view while the decision still matters.

Muhammad Faizan
40+
Dashboards shipped
70%
Reporting time cut
About me

I'm Faizan, A BI Developer Who Starts With The Decision, Not The Dashboard.

I've spent 3 years building BI across real estate, construction, e-commerce, supply chain and marketing, for teams that were still running their MIS out of scattered Excel files.

My work covers the full stack: cleaning data in Power Query, modeling it into proper star schemas, writing the DAX that makes time intelligence and security work, and shipping it where leadership can trust it. Today I also build the apps that collect the data in the first place.

Every project starts with one question: what decision does this data need to support?

Power BI & DAX95%
Power Query & data modeling90%
SQL85%
AI-assisted development85%
Experience

Where I've Done The Work

APR 2026 – PRESENT
Lahore, Pakistan

BI Developer / Data Analyst

Zameen Developments
  • Built 40+ Power BI dashboards across cash flow, manpower, sales acquisition and project performance, cutting manual reporting effort 70% within 2 months.
  • Built a unified star-schema model with cost-overrun alerts across 3 active projects; variances now surface within 24 hours.
  • Automated weekly MIS prep (5+ hrs/week) via Power Query ETL across Excel and Google Sheets.
  • Implemented USERELATIONSHIP, SAMEPERIODLASTYEAR, TOTALYTD and dynamic SWITCH-based metric selectors for executive reporting.
  • Built end-to-end internal web apps with AI-assisted development (data entry, approval workflows, attendance tracking) that feed live dashboards directly.
  • Added an AI assistant inside the reporting tool so managers can ask questions in plain language, with a number check before every answer.
AUG 2025 – MAR 2026
Lahore, Pakistan

Data Analyst, E-commerce & BI

Leopards Courier Services
  • Designed a 20-KPI leadership framework covering COD revenue, shipment volume and regional targets, eliminating a 2-day reporting delay.
  • Cut manual MIS effort 50%+ via automated Power BI and Excel pipelines.
  • Rebuilt Power Query pipelines with type enforcement, validation and deduplication.
NOV 2024 – AUG 2025
Lahore, Pakistan

Accounts & Supply Chain Analyst

Seasons Foods
  • Replaced a 2-day manual reconciliation across 500+ SKUs with structured Excel models, cutting turnaround 40%.
  • Identified slow-moving SKUs, directly reducing over-ordering.
FEB 2024 – OCT 2024
Lahore, Pakistan

Data Analyst, Marketing Analytics

Marketing Prism Official
  • Unified 5 marketing platforms into one Power BI dashboard, improving campaign tracking accuracy 30%.
  • Analyzed ROI and conversion by channel, directly shaping budget allocation.
FAQ

Questions Worth Asking First

Are you open to full-time roles?
Yes. I'm open to BI Developer, Data Analyst and BI Engineer roles, onsite in Lahore, hybrid, or fully remote.
Do you take freelance projects?
Yes: Power BI dashboards, data models, MIS automation, and small data-entry or reporting apps. Tell me the decision you need to make and I'll tell you what it takes.
Which tools do you use?
Power BI (DAX, Power Query, Service, RLS), SQL, Excel and Google Sheets, and Node.js web apps built with AI-assisted development. I'm currently building hands-on Microsoft Fabric skills (Lakehouse, Dataflow Gen2, Direct Lake).
Can you work with company data that must stay private?
Yes. The systems on this page run on the company's own server or PC, and every screenshot here uses fictional data for exactly that reason.
Do you work with teams outside Pakistan?
Yes. I've delivered a client project for a distribution business in Tanger, Morocco, and I'm comfortable working across time zones.
Get in touch

Let's Talk About Your Data

Send the form and you'll get a reply within a day or two. A job, a project, or just a question about a dashboard, all welcome.

Emailraofaizan424@gmail.com
LocationLahore, Pakistan · open to remote
I reply to every message. Your details are never shared.

Your Next Report Shouldn't Take A Week

Every week the numbers live in scattered sheets is a week someone decides without them. Let's put the right number in front of the right person.

Get in touch Power BI · SQL · Data modeling · AI-built systems