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.

Zafran Ali Khan

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.

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. 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.

See more

Language

English
Fluent
Urdu
Fluent

Work Experience

DATA ANALYST & IT INTERN at Pakistan Bureau of Statistics (PBS)
August 5, 2024 - September 13, 2024
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 at NAMAL University Mianwali
October 27, 2022 - July 31, 2026
BBA in Data Analytics
Intermediate in Computer Science at Superior College Mianwali
July 15, 2019 - June 30, 2021

Qualifications

Intoduction to Power Bi by DataCamp
May 1, 2024 - May 5, 2024
learned Power BI basics, visualizations, data analysis
Introduction to DAX in Power BI
May 6, 2024 - May 10, 2024
Learned about Data analysis techniques by using DAX functions and M language.
Data Analyst Career Track – Power BI – DataCamp
January 11, 2030 - August 3, 2025
Data Analytics & Business Intelligence – DigiSkills
January 11, 2030 - August 3, 2025
Data Analyst Bootcamp (Power BI, Excel, SQL) – Alex Freberg
January 11, 2030 - August 3, 2025
R Programming for Data Science – MindLuster
January 11, 2030 - August 3, 2025
MySQL for Data Analytics – Alex the Analyst
January 11, 2030 - August 3, 2025

Industry Experience

Computers & Electronics, Education, Other, Government, Financial Services, Professional Services, Retail
    uniE621 Financial Analysis and Health Dashboard for comparison
    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
    paper Data Visualization
    Here i visualized the data according to specified criteria.
    uniE621 Bikes Sales Dashboards
    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