คลังข้อมูลและระบบสนับสนุนการตัดสินใจสำหรับ ธุรกิจจัดจำหน่ายอาหารสุนัขและแมว / ธนัชฌนันท์ พิพัฒน์จามีกร=Data Warehouse and Decision Support System for Dog and Cat Food Distribution Business /Thanatchanan Phiphatchamikon
Due to the current state of families in Thailand that have been changed from big families to small families. In additional, the lifestyle has experienced with stress and tension. The attitude of the new generation has changed to be more single. These factors result, in most people turn their attentions to pets since pets can help ease loneliness and reduce stress. They treat their pets as a family member. They select the good quality food and good nutrition for their pets. As the case study company distributes a heath nutrition food with premium quality for dogs and cats, its products were chosen for their pets. During the last 2 or 3 years, the company has growth in a very good rate and has more customers. However, the company still experienced problem in management of data used to analyze the current business situation and support decisions in the future.
The Project “Data Warehouse and Decision Support System for Dogs and Cats Food Distributions Business” was developed in response to information needed by management to support their decision making. The project is composed of 5 systems: (1) Sales and Gross Profit Analysis System, (2) Marketing Analysis System, (3) Account Receivable Analysis System, (4) Goods Delivery Analysis System, and (5) Inventory Analysis System. All systems were developed by using Microsoft SQL Server 2012 database management system and Tableau V.9.2 BI tool. This system allows management in making strategy and decisions more correctly, timely, and efficiency to become one of the leaders in the dogs and cats food distributions business.