Using OLAP technology and satisfaction survey to analyze the management strategies of the cable TV system - take Pingtung area as an example

• Main Authors: Long-Tsay Tsai, 蔡隆財
• Other Authors: Cheng-Fa Tsai
• Format: Others
• Language: zh-TW
• Published: 2006
• Online Access: http://ndltd.ncl.edu.tw/handle/99999440603370370568

碩士 === 國立屏東科技大學 === 高階經營管理碩士在職專班 === 94 === The cable TV is deemed to be the role of the public utilities. There is status of the same influence of people's livelihood as such industries as the coal gas, water, electricity, etc. It must receive supervision of responsible institution to manage. Moreover, the cable TV also possesses local and community's media nature, the expense–standards should be suited to local conditions. On-line analytical processing (OLAP) is a favorable tool possessing user-friendly interface functions. It allows users picking and fetching multidimensional information fast and finding out overview to analyze the data as information. In this thesis, according to the real state of management of the cable TV, we tried with the on-line analytical processing technology and utilized SQL Server 2000 Analysis Services to support on-line analytical processing function in data transformation and processing. The satisfaction rating of the cable TV is mainly determined by the reciprocation of expectation and performance of the system proprietor’s signal service, quality of customer service and expenses, etc. In this thesis, we tried to make use of five statistical methods: Descriptives, Crosstabs, Chi-square test, t test, and Logistic Regression to explain people’s satisfaction rating for two cable TV systems to complete the analysis and research of satisfaction survey. This thesis is based on the management and administration data of the cable television system operator to analyze and process the real management state by using the on-line analytical processing technology. Subsequently, regarding the result of the satisfaction survey by phone questionnaire, we combined the statistical methods to analyze the audiences’ satisfaction rating and the household behavior deeply and extensively to sketch the relationship between the system operator's operation and administration and the audiences’ satisfaction rating. The quality of the cable TV system operator influences the audiences’ rights. We hope the integrated conclusions of the interaction between the operator's management strategies in Pingtung area and audiences’ rights analyzed by using OLAP technology and satisfaction survey in this thesis can provide the operators with information for the management strategies or suggestions for the government to safeguard the audiences’ rights. Hence to create an advantageous situation for the operator's management strategies, government's administrative performance, and audiences’ rights.