Data Analysis Using SQL and Excel [NOOK Book]

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 ...
See more details below
Data Analysis Using SQL and Excel

Available on NOOK devices and apps  
  • NOOK Devices
  • NOOK HD/HD+ Tablet
  • NOOK
  • NOOK Color
  • NOOK Tablet
  • Tablet/Phone
  • NOOK for Windows 8 Tablet
  • NOOK for iOS
  • NOOK for Android
  • NOOK Kids for iPad
  • PC/Mac
  • NOOK for Windows 8
  • NOOK for PC
  • NOOK for Mac
  • NOOK Study
  • NOOK for Web

Want a NOOK? Explore Now

NOOK Book (eBook)
$25.99
BN.com price
(Save 42%)$45.00 List Price
Note: This NOOK Book can be purchased in bulk. Please email us for more information.

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.
Read More Show Less

Product Details

  • ISBN-13: 9780470952528
  • Publisher: Wiley
  • Publication date: 9/16/2010
  • Sold by: Barnes & Noble
  • Format: eBook
  • Edition number: 1
  • Pages: 744
  • Sales rank: 451,850
  • File size: 9 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.
Read More Show Less

Table of Contents

Foreword.

Acknowledgments.

Introduction.

Chapter 1 A Data Miner Looks at SQL.

Chapter 2 What’s In a Table? Getting Started with Data Exploration.

Chapter 3 How Different Is Different?

Chapter 4 Where Is It All Happening? Location, Location, Location.

Chapter 5 It’s a Matter of Time.

Chapter 6 How Long Will Customers Last? Survival Analysis to Understand Customers and Their Value.

Chapter 7 Factors Affecting Survival: The What and Why of Customer Tenure.

Chapter 8 Customer Purchases and Other Repeated Events.

Chapter 9 What’s in a Shopping Cart? Market Basket Analysis and Association Rules.

Chapter 10 Data Mining Models in SQL.

Chapter 11 The Best-Fit Line: Linear Regression Models.

Chapter 12 Building Customer Signatures for Further Analysis.

Appendix Equivalent Constructs Among Databases.

Index.

Read More Show Less

Customer Reviews

Average Rating 5
( 2 )
Rating Distribution

5 Star

(2)

4 Star

(0)

3 Star

(0)

2 Star

(0)

1 Star

(0)

Your Rating:

Your Name: Create a Pen Name or

Barnes & Noble.com Review Rules

Our reader reviews allow you to share your comments on titles you liked, or didn't, with others. By submitting an online review, you are representing to Barnes & Noble.com that all information contained in your review is original and accurate in all respects, and that the submission of such content by you and the posting of such content by Barnes & Noble.com does not and will not violate the rights of any third party. Please follow the rules below to help ensure that your review can be posted.

Reviews by Our Customers Under the Age of 13

We highly value and respect everyone's opinion concerning the titles we offer. However, we cannot allow persons under the age of 13 to have accounts at BN.com or to post customer reviews. Please see our Terms of Use for more details.

What to exclude from your review:

Please do not write about reviews, commentary, or information posted on the product page. If you see any errors in the information on the product page, please send us an email.

Reviews should not contain any of the following:

  • - HTML tags, profanity, obscenities, vulgarities, or comments that defame anyone
  • - Time-sensitive information such as tour dates, signings, lectures, etc.
  • - Single-word reviews. Other people will read your review to discover why you liked or didn't like the title. Be descriptive.
  • - Comments focusing on the author or that may ruin the ending for others
  • - Phone numbers, addresses, URLs
  • - Pricing and availability information or alternative ordering information
  • - Advertisements or commercial solicitation

Reminder:

  • - By submitting a review, you grant to Barnes & Noble.com and its sublicensees the royalty-free, perpetual, irrevocable right and license to use the review in accordance with the Barnes & Noble.com Terms of Use.
  • - Barnes & Noble.com reserves the right not to post any review -- particularly those that do not follow the terms and conditions of these Rules. Barnes & Noble.com also reserves the right to remove any review at any time without notice.
  • - See Terms of Use for other conditions and disclaimers.
Search for Products You'd Like to Recommend

Recommend other products that relate to your review. Just search for them below and share!

Create a Pen Name

Your Pen Name is your unique identity on BN.com. It will appear on the reviews you write and other website activities. Your Pen Name cannot be edited, changed or deleted once submitted.

 
Your Pen Name can be any combination of alphanumeric characters (plus - and _), and must be at least two characters long.

Continue Anonymously
Sort by: Showing all of 2 Customer Reviews
  • Anonymous

    Posted January 31, 2008

    Invaluable Guide to Utilizing Data

    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.

    0 out of 1 people found this review helpful.

    Was this review helpful? Yes  No   Report this review
  • Anonymous

    Posted July 12, 2010

    No text was provided for this review.

Sort by: Showing all of 2 Customer Reviews

If you find inappropriate content, please report it to Barnes & Noble
Why is this product inappropriate?
Comments (optional)