Data Analysis Using SQL and Excel

Name: Data Analysis Using SQL and Excel
Price: 4.25 USD
Availability: InStock
ISBN: 9780470099513

ISBN-10: 0470099518

ISBN-13: 9780470099513

Edition: 2008

Authors: Gordon S. Linoff

List price: $45.00

30 day, 100% satisfaction guarantee!

Marketplace

3 new & used from $4.25

what's this?

Rush Rewards U
Members Receive:

You have reached 400 XP and carrot coins. That is the daily max!

Description:

Leverage the power of SQL and Excel to perform business analysis Three key efforts are essential to effectively transform data into actionable information: retrieving data with SQL, presenting data with Excel, and understanding statistics as the foundation of data analysis. Data mining expert Gordon Linoff focuses on these topics and shows you how SQL and Excel can be used to extract business information from relational databases. He begins by taking a look at how data is central to the task of understanding customers, products, and markets, and he then goes on to show you how to use that data to define business dimensions, store transactions about customers, and summarize important data…

Book details

List price: $45.00
Copyright year: 2008
Publisher: John Wiley & Sons, Incorporated
Publication date: 10/1/2007
Binding: Paperback
Pages: 744
Size: 7.75" wide x 9.50" long x 1.75" tall
Weight: 2.2
Language: English



Foreword


Acknowledgments


Introduction



A Data Miner Looks at SQL



What's In a Table? Getting Started with Data Exploration



How Different Is Different?



Where Is It All Happening? Location, Location, Location



It's a Matter of Time



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



Factors Affecting Survival: The What and Why of Customer Tenure



Customer Purchases and Other Repeated Events



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



Data Mining Models in SQL



The Best-Fit Line: Linear Regression Models



Building Customer Signatures for Further Analysis


Appendix Equivalent Constructs Among Databases


Index