<p>是不是这个? <br/>title: Data Analysis Using SQL and Excel<br/>author: Gordon S. Linoff, Publisher: Wiley, 2007 <br/>ISBN: 0470099518, 645 pages <br/>format: PDF, size: 10.6 MB</p><p>Contents<br/>Chapter 1 A Data Miner Looks at SQL 1<br/>Picturing the Structure of the Data 2<br/>What Is a Data Model? 3<br/>What Is a Table? 3<br/>Allowing NULL Values 5<br/>Column Types 6<br/>What Is an Entity-Relationship Diagram? 7<br/>The Zip Code Tables 8<br/>Subscription Dataset 10<br/>Purchases Dataset 11<br/>Picturing Data Analysis Using Dataflows 12<br/>What Is a Dataflow? 13<br/>Dataflow Nodes (Operators) 15<br/>READ: Reading a Database Table 15<br/>OUTPUT: Outputting a Table (or Chart) 15<br/>SELECT: Selecting Various Columns in the Table 15<br/>FILTER: Filtering Rows Based on a Condition 15<br/>APPEND: Appending New Calculated Columns 15<br/>UNION: Combining Multiple Datasets into One 16<br/>AGGREGATE: Aggregating Values 16<br/>LOOKUP: Looking Up Values in One Table in Another 16<br/>CROSSJOIN: General Join of Two Tables 16<br/>JOIN: Join Two Tables Together Using a Key Column 16<br/>SORT: Ordering the Results of a Dataset 17<br/>Dataflows, SQL, and Relational Algebra 17 </p><p>Chapter 2 What’s In a Table? Getting Started with Data Exploration 43<br/>Chapter 3 How Different Is Different? 91<br/>Chapter 4 Where Is It All Happening? Location, Location, Location 133<br/>Chapter 5 It’s a Matter of Time 185<br/>Chapter 6 How Long Will Customers Last? Survival Analysis to Understand Customers and Their Value 239<br/>Chapter 7 Factors Affecting Survival: The What and Why of Customer Tenure 297<br/>Chapter 8 Customer Purchases and Other Repeated Events 347<br/>Chapter 9 What’s in a Shopping Cart? Market Basket Analysis and Association Rules 401<br/>Chapter 10 Data Mining Models in SQL 457<br/>Chapter 11 The Best-Fit Line: Linear Regression Models 511<br/>Chapter 12 Building Customer Signatures for Further Analysis 563<br/>Appendix Equivalent Constructs Among Databases 611</p><p><br/></p><p></p>
[此贴子已经被作者于2009-4-16 11:54:30编辑过]