×

Uh-oh, it looks like your Internet Explorer is out of date.

For a better shopping experience, please upgrade now.

Data Analysis Using SQL and Excel
     

Data Analysis Using SQL and Excel

5.0 2
by Gordon S. Linoff
 

See All Formats & Editions

Useful business analysis requires you to effectively transform data into actionable information. This book helps you use SQL and Excel to extract business information from relational databases and use that data to define business dimensions, store transactions about customers, produce results, and more. Each chapter explains when and why to perform a particular type

Overview

Useful business analysis requires you to effectively transform data into actionable information. This book helps you use SQL and Excel to extract business information from relational databases and use that data to define business dimensions, store transactions about customers, produce results, and more. 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 the results should look like.

Product Details

ISBN-13:
9780470952528
Publisher:
Wiley
Publication date:
09/16/2010
Sold by:
Barnes & Noble
Format:
NOOK Book
Pages:
744
Sales rank:
1,280,748
File size:
8 MB

Meet the Author

GORDON S. LINOFF is a cofounder of Data Miners, Inc., a consultancy specializing in data mining. He is the coauthor of the bestselling Data Mining Techniques, Second Edition, and Mastering Data Mining (both from Wiley). He has more than a decade of experience applying data mining techniques to business problems in marketing and customer relationship management.

Customer Reviews

Average Review:

Post to your social network

     

Most Helpful Customer Reviews

See all customer reviews

Data Analysis Using SQL and Excel 5 out of 5 based on 0 ratings. 2 reviews.
Anonymous More than 1 year ago
Guest More than 1 year ago
Utilizing data to drive results is critical to the success of any organization. Many know this to be true, but don¿t know how to go about it. 'Data Analysis Using SQL and Excel' by Gordon Linoff successfully shows the way using a holistic approach of ¿data ¿ analysis ¿ presentation¿. Its success is based on a number attributes including.... 1. Wide Audience: Different groups of people are addressed. Management and leadership will see what is possible with great examples 'e.g. Three Scenarios' on pg 333'. 'Doers' 'e.g. analysts' get a clear view of the big picture along with the ever so important how-to aspects 'which is often not included in other texts'. 2. Popular Tools: As the title states, this book utilizes Microsoft Excel and SQL. Not only are these tools often readily available, but many people are familiar with at least one of these, if not both. This familiarity enables the reader to focus more on learning useful approaches than the tools themselves. 3. Methods: A host of useful methods are covered from Survival Analysis to the more traditional like RFM. All, especially those related to statistics, are explained well ¿ simple but not so simple as to be inaccurate or incomplete. In my opinion, ¿Data Analysis Using SQL and Excel¿ is invaluable to those who want to get the most out of their organization¿s data.