Data Analysis Using SQL and Excel

Leverage a energy of SQL as well as Excel to perform commercial operation research

Three pass efforts have been necessary to effectively renovate interpretation in to actionable information: retrieving interpretation with SQL, presenting interpretation with Excel, as well as bargain census interpretation as a substructure of interpretation analysis. Data mining consultant Gordon Linoff focuses upon these topics as well as shows we how SQL as well as Excel can be used to remove commercial operation report from relational databases. He starts by receiving a demeanour during how interpretation is executive to a charge of bargain customers, products, as well as markets, as well as he afterwards goes upon to uncover we how to make make use of of which interpretation to conclude commercial operation dimensions, store exchange about customers, as well as promulgate vicious interpretation to furnish results. Along a way, he shares stories formed upon his personal knowledge in a field, dictated to heighten your bargain of because a little things work—and others don’t.

Each section explains when as well as because to perform a sold sort of commercial operation research in sequence to acquire utilitarian results, how to pattern as well as perform a research regulating SQL as well as Excel, as well as what we can design a formula to demeanour like. Throughout a book, vicious facilities of Excel have been highlighted, engaging uses of Excel graphics have been explained, as well as dataflows as well as graphical representations of interpretation estimate have been used to spell out how SQL works.

Data Analysis Using SQL as well as Excel shares hints, warnings, as well as technical asides about Excel, SQL, as well as interpretation analysis/mining. The book additionally discusses:

How entity-relationship diagrams report a make up of interpretation

Ways to make make use of of SQL to beget SQL queries

Descriptive statistics, such as averages, p-values, as well as a chi-square exam

How to soak up geographic report in to interpretation research

Basic ideas of jeopardy probabilities as well as presence

How interpretation structures promulgate what a patron looks similar to during a specific indicate in time

Several variants of linear retrogression

The messenger Web site provides a interpretation sets, Excel spreadsheets, as well as examples featured in a book.
Publisher: Wiley; Pap/Onl book (October 1, 2007)
Language: English
ISBN-10: 0470099518
ISBN-13: 978-0470099513

Rapidshare download

http://rapidshare.com/files/228316409/Wiley.Data.Analysis.Using.SQL.and.Excel.rar