Loading...
|
Please use this identifier to cite or link to this item:
https://nccur.lib.nccu.edu.tw/handle/140.119/110665
|
| Title: | 藥妝連鎖業供應鏈商業智慧之研究－以Y公司為例
The study of supply-Chain business-intelligence for the drug & cosmetic Chain store |
| Authors: | 黃瓊玉 |
| Contributors: | 季延平
黃瓊玉 |
| Keywords: | 藥妝連鎖
供應鏈
商業智慧
The Drug & Cosmetic Chain Store
Supply-chain
Business-Intelligence |
| Date: | 2017 |
| Issue Date: | 2017-07-03 14:37:52 (UTC+8) |
| Abstract: | 隨著大者恆大的營運觀念，很多企業邁向連鎖體系，藥妝業亦是。根據MBA智庫百科(2015)指出，現代企業比任何時候都更依賴供應鏈的有效管理方能成功。而藥妝連鎖業的營運品項比任何產業都廣，其供應商更是多類與複雜，如何運用資訊化之力，尤其是日臻成熟又能快速掌握營運與競爭資訊的商業智慧，以提升供應鏈運作效能，而利於決策分析與競爭力，已是藥妝連鎖業當務之急。
有鑑於此，本研究首先針對研究主體之Y公司藥妝連鎖業營運及其供應鏈現況等進行個案研究，次而針對連鎖經營業、供應鏈及其管理、商業智慧與相關議題進行文獻探討，再者採行IDEF0與IDEF3進行Y公司供應鏈流程分析與資訊系統探討，並規劃與設計其商業智慧運作之資料倉儲的觀念模型、邏輯模型、實體模型、系統雛型及應用模型，最後綜整上述研究所得而分析與歸納個案公司供應鏈發展商業智慧重要與注意事項，其結論與建議如下：
結論方面，藥妝連鎖業供應鏈商業智慧之發展，現況是配銷缺乏統籌、供應鏈資訊化低、決策資源不足。而所需是建立基本藥品供應模式與資料倉儲，以收集大量資料發展商業智慧。而個案公司欲發展供應鏈商業智慧，需要了解產業現況與所需、掌握供應鏈商業智慧運作流程與模式、改進資料倉儲模型設計、奠立資訊化基礎、促進運作人才培養。
對Y公司的建議，可從1商業智慧發展之系統化、合理化 、標準化 、配送中心作業整合化投入，2品類管理發展之整合個案公司資訊系統，供應商和第三方資料投入，3企業整體營運面-資源配置優質化、提高市場占有率、提高市場占有率、提高競爭力、降低經營費用、引導生產領域、保護消費者權益投入。而對未來研究的建議是研究資料的增加、研究方法的改變與研究方向的拓展等。
It becomes an important trend that firms invest to develop chain-operation. The drug & cosmetic also invest to develop chain-operation. Based on MBA encyclopedia (2015), firms much more depend on effective SCM now. And commodities of the Drug & Cosmetic are much more & complicated than any industry, they much more invest computerization to develop business-intelligence (BI) and improve SCM performance.
Therefore, the study based on Y firm to explore the operation & supply-chain of the drug & cosmetic, invested to the chain-operation, SCM & BI literature review, then used IDEF0 & IDEF3 to analyze the supply-chain process & information system of Y firm, and plans concept model, logical model, physical model, system prototype & application model of Yfirm. In the end, the study obtained the following conclusion & suggestion：
Conclusions: To BI development of the drug & cosmetic supply-chain: 1.distribution was lacking of integration 2.computerization level was too low 3.decision recourses was enough. Y firm wanted to develop supply-chain BI, it had to master needs of the industry and process & model of supply-chain BI, improved design of data-mining, built computerization base, invested train & education of human-recourse.
Suggestions: To Y firm: 1.to develop BI system 2.to develop category management 3.to improve operation performance. To future research: 1.to add the research data 2.to change the research method 3.to expand the research direstion. |
| Reference: | 中文部分
1. 林存德 “資料倉儲實務應用”,旗標資訊月刊,第62期,民國88年3月,p241-256。
2. 季延平、王存國、范懿文，”決策支援系統“，三民書局，民國85年。
3. 季延平、郭鴻志 “系統分析與設計” ，華泰書局， 民國84年。
4. 徐行，“OLAP多維度資料分析方法”，資訊電腦，一百八十八期，民國85年。
5. 藍中賢、吳郁瑩、李火山、陳銘智譯，Ramaz Elmasro & Shamkadant B. Navathe 著，資料庫系統原理，台北，台灣培生教育出版股份有限公司，民國92 年。
6. 唐君如 “如何規劃資料倉儲”,資訊與電腦,第223期,民國88年2月,p91-95。
7. 陳文華 “透視資料倉儲”,資訊與電腦,第222期,民國88年1月,p247-256。
8. 熊聯勇，連鎖經營的行銷優勢及在我國的實踐，四川師範大學碩士論文，2006年。
9. 曹惠清，淺析企業連鎖經營的優勢，甘肅科技，第24卷第13期2008年。
10. 呂貴興，我國超市零售企業品類管理研究，南京理工大學碩士論文，2007年。
11. 韓光軍。連鎖店行銷，首都經濟貿易大學出版社，2000。
12. 馬士華，林勇，供應鏈管理（第5版），機械工業出版社：2016年07月。
13. 姜小建、解林超，大數據應用對供應鏈管理價值提升的分析，電子技術與軟體工程，2016年第9期，pp205-205。
英文部分
1. Anonymous,”Planning for performance in data warehouse,”Capacity Management review[PPR],vol.23,iss.4,Apr 1995,p1-11.
2. Aranow, E. “Modeling exercises shake up enterprises,” Software Magazine 1991, pp:36-41.
3. Barry R. Berman, Joel R. Evans, Retail Management: A Strategic Approach, 12th Edi., Pearson, 2012.
4. David, C Musker “Reverse Engineer, Protecting & Exploiting Intellectual Property in Electronics,” IBC Conferences, 1998.
5. Davis, K.H. “Lessons Learned in Data Reverse Engineering,” Proceedings of the 8th Working Conference on Reverse Engineering, Suttgart, Germany, 2001, pp: 323-327.
6. Dowming, Yeh, Yuwen, Li, and William, Chu “Extracting entity-relationship diagram from a table-based legacy database,” The Journal of System and Software (81) 2008, pp:764.711.
7. E.F. Codd , S.B. Codd and C.T. Salley “Providing OLAP(On-line Analytical Processing) to User-Analysts:An IT Mandate” .
8. Federal Information Process Standard-FIPS-184: INTEGRATION DEFINITION FOR DATA MODELING (IDEF1X), 1993.
9. Gilmore, James "How to Make Reengineering Truly Effective," Planning Review 23(3) 1995, pp: 39-40.
10. Harjinder S. Gill and Prakash C. Rao ,”The Official Client/Server Computing Guide to Data Warehousing”, Que Corpration.
11. Hugh J. Watson, George Houdeshel , Rex Kelly Rainer, Building Executive Information Systems and Other Decision Support Applications, John Wiley & Sons;1996.
12. Ito H., Kajiyama, T., and Fukumura T. “Discovering conceptual structure of relations,” Proceedings of the IEEE SMC’96 1996, pp:591-596.
13. Johannesson, P. “A method for transforming relational schemas into conceptual schemas,” Proceeding of the 10th International Conference on Data Engineering, IEEE Press, Houston, 1994, pp:115-122.
14. Larson, Jeffrey S., Eric T. Bradlow and Peter S. Fader (2005), “An exploratory look at supermarket shopping paths,” International Journal of Research in Marketing, 22 (4), 2005, 395- 413.
15. Maleod John C,”Building competitive through data warehousing”,Wall Street & Technology,vol.13,Iss.11,Nov 1995,p52-54.
16. Mark S. Fox and Michael Gruninger “Enterprise Modeling,” American Association for Artificial Intelligence 1998, pp:109-121.
17. Ralph Kimball .,”The Data Warehouse Toolkit: The Complete Guide to Dimensional Modeling”, Second Edition;”, John Wiley & Sons,2003.
18. Ralph Kimball and Joe Caserta, “The Data Warehouse ETL Toolkit: Practical Techniques for Extracting, Cleanin” Wiley, 2004.
19. Scott Morton,M,S, “Management Decision Systems: Computer Based Support for Decision making” , Division od Research, Ilarvard University, Cambridge, Mass,1971.
20. Shamkant B. Navathe, “Evolution of Data Modeling for Database,” Communication of the ACM, vol.35, No.9, Sep.1992, pp:112-123.
21. Surajit Chaudhuri and Umesh Dayal, “An Overview of Data Warehousing and OLAP Technology, ACM SIGMOD Record 26(1),March 1997.
22. Tom Hammergren, “Data Warehousing Biilding the Corporate Knowledge Base”, International Thomson Computer Press,1996.
23. W.H.Inmon, “Building the Data Warehouse” 3rd Edition, Wiley, 2002.
24. W.H.Inmon, “What is a Data Warehouse? http://cait.wustl.edu/cait/papers/prism/vol_nol,1994.
25. W.H. Inmon,R.D.Hackathom “Using the Data Warehouse”, John Wiley & Sons,1994.
26. Wallace,Peggy,”Building a data warehouse”, InfoWorld[IFW], vol.16, iss.8,Feb 21,1994,p56-5.
27. Y.Zhuge,H.Garcia-Molina, J. Hammer,and J. Widom.”View Maintenance in a Warehousing Environment,Proc. ACM SIGMOD, 1995. |
| Description: | 碩士
國立政治大學
經營管理碩士學程(EMBA)
103932182 |
| Source URI: | http://thesis.lib.nccu.edu.tw/record/#G0103932182 |
| Data Type: | thesis |
| Appears in Collections: | [經營管理碩士學程EMBA] 學位論文
|
Files in This Item:
There are no files associated with this item.
|
All items in 政大典藏 are protected by copyright, with all rights reserved.
|
