คลังข้อมูลและระบบสนับสนุนการตัดสินใจสำหรับธุรกิจสินค้าตกแต่งบ้าน / ปิติพร จันทร์ไทยศรี =Data Warehouse and Decision Support System for Home Decor Product Business /Pitiporn Janthaisri
Recently home decor business in Thailand has high potential to grow due to consumer growth in real estate sector. Since year 2016, there have been many construction projects from both private and government sector. New lines of subway train and sky train creat new communities of living including detach houses, townhomes and condominiums. For the reason mentioned earlier, there are rapid growing demand in home decor products which affects marketing competition in home decor product business. For competitive competency, businesses must develop their strategies for the high market competitive environment. Therefore, bringing information technology to support business decisions, will help the management to operate decision quickly to keep their competitive abilities in business including building more advantages for business.Data warehouse and decision support system for home decor business is composed of 5 main systems as follows; sales and gross profit analysis system, inventory analysis system, sale promotion analysis system, marketing expense analysis system, and product delivery analysis system. The systems were developed on Microsoft SQL Server 2014 database management system and Tableau Desktop Professional Edition (Version 10.1) was used as developing tool. This developed system will support management in analyzing data in various dimensions quickly and provide more accurate data. It will help executives to make decisions correctly, to create the operation effectively, then the organization can improve overall performance and competency of the organization.