7156 33

# [文献] [求助]求书 Data Analysis Using SQL and Excel [推广有奖]

• 0关注
• 0粉丝

90%

-

0

1 个

0

0 点

0 点

0 点

75 点

3

0

0 小时

2009-4-13

2016-8-21

realone20087 发表于 2009-4-16 09:46:00 |显示全部楼层 |坛友微信交流群

+2 论坛币
k人 参与回答

### 感谢您参与论坛问题回答

+2 论坛币
&lt;p&gt;谁有这本书 ？Data Analysis Using SQL and Excel by Gordon S. Linoff&lt;/p&gt;&lt;p&gt;我在goolebook上看过此书。有许多SQL for SAS&amp;nbsp;例子。非常好的一本书。&amp;nbsp;&lt;/p&gt;

### 本帖被以下文库推荐

yongyitian 发表于 2009-4-16 10:53:00 |显示全部楼层 |坛友微信交流群


title: Data Analysis Using SQL and Excel
author: Gordon S. Linoff,       Publisher: Wiley, 2007
ISBN: 0470099518,               645 pages
format: PDF, size: 10.6 MB

Contents
Chapter 1 A Data Miner Looks at SQL 1
Picturing the Structure of the Data 2
What Is a Data Model? 3
What Is a Table? 3
Allowing NULL Values 5
Column Types 6
What Is an Entity-Relationship Diagram? 7
The Zip Code Tables 8
Subscription Dataset 10
Purchases Dataset 11
Picturing Data Analysis Using Dataflows 12
What Is a Dataflow? 13
Dataflow Nodes (Operators) 15
OUTPUT: Outputting a Table (or Chart) 15
SELECT: Selecting Various Columns in the Table 15
FILTER: Filtering Rows Based on a Condition 15
APPEND: Appending New Calculated Columns 15
UNION: Combining Multiple Datasets into One 16
AGGREGATE: Aggregating Values 16
LOOKUP: Looking Up Values in One Table in Another 16
CROSSJOIN: General Join of Two Tables 16
JOIN: Join Two Tables Together Using a Key Column 16
SORT: Ordering the Results of a Dataset 17
Dataflows, SQL, and Relational Algebra 17

Chapter 2 What’s In a Table? Getting Started with Data Exploration 43
Chapter 3 How Different Is Different? 91
Chapter 4 Where Is It All Happening? Location, Location, Location 133
Chapter 5 It’s a Matter of Time 185
Chapter 6 How Long Will Customers Last? Survival Analysis to Understand Customers and Their Value 239
Chapter 7 Factors Affecting Survival: The What and Why of Customer Tenure 297
Chapter 8 Customer Purchases and Other Repeated Events 347
Chapter 9 What’s in a Shopping Cart? Market Basket Analysis and Association Rules 401
Chapter 10 Data Mining Models in SQL 457
Chapter 11 The Best-Fit Line: Linear Regression Models 511
Chapter 12 Building Customer Signatures for Further Analysis 563
Appendix Equivalent Constructs Among Databases 611

[此贴子已经被作者于2009-4-16 11:54:30编辑过]

realone20087 发表于 2009-4-17 09:02:00 |显示全部楼层 |坛友微信交流群
 Thanks. It is.
jcs200 发表于 2009-4-18 01:01:00 |显示全部楼层 |坛友微信交流群


chenxiaoliang22   发表于 2009-5-25 22:41:00 |显示全部楼层 |坛友微信交流群
 谢谢

dingxuewen 发表于 2009-11-9 11:04:15 |显示全部楼层 |坛友微信交流群
 好书啊，谢谢！
marlinpfd 发表于 2009-11-14 18:59:28 |显示全部楼层 |坛友微信交流群
 Data Analysis Using SQL and Excel , Thanks very much for free sharing....
renda_shitou 发表于 2010-2-20 14:53:42 |显示全部楼层 |坛友微信交流群
 好像没有免费啊，要收2个币的
oushivv 发表于 2010-4-30 10:02:50 |显示全部楼层 |坛友微信交流群
 thanks for sharing ~~~~
zhentao 发表于 2010-4-30 11:22:51 |显示全部楼层 |坛友微信交流群
 二楼好人，
 您需要登录后才可以回帖 登录 | 我要注册 回帖后跳转到最后一页