Data Analysis Using SQL and Excel

Gordon S. Linoff

  • 出版商: Wiley
  • 出版日期: 2007-10-01
  • 售價: $1,710
  • 貴賓價: 9.5$1,625
  • 語言: 英文
  • 頁數: 645
  • 裝訂: Paperback
  • ISBN: 0470099518
  • ISBN-13: 9780470099513
  • 相關分類: ExcelSQLData Science
  • 已過版

買這商品的人也買了...

商品描述

Description

* One of the leading experts on business data mining shows managers how to leverage SQL and Excel to perform sophisticated types of business analysis without the expense of data mining tools and consultants
* Explains how to use the relatively simple tools of SQL and Excel to extract useful business information from relational databases
* Each chapter discusses why and when to perform a particular type of business analysis to obtain a useful business result, how to design and perform the analysis using SQL and Excel, and what the results look like in SQL and Excel
* Presents hints, warnings, and technical asides about Excel, SQL, and data analysis/mining 

Table of Contents

Introduction.

1. A Data Miner Looks at SQL.

2. What's in a Table? Getting Started with Data Exploration.

3. How Different is Different?

4. Where is it all Happening? Location, Location, Location.

5. It is a Matter of Time.

6. How Long Will Customers Last? Survival Analysis to Understand Customers and Their Value.

7. Factors Affecting Survival: The What and Why of Customer Tenure.

8. Customer Purchases and Other Repeated Events.

9. What's in a Shopping Cart? Market Basket Analysis and Association Rules.

10. Data Mining Models in SQL.

11. The Best Fit Line: Linear Regression Models.

12. Building Customer Signatures for Further Analysis.

Appendix A. Equivalent Constructs Among Databases.

Index.