Zafran Ali Khan

Business Analyst

About

📊 Bridging the Gap Between Data & Decision-Making Hi! I’m Zafran Ali Khan, a passionate and certified Data Analyst skilled in Power BI, Tableau, Excel, SQL, Python, and R. I specialize in building clean, insightful dashboards that turn raw data into clear, actionable decisions. 🎓 I’m currently completing my BBA with a focus on Data Analytics at Namal University, Mianwali. Alongside my degree, I’ve completed 17+ professional Data Analytics and Power BI courses and delivered freelance projects for clients across business, education, and nonprofit sectors. 🔍 What I Do Best: 📊 Design interactive dashboards in Power BI, Tableau, and Excel 🧹 Perform data cleaning & transformation using SQL, Power Query, Python, and R 📈 Analyze survey, financial, HR, and demographic datasets 📌 Create visually clear, business-ready reports for smarter decisions 🧠 Apply statistical models (regression, multivariate) using R, SPSS, and Python 📂 Projects Highlights : - Sales, HR & Financial Dashboards (Power BI & Excel) - Hunger Index Analysis (R programming) - Final Year Project: Natural toothpaste from eggshells + ML dental detection model - Survey & academic research dashboards for decision support 🧰 Tools & Skills: Power BI | Tableau | Excel | SQL | R Programming | Python | Dashboard Design | Data Cleaning | ggplot2 | Pivot Tables | DAX | EDA | Regression | Data Visualization | Business Intelligence 📬 Let’s connect! Whether you’re a client, recruiter, or fellow data enthusiast, I’d love to collaborate on your next data project or internship opportunity.

Country

Pakistan

City

Islamabad

Industry

Higher Education

Skill

MySQL, R (Programming Language), Microsoft PowerPoint, Human Resources (HR), Data Analytics, Business Analytics, Microsoft Power BI, SQL, Databases, Reporting, Business Intelligence (BI), Tableau, Data Visualization, Microsoft Excel, Data Extraction, Financial Reporting, Statistical Data Analysis, Extract, Transform, Load (ETL), Microsoft Power Query, DAX

Experience

Business Analyst

MediCloud Solutions (SMC - Private) Limited

2026-2 - Present · 8 mos

Rawalpindi, Punjab, Pakistan

Business Analyst (Part-Time) | MediCloud Solutions (SMC PVT) Ltd. Being a BA, my duties are following and beyond them... Being a Business Intelligence & Analytics professional, Transform raw data into actionable insights for decision-making across medical and other sectors. As a Power BI Developer working in Power BI Development, like designing interactive dashboards and visualizations to monitor key metrics and trends effectively. Excel Analytics: Utilize advanced Excel functions, pivot tables, and Power Query for detailed data analysis. Data Visualization & Reporting: Create clear, insightful reports to communicate complex findings to stakeholders. Cross-Functional Collaboration: Work closely with teams to understand requirements and deliver data-driven solutions. Project Engagement: Contribute to large-scale projects, applying analytical techniques to optimize business processes. Continuous Learning: Enhance skills in BI tools and analytics while adapting to diverse industry challenges.

Student

Namal University

2022-9 - Present · 4 yrs 1 mo

Mianwali District, Punjab, Pakistan

Bachelor of Business Administration student specializing in Business Analytics and a skilled in Power Bi, Excel, SQL server, R programming, and Python Data/Business Analyst

Data Analyst & IT Intern

Pakistan Bureau of Statistics

2024-8 - 2024-9 · 2 mos

Islamabad, Islāmābād, Pakistan

Hi there, I'm working as a Data Analyst and IT intern. Where my key responsibilities are to: - Collect Data - Clean, transform and visualize data - work with its IT section - Work with Data Center