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 you can expect the results to look like. Throughout the book, critical features of Excel are highlighted, interesting uses of Excel graphics are explained, and dataflows and graphical representations of 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 of data
Ways to use SQL to generate SQL queries
Descriptive statistics, such as averages, p-values, and the chi-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 a specific point in time
Several variants of linear regression
Request Downloads | Ebook Request