Skip to content
View khan-powerbi123's full-sized avatar

Block or report khan-powerbi123

Block user

Prevent this user from interacting with your repositories and sending you notifications. Learn more about blocking users.

You must be logged in to block users.

Maximum 250 characters. Please don’t include any personal information such as legal names or email addresses. Markdown is supported. This note will only be visible to you.
Report abuse

Contact GitHub support about this user’s behavior. Learn more about reporting abuse.

Report abuse
khan-powerbi123/README.md

👋 Hi, I'm Shoaib Khan
🎯 Microsoft Certified Power BI & Business Intelligence Data Analyst
📊 Skilled in SQL | DAX | Python | ETL | Data Modeling | Visualization
🏢 Experienced in Insurance, Manufacturing, Healthcare, and IT Service Analytics
🎓 MBA Graduate | GPA 3.8

📂 Explore my featured dashboards below or connect with me on LinkedIn
📧 Reach me: shoaibkhan22@live.com

📊 Featured Power BI Dashboards

⚙️ Manufacturing Operations Forecasting Dashboard (Inspired by Regal Rexnord)

End-to-end Power BI dashboard inspired by Regal Rexnord’s manufacturing KPIs and business structure. Analyzes financial performance, shipment operations, and forecast accuracy using SQL and DAX-driven measures.

💼 Salesforce Revenue Insight – Dynamic Row Level Security (RLS)

Analyzes Salesforce revenue by industry and account type with Dynamic Row-Level Security (RLS) for user-specific visibility. Demonstrates data modeling, DAX role setup, validation, and Power BI App deployment workflow.

🏥 Healthcare Finance & Provider KPI Dashboard

Analyzes billing, patient load, and treatment cost metrics with dark/light mode visuals.

🛒 Retail Sales Performance Dashboard

Tracks total sales, cost, profit %, shipment trends, and salesperson performance.

💰 Manufacturing Finance KPI & Variance Trend Dashboard

Compares target vs actual performance, highlights variance, and visualizes monthly/quarterly patterns.

🧾 Case Study Projects (SQL + Python + Power BI)

🏢 Commercial Insurance Severity & Leakage

End-to-end SQL pipeline and Power BI report analyzing claim severity, reserve leakage, and vendor anomalies.

🖥️ ServiceNow IT Incident SLA Breach Analysis

Python + Power BI project analyzing SLA breaches, response delays, and workload distribution using statistical testing (Z-Test, ANOVA).

Pinned Loading

  1. Commercial-Insurance-Severity-Leakage-SQL-Power-BI Commercial-Insurance-Severity-Leakage-SQL-Power-BI Public

    SQL + Power BI case study detecting claim severity & leakage: reserve adequacy, vendor IQR outliers, missed subrogation/late FNOL, duplicate payments. End-to-end T-SQL (staged → core → mart) + exec…

    TSQL

  2. ServiceNow-IT-Incident-SLA-Analysis ServiceNow-IT-Incident-SLA-Analysis Public

    Python + Power BI project analyzing ServiceNow IT incident data. Identifies SLA breaches, delay patterns, and workload inefficiencies using statistical validation (Z-Test, ANOVA) and interactive KP…

    Jupyter Notebook 1

  3. Salesforce-Revenue-Insight-Dynamic-RLS Salesforce-Revenue-Insight-Dynamic-RLS Public

    Power BI dashboard built using Salesforce opportunity data, featuring revenue KPIs, win-rate analysis, and Dynamic Row-Level Security (RLS) for secure user-based insights.

  4. Manufacturing-Operations-Forecasting-Dashboard-inspired-by-Regal-Rexnord Manufacturing-Operations-Forecasting-Dashboard-inspired-by-Regal-Rexnord Public

    Power BI + SQL project analyzing manufacturing financial and operational performance, including sales forecasting, shipment efficiency, and profitability across multiple product divisions.

  5. Healthcare-finance-provider-dashboard Healthcare-finance-provider-dashboard Public

    Power BI dashboard for healthcare provider KPIs and financial performance. Tracks billing amount, medication/treatment cost, LOS, and patient load with dark/light mode visuals.

  6. Retail-sales-performance-dashboard Retail-sales-performance-dashboard Public

    Power BI sales performance dashboard analyzing total sales, cost, profit %, shipments, and salesperson drilldowns.