Data Analysis Using SQL and Excel

Front Cover
John Wiley & Sons, Sep 16, 2010 - Computers - 744 pages
2 Reviews
Useful business analysis requires you to effectively transform data into actionable information. This book helps you use SQL and Excel to extract business information from relational databases and use that data to define business dimensions, store transactions about customers, produce results, and more. Each chapter explains when and why to perform a particular type of business analysis in order to obtain useful results, how to design and perform the analysis using SQL and Excel, and what the results should look like.
 

What people are saying - Write a review

User Review - Flag as inappropriate

done

User Review - Flag as inappropriate

IT SUCKS

Contents

A Data Miner Looks at SQL
2
Chapter
3
Whats In a Table? Getting Started with Data Exploration
43
How Different Is Different?
91
How Different Are the Averages?
99
Where Is It All Happening? Location Location Location
133
Its a Matter of Time
185
How Long Will Customers Last? Survival Analysis
239
Whats in a Shopping Cart? Market Basket Analysis
401
Data Mining Models in SQL
457
Linear Regression Models
511
Measuring Goodness of Fit Using R2
532
Weighted Linear Regression
544
More Than One Input Variable
552
Lessons Learned
560
Building Customer Signatures for Further Analysis
563

The What
297
Time Windowing
316
Lessons Learned
344
Appendix Equivalent Constructs Among Databases
611
Index
637
Copyright

Other editions - View all

Common terms and phrases

About the author (2010)

GORDON S. LINOFF is a cofounder of Data Miners, Inc., a consultancy specializing in data mining. He is the coauthor of the bestselling Data Mining Techniques, Second Edition, and Mastering Data Mining (both from Wiley). He has more than a decade of experience applying data mining techniques to business problems in marketing and customer relationship management.

Bibliographic information