Hi, I’m Umair Khalid, Founder of NU Providers
Hi, I’m Umair Khalid, Founder of NU Providers
Embedded Files
A Data Solutions Specialist helping businesses simplify processes with custom Excel & Google Sheets dashboards and data automations.
A Data Solutions Specialist helping businesses simplify processes with custom Excel & Google Sheets dashboards and data automations.
Excel Employee Leave Tracker
Excel Employee Leave Tracker
(Automated Leave Management Dashboard)
(Automated Leave Management Dashboard)
The solution features individual and overall calendar views, allowing managers to track PTO, sick leave, FMLA, partial days, and other custom leave types with intuitive color coding. Built-in conflict checks help prevent overlapping leave for critical backup roles, ensuring uninterrupted operations. Company holidays, employee lists, and leave categories are fully customizable to match organizational policies.
Hire Link:
Click here
Automated PCA Infusion Data Cleanup & Dashboard
Automated PCA Infusion Data Cleanup & Dashboard
(Excel + Power Query)
(Excel + Power Query)
Developed a fully automated healthcare infusion reporting system in Excel using Power Query and Pivot Tables. The solution cleans raw infusion data, calculates key metrics like wastage, duration, and utilization, and generates interactive dashboards with one click for better decision-making.
Click to View Project:
Medical infusion utlizataion and wastage.xlsx
Weekly Sales & Inventory
Weekly Sales & Inventory
This interactive Excel dashboard provides a comprehensive overview of weekly retail sales performance, category trends, and top seller analysis. It enables businesses to monitor key metrics and make data-driven inventory and sales decisions.
Click to View Project:
Weekly Sales_Inventory Report (Updated) - Copy.xlsm
🗓️ Leave Tracker & Yearly Calendar Dashboard
🗓️ Leave Tracker & Yearly Calendar Dashboard
Created a dynamic Employee Leave Tracker & Yearly Calendar Dashboard in Excel to automate leave management. The system tracks employee leaves, holidays, and leave types, and generates an interactive yearly calendar with color-coded visualization and automated leave summaries for each employee.
Click to View Project:
Calander of Employee Leaves updated - portfolio.xlsx
Hotel Booking Analysis Dashboard
Hotel Booking Analysis Dashboard
Designed and developed an interactive dashboard for comprehensive hotel booking analysis. This solution provides critical insights into total bookings, cancellations, availed bookings, customer demographics (adults, children, babies), booking status, trends, and meal type preferences. It empowers hotel management with data-driven decision-making for revenue optimization and operational efficiency.
Click to View Project:
Weekly Sales_Inventory Report (Updated) - Copy.xlsm
🗓️ Leave Tracker & Yearly Calendar Dashboard
🗓️ Leave Tracker & Yearly Calendar Dashboard
Created a dynamic Employee Leave Tracker & Yearly Calendar Dashboard in Excel to automate leave management. The system tracks employee leaves, holidays, and leave types, and generates an interactive yearly calendar with color-coded visualization and automated leave summaries for each employee.
Click to View Project:
Calander of Employee Leaves updated - portfolio.xlsx
Page updated
Google Sites
Report abuse