Power BI Developer | Data Analytics & BI Services

About Me

👤 Profile

Hello! I’m Muhammad Affaf, a Results-driven BI Developer with 3+ years of experience turning data into actionable insights. I excel at solving complex problems and optimizing business processes.

💡 Skills & Expertise

Specialized in Power BI, SQL, ETL, and Data Warehousing, creating interactive dashboards and data models that enable smart, data-informed decisions for businesses.

📜 Certifications

Certified in Microsoft Power BI and Google Data Analytics, with strong knowledge of business intelligence and analytics best practices.

Experience

PwC Switzerland

Power BI Job Simulation | Pakistan (Remote) | Jan 2024 - Present
● Led end-to-end product development, improving efficiency by 25%.
● Conducted market research, boosting customer satisfaction by 20%.
● Developed and optimized CRM systems, enhancing sales operations by 20% and reducing processing time by 15%.
● Collaborated with UX/UI designers to enhance user experience.

Accenture North America

Data Analytics & Visualization | Pakistan (Remote) | Jan 2024 - Present
● Designed and implemented product strategies, boosting revenue by 15%.
● Conducted feature prioritization and system enhancements, reducing operational inefficiencies by 10%.
● Led cross-functional teams to develop customer-centric data models, improving engagement by 25%.
● Utilized Power BI, SQL, and Excel to optimize reporting systems.

Freelance Projects

Power BI & Data Analytics Projects
● Delivered dashboards and reporting solutions for multiple clients.
● Developed interactive visualizations to support strategic decisions.
● Implemented ETL pipelines and data modeling for business insights.

🎓 Certifications

Microsoft Power BI Data Analyst

Preparing Data for Analysis with Microsoft Excel
Harnessing the Power of Data with Power BI
Extract, Transform and Load Data in Power BI
Microsoft PL-300 Exam Preparation and Practice

🎓 View Certificate

Business Analytics

Customer Analytics
Operations Analytics
People Analytics
Accounting Analytics
Business Analytics Capstone

Certificate

Business Data Management & Communication

Financial Accounting: Foundations
Financial Accounting: Advanced Topics
Introduction to Business Analytics: Communicating with Data
Introduction to Applied Business Analytics
Infonomics I: Business Information Economics and Data Monetization
Infonomics II: Business Information Management and Measurement

Certificate

Business English Communication Skills

Business English: Networking
Business English: Meetings
Business English: Planning & Negotiating
Business English: Making Presentations
Business English: Capstone Project

Certificate

Google Project Management

Foundations of Project Management
Project Initiation: Starting a Successful Project
Project Planning: Putting It All Together
Project Execution: Running the Project
Agile Project Management
Capstone: Applying Project Management in the Real World

Certificate

Google Data Analytics

Foundations: Data, Data, Everywhere
Ask Questions to Make Data-Driven Decisions
Prepare Data for Exploration
Process Data from Dirty to Clean
Analyze Data to Answer Questions
Share Data Through the Art of Visualization
Data Analysis with R Programming
Google Data Analytics Capstone

Certificate

Projects

Coca-Cola Customer Analytics

Karachi, Pakistan — October 2023

Conducted digital marketing analysis via Google Analytics, increasing conversion rates by 20%.
Implemented data-driven marketing strategies, reducing bounce rates by 10%.
Led a competitor analysis project, identifying new product opportunities that boosted acquisition by 15%.

View Project

Chocolate Company Sales Department

Karachi, Pakistan — December 2023

Built predictive models to improve e-commerce recommendations, increasing sales by 15%.
Developed a Power BI dashboard, enhancing business intelligence and data accessibility.
Led feature implementation initiatives that improved product strategy and customer targeting.

View Project

Financial Sales & Profitability Dashboard | Power BI

Karachi, Pakistan — April 2025

Business Problem: Organizations struggle to track the financial impact of discounts, measure profitability across segments, and identify growth trends.
Solution: Designed a finance-ready Power BI dashboard that delivers actionable insights on sales performance, cost management, and profit margins.
Key Metrics: Total Sales, Net Sales, Gross Sales, Profit, Profit Margin %, Discounts Impact, Units Sold, and Trend Analysis (Year–Month).
Design Enhancements: Used consistent color coding (Blue: Sales, Green: Profit, Red: Discounts), clean data labels, and a structured narrative layout to highlight key insights and business actions.
Tools & Skills: Power BI, DAX, Power Query, Data Modeling, Visualization, Data Storytelling.

View Project

Coffee Shop Sales – Power BI Dashboard

New York City, USA — January 2024

Overview: Created an interactive Power BI dashboard for Maven Roasters, a fictional coffee shop chain in New York City, to analyze and visualize transactional data.
Key Insights: Identified sales trends and performance metrics using intuitive visuals and KPIs:
- 📈 Total Sales trend over time (Line Chart)
- 💰 KPI Cards for Revenue, Orders, Quantity, and Avg Order Value
- 🗓️ Date hierarchy: Year → Month → Day for deeper time analysis
- 🎨 Modern design with clean layout and 15px rounded corners
Tools & Techniques: Power BI Desktop, DAX for calculations, Power Query for data cleaning, and effective visualization design principles.

View Project

HR Analytics Dashboard – Power BI Project

Kaggle Dataset — February 2024

Overview: Developed an HR Analytics Dashboard in Power BI using Kaggle data to visualize employee demographics, performance, and salary insights for data-driven HR decisions.
Key Insights:
- 👥 Total Headcount: 311 | ✅ Active Employees: 207
- 📊 Gender & Department Distribution (Bar Charts)
- 🍩 Marital Status & Satisfaction Levels (Donut Charts)
- 🗺️ State-wise Employee Distribution (Map Visualization)
Tools & Techniques: Power BI, Excel, DAX, and Kaggle Dataset for data preparation and visualization.

View Project

HR Analytics Dashboard – Employee Insights Report

Global Workforce Data — March 2024

Overview: Built a comprehensive HR Analytics Dashboard in Power BI to analyze employee engagement, retention, and performance for strategic HR decision-making.
Key Insights:
- 📉 High attrition in low-salary roles
- ⏱️ Longer working hours increase turnover risk
- 🚫 Lack of promotions affects morale
- 🏢 Departmental gaps highlight improvement areas
Tools & Techniques: Power BI, Excel, DAX — for data cleaning, modeling, and visualization.

View Project

Employee Promotion Analytics – Power BI Dashboard

Global Workforce Data — July 2025

Overview: Developed a complete Power BI dashboard to analyze key factors influencing employee promotions through data-driven insights.
Key Insights:
- 📊 Promotion Rate by Department, Gender, and Region
- 🎓 Training Effectiveness vs Promotion
- 🏆 Awards & Ratings impact on Promotion Likelihood
- 🎛️ Interactive filters for employee-level trends
Skills Applied: Power Query, DAX Measures, Data Modeling, Dashboard Design & Storytelling.

View Project

Website Traffic Analytics – Power BI Dashboard

Global Web Data — August 2025

Overview: Designed an interactive Power BI dashboard to analyze website traffic and user engagement, helping businesses optimize conversions and retention.
Key Insights:
- 📊 Page Views, Session Duration, and Bounce Rate tracking
- 📈 Conversion Rate and Return Visitor Analysis
- 🕒 Time on Page insights to measure engagement
Tools & Skills: Power BI, DAX, Power Query, Data Modeling, KPI Visualization.

View Project

Inventory Management Dashboard – Power BI

Global Operations — September 2025

Overview: Developed a Power BI dashboard to analyze inventory performance with both operational and financial insights, helping optimize stock and forecasting accuracy.
Key Insights:
- 📦 Stock on Hand (Quantity & Value)
- 📊 Days of Inventory on Hand (DOH) & Forecast Coverage
- 🎯 Target Stock Comparison & Stock Evolution over Time
Data Model: Star Schema with FactInventory, DimProduct, DimPlant, and DimCalendar.
Skills Applied: Power Query, DAX, Data Modeling, Supply Chain Analytics, and Dashboard Design.

View Project

Telco Customer Churn Analysis – Power BI Dashboard

Telecom Sector — May 2025

Overview: Built an interactive Power BI dashboard to analyze telecom customer churn, identify key drivers, and support data-driven retention strategies.
Key Insights:
- 📊 Total Customers, Churned Customers, and Churn Rate %
- 💰 Revenue & Lost Revenue from churned customers
- 🕒 Tenure-based loyalty and contract-type trends
- 📉 High churn in month-to-month contracts and e-check payments
Business Impact: Enabled data-backed decisions for loyalty programs, improved contract policies, and customer support enhancements.
Tools & Skills: Power BI, DAX, Power Query, Data Modeling, Visualization & Storytelling.

View Project

Delivery Data Chatbot – Streamlit App

AI-Powered Web App — October 2025

Overview: Developed an interactive AI-driven chatbot using Streamlit that allows users to query delivery performance data with natural language and receive instant, data-backed responses.
Key Features:
- 💬 Natural Language Q&A — ask data-related questions like “Which delivery person is fastest?”
- 📊 Real-time analytics with tables, KPIs, and bar charts
- 🌦️ Environmental insights (weather, traffic, and distance impact)
- 📍 Geospatial performance overview using distance metrics
- ⬇️ Downloadable results in CSV or Excel format
Tech Stack: Streamlit, Python, Pandas, NumPy, Haversine Formula, Session State.
Use Case: Helps delivery operations teams analyze performance, efficiency, and external factors using conversational AI.

View Project

Our Services

Power BI Dashboards

Interactive and insightful dashboards to visualize KPIs, uncover trends, and enable data-driven decisions.

Data Analytics & Reporting

Advanced data analysis using SQL, Excel, and Power BI to transform raw data into actionable business insights.

Automation & ETL

Automate workflows and streamline data pipelines using Python, Power Automate, and cloud integration tools.

Cloud Data Solutions

Build scalable, secure, and efficient data systems on Azure and other cloud platforms for seamless operations.

Contact Me

Contact Info

Karachi, Pakistan

muhammadaffaf746@gmail.com

+92 304 2365964

GitHub

Muhammad Affaf

Hello 👋 I’m Muhammad Affaf Data Analyst

I'm a Data Analyst, Business Analyst, and Power BI Developer

About Me

👤 Profile

💡 Skills & Expertise

📜 Certifications

Experience

PwC Switzerland

Accenture North America

Freelance Projects

Skills

🎓 Certifications

Microsoft Power BI Data Analyst

Business Analytics

Business Data Management & Communication

Business English Communication Skills

Google Project Management

Google Data Analytics

Projects

Coca-Cola Customer Analytics

Chocolate Company Sales Department

Financial Sales & Profitability Dashboard | Power BI

Coffee Shop Sales – Power BI Dashboard

HR Analytics Dashboard – Power BI Project

HR Analytics Dashboard – Employee Insights Report

Employee Promotion Analytics – Power BI Dashboard

Website Traffic Analytics – Power BI Dashboard

Inventory Management Dashboard – Power BI

Telco Customer Churn Analysis – Power BI Dashboard

Delivery Data Chatbot – Streamlit App

Our Services

Power BI Dashboards

Data Analytics & Reporting

Automation & ETL

Cloud Data Solutions

Contact Me

Get in Touch

Contact Info

Hello 👋 I’m Muhammad Affaf Data Analyst

I'm a Data Analyst, Business Analyst, and Power BI Developer

About Me

👤 Profile

💡 Skills & Expertise

📜 Certifications

Experience

PwC Switzerland

Accenture North America

Freelance Projects

Skills

🎓 Certifications

Microsoft Power BI Data Analyst

Business Analytics

Business Data Management & Communication

Business English Communication Skills

Google Project Management

Google Data Analytics

Projects

Coca-Cola Customer Analytics

Chocolate Company Sales Department

Financial Sales & Profitability Dashboard | Power BI

Coffee Shop Sales – Power BI Dashboard

HR Analytics Dashboard – Power BI Project

HR Analytics Dashboard – Employee Insights Report

Employee Promotion Analytics – Power BI Dashboard

Website Traffic Analytics – Power BI Dashboard

Inventory Management Dashboard – Power BI

Telco Customer Churn Analysis – Power BI Dashboard

Delivery Data Chatbot – Streamlit App

Our Services

Power BI Dashboards

Data Analytics & Reporting

Automation & ETL

Cloud Data Solutions

Thanks for reaching out!

Contact Me

Get in Touch

Contact Info

Social Media