目的:為保證臨床服務品質與持續改善內部流程,指標監測是當今醫院品管工具中不可或缺的一環,但非資訊專業人員面對雜亂的巨量資料時,作業往往耗時費力,故嘗試導入商業智慧(Business Intelligence, BI)大數據處理工具,盼提升醫院行政效率。方法:本研究運用Excel之Power Query增益集,以門診十項重要檢驗(查)相同病人28日內再執行率之指標收集分析流程為研究對象,建置資料處理模型,設計自動化流程取代人工作業。結果:該指標處理流程自959分鐘降至18分鐘,節省約98%作業時間。推估50至200指標項目階段性導入Power Query後,人事成本一年約節省25萬至150萬元。結論:本研究成果除提升作業效率,兼具減少隨機錯誤、統計條件調整便利、延長電腦使用效能與具備橫向運用之附加效益。
Objectives: Indicator surveillance is critical in hospital quality management to uphold clinic service quality and continue improving internal processes. However, substantial time is required for non-information technology personnel to collect and analyze indicators because of dirty data and various data formats. This study aims to evaluate the effectiveness of introducing a business intelligence big data analysis tool to improve administrative efficiency. Methods: This study uses a user-friendly and accessible Excel Power Query addin to create a data processing model to import, normalize, and integrate data from various sources. The indicators include 10 critical examinations for the same outpatient reevaluated for the same examination within 28 days. This model simplifies traditional tasks through process automation. Results: The data processing model performs excellently. It reduces work time by approximately 98%, from 959 minutes to 18 minutes. Additionally, according to an initial assessment conducted after having introduced this business intelligence method to 50-200 indicators surveillance, the hospital could reduce annual personnel costs by approximately NT$250,000 to NT$1,500,000. Conclusions: The use of a business intelligence analysis tool increases work efficiency. Additional benefits of automated processing include a decrease in random errors, quick adjustment of statistic conditions, longer-lasting computer performance, and reuse of models in similar data manipulation procedures.