Pinned Loading

1. powerbi-patient-risk-monitoring powerbi-patient-risk-monitoring Public

   A Power BI decision support dashboard project for monitoring key healthcare quality KPIs. Includes full cycle from requirements gathering, Data Mart building, ETL automation, to Power BI developmen…

2. powerbi-pharmacy-staffing-dashboard powerbi-pharmacy-staffing-dashboard Public

   A Power BI solution to forecast pharmacy workload and optimize staffing using real-time outpatient and historical data.

3. python-hospital-data-visualization python-hospital-data-visualization Public

   Automates the download and visualization of hospital data from the Taiwan NHI website using Python. Includes CSV to Excel conversion, chart generation, and structured logging.

   Python

4. sql-automation-pharmacy-report sql-automation-pharmacy-report Public

   Automates SQL-based extraction and Excel export of outpatient prescription statistics from a hospital database using Python and pyodbc.

   Python

5. vba-employee-data-compare vba-employee-data-compare Public

   Automates employee record comparison between two datasets using VBA. Detects duplicate IDs, highlights discrepancies, and generates a formatted results sheet.

   VBA

6. vba-pharma-delivery-acceptance vba-pharma-delivery-acceptance Public

   VBA macro to automate the generation of pharmaceutical delivery acceptance reports using Word mail merge templates and Excel data sources.

   VBA