| Summary: | 碩士 === 國立高雄第一科技大學 === 電子工程系碩士在職專班 === 105 === The advanced information technology, well developed internet, increasing computing capability of computer and continuing improvement of data collection and storage not only accelerate the accessibility of data but also change the way of data application. On the other hand, the technique of data mining also help to dig out the potential data model and transferring into valuable information for decision makers to initiate appropriate strategy, which is one of the most important competitive advantage. Therefore, data mining and business intelligence (BI) are gradually valued by the industry.
The business intelligence system integrates, connects, and collects the data from different enterprise systems, such as System, Application and products in data Processing (SAP) and Customer Relationship Management (CRM). BI can be used to analyze business data and the commercial operation value. By using the analysis techniques of data warehousing, Online Analytical Processing (OLAP), and data mining, decision makers can get the maximum value of the information and initiate strategy more efficiently.
This research focus on applying current business intelligence tools to design an in-depth analysis, and end up designing a report as a basis for corporates to query and make decisions. Work process software, which base on Microsoft SQL Server 2008R2 is incorporated with SSIS (SQL Server Integration Services) to transform, combine, sort and generate clean Data Warehousing and SSAS (SQL Server Analysis Service) for the purpose of Multidimensional Cube analysis. Through the language of MDX (Multidimensional Expressions), the elements, calculation and query of data analysis are defined. At the same time, the advantage of DMX (Data Mining Extension) is also coordinated to predict future and seek for business opportunity. Regarding displaying the front-end management decision making, the OLAP is used, so users can generate an exclusive business intelligence reports by execute the Microsoft Excel Pivot Table. So that decision makers can look at the big picture, be considerate and meticulous, and work out splendid plans to win victories in battles a thousand miles away
Key words: Business Intelligence (BI), Data Warehousing, Online Analytical Processing (OLAP), Multidimensional Expressions (MDX), Data Mining, Data Mining Extension (DMX)
|
|---|
