tailieunhanh - Hướng dẫn học Microsoft SQL Server 2008 part 164

PivotTables và PivotCharts cung cấp một môi trường phân tích linh hoạt cho cả hai quan hệ và Dịch vụ Phân tích dữ liệu mà các truy vấn nội dung cơ sở dữ liệu hiện tại cho cập nhật hàng. SQL Server Data Mining Add-in cho Office 2007 làm cho một loạt các khả năng tinh vi khai thác dữ liệu có sẵn trong môi trường Excel quen thuộc. | PartX Business Intelligence 1592 for easy refresh as data changes. PivotTables and PivotCharts provide a flexible analysis environment for both relational and Analysis Services data that queries the current database contents for every update. SQL Server Data Mining Add-ins for Office 2007 make a host of sophisticated data mining capabilities available within the familiar Excel environment. Use the Data Preparation features to explore and clean data and the Table Analysis Tools to perform a number of common analyses with minimal effort. Excel even offers an alternative to Visual Studio as a client for data mining in Analysis Services. Most every organization can benefit from better data availability and analysis and Excel is a great place to start. Data Mining with Analysis Services . Vt V J . Ï V S r-wî iv. . S. Z . s. v SgM . . Fa vVî 7 xjc k iv c _ o w f . 1 V- A _ f r S i. V . SÎVAÎÎSK. 1 Many business questions can be answered directly by querying a database for example What is the most popular page on our website or Who are our top customers Other often more important questions require deeper exploration for example the most popular paths through the website or common characteristics of top customers. Data mining provides the tools to answer such non-obvious questions. The term data mining has suffered from a great deal of misuse. One favorite anecdote is the marketing person who intended to mine data in a spreadsheet by staring at it until inspiration struck. In this book data mining is not something performed by intuition direct query or simple statistics. Instead it is the algorithmic discovery of non-obvious information from large quantities of data. Analysis Services implements algorithms to extract information addressing several categories of questions Segmentation Groups items with similar characteristics. For example develop profiles of top customers or spot suspect values on a data entry page. IN THIS CHAPTER .