A practical guide to data mining using SQL and Excel
Data Analysis Using SQL and Excel, 2nd Edition shows youhow to leverage the two most popular tools for data query andanalysis—SQL and Excel—to perform sophisticated dataanalysis without the need for complex and expensive data miningtools. Written by a leading expert on business data mining, thisbook shows you how to extract useful business information fromrelational databases. You'll learn the fundamental techniquesbefore moving into the "where" and "why" of each analysis, and thenlearn how to design and perform these analyses using SQL and Excel.Examples include SQL and Excel code, and the appendix shows hownon-standard constructs are implemented in other major databases,including Oracle and IBM DB2/UDB. The companion website includesdatasets and Excel spreadsheets, and the book provides hints,warnings, and technical asides to help you every step of theway.
Data Analysis Using SQL and Excel, 2nd Edition shows youhow to perform a wide range of sophisticated analyses using thesesimple tools, sparing you the significant expense of proprietarydata mining tools like SAS.
Understand core analytic techniques that work with SQL andExcel
Ensure your analytic approach gets you the results youneed
Design and perform your analysis using SQL and Excel
Data Analysis Using SQL and Excel, 2nd Edition shows youhow to best use the tools you already know to achieve expertresults.