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.