Zafran Ali Khan

Available to hire

I’m a Results-driven Data Analyst skilled in Power BI, Excel, SQL, and R, with hands-on experience in transforming raw data into actionable insights through dashboarding, DAX, Power Query, and data modeling.

About

I’m a Results-driven Data Analyst skilled in Power BI, Excel, SQL, and R, with hands-on experience in transforming raw data into actionable insights through dashboarding, DAX, Power Query, and data modeling. I have a proven ability to deliver business-ready reports, perform statistical analysis, and support data-driven decisions through real-world projects and internship experience at the Pakistan Bureau of Statistics. I enjoy turning complex data sets into understandable and actionable business intelligence that helps organizations improve their strategies and operations.

  • Joined June 2024

Languages

  • EnglishFluent
  • UrduFluent

Industry experience

  • Computers & Electronics
  • Education
  • Other
  • Government
  • Financial Services
  • Professional Services
  • Retail

Projects · 3

Extracted and modelled 5 years of financial data, transformed it using Power Query , summarised with Pivot Tables, calculated 20+ KPIs using INDEX, SUMIFS, and logic formulas. Built a comparative dashboard for cross-sectional and time series financial health insights. Data DataVisualization Dashboards FinancialAnalyst Excel PowerQuery

  • Project Manager

Here i visualized the data according to specified criteria.

  • Data Scientist
  • Data Visualizer

Leveraging a dataset from Kaggle, I meticulously cleaned raw data, delved into insightful analysis using pivot tables and charts, and culminated in crafting dynamic and interactive dashboards. Excited to showcase my journey into the world of data analytics! dataanalytics datavisualization dataanaysis excelanalytics businessanalytics dashboarding dashboards

  • Data Scientist
  • Data Visualizer

Work experience

DATA ANALYST & IT INTERN · Pakistan Bureau of Statistics (PBS)Aug 2024 – Sep 2024 · 2 mos

Developed Power BI dashboards after cleaning government data to visualize KPIs across population, education, and employment sectors. Performed data cleaning, SQL querying, and Excel analysis to support real-time reporting and data-driven policy insights. Delivered real-time insights to support policy planning through KPI tracking, visual storytelling, and self-service BI tools.

Education

Bachelor of Business Administration · NAMAL University Mianwali2022 – 2026

BBA in Data Analytics

Intermediate in Computer Science · Superior College Mianwali2019 – 2021

Certifications and awards· 7

Intoduction to Power Bi by DataCamp2024

learned Power BI basics, visualizations, data analysis

Introduction to DAX in Power BI2024

Learned about Data analysis techniques by using DAX functions and M language.

Data Analyst Career Track – Power BI – DataCamp2030 – 2025
Data Analytics & Business Intelligence – DigiSkills2030 – 2025

Hire Zafran Ali Khan today

Post a job and invite Zafran, or contact them directly. No hidden commission.

Post a job