คลังข้อมูลและระบบสนับสนุนการตัดสินใจสำหรับธุรกิจจำหน่ายของเล่น / พันธนนท์ วรรุ่งเรืองสกุล =Data Warehouse and Decision Support System for Toy Selling Business /Phantanon Warrarungruengskun
Having high market value, toy business is one of the high competitive businesses at present. A number of toy selling businesses have been founded and closed in recent years due to insufficient funding and a lack of decision support information. Thus, the business should adopt modern information technology in order to gain competitive advantages and be able to compete with competitors. This implies that managers should have an effective tool to assist them in both strategic and administration planning as well as future situation evaluation.
The objectives of the “Data Warehouse and Decision Support System for Toy Selling Business” project are to collect data in the organization, create a data warehouse, and develop a decision support system by providing various analytic reports which the management can use for planning and managing the business in time. This system consists of 5 subsystems: 1) Sales and Gross Profit Analysis System, 2) Inventory Analysis System, 3) Customer Analysis System, 4) Supplier Analysis System, and 5) Salesperson Analysis System. The system was developed by using Tableau Desktop 10.0 as a tool on Microsoft SQL Server 2014 database management system. The developed system will assist the managers to analyze data in various dimensions in order to support their decision for managing the toy selling business conveniently, timely and efficiently.