Data Analysis Using SQL and Excel
By Gordon S. Linoff
Publisher: Wiley
Final Release Date: October 2007
Pages: 744

Leverage the power of SQL and Excel to perform businessanalysis

Three key efforts are essential to effectively transform datainto actionable information: retrieving data with SQL, presentingdata with Excel, and understanding statistics as the foundation ofdata analysis. Data mining expert Gordon Linoff focuses on thesetopics and shows you how SQL and Excel can be used to extractbusiness information from relational databases. He begins by takinga look at how data is central to the task of understandingcustomers, products, and markets, and he then goes on to show youhow to use that data to define business dimensions, storetransactions about customers, and summarize important data toproduce results. Along the way, he shares stories based on hispersonal experience in the field, intended to enrich yourunderstanding of why some things work—and others don't.

Each chapter explains when and why to perform a particular typeof business analysis in order to obtain useful results, how todesign and perform the analysis using SQL and Excel, and what youcan expect the results to look like. Throughout the book, criticalfeatures of Excel are highlighted, interesting uses of Excelgraphics are explained, and dataflows and graphical representationsof data processing are used to illustrate how SQL works.

Data Analysis Using SQL and Excel shares hints, warnings,and technical asides about Excel, SQL, and data analysis/mining.The book also discusses:

  • How entity-relationship diagrams describe the structure ofdata
  • Ways to use SQL to generate SQL queries

  • Descriptive statistics, such as averages, p-values, and thechi-square test

  • How to incorporate geographic information into data analysis

  • Basic ideas of hazard probabilities and survival

  • How data structures summarize what a customer looks like at aspecific point in time

  • Several variants of linear regression

The companion Web site provides the data sets, Excelspreadsheets, and examples featured in the book.

Product Details
Recommended for You
Customer Reviews
 
Buy 2 Get 1 Free Free Shipping Guarantee
Buying Options
Immediate Access - Go Digital what's this?
Ebook: $45.00
Formats:  ePub, Mobi, PDF