Data Analysis Using SQL and Excel (Paperback)

By 

Gordon S Linoff

  (Author)
Write a Review
Cash On Delivery Available 3 %
List Price: Rs. 2,579
Our Price: Rs. 2,501 ($ 47.52) (£ 28.42)
You Save: Rs. 78 (3%)

Imported Edition. FREE Shipping in India!
Ships in 5-7 business days.
Call +91-79-40260260, +91-79-67778777
New & Used  from  sellers starting at 

Also Available in:

Edition Price Availability
Paperback 2007
Rs. 549 466
In Stock. 4-5 business days
Ebook, Pdf 2007
Rs. 2,397 2,277
In Stock. 0-0 business days
  • Data Analysis Using SQL and Excel

Data Analysis Using SQL and Excel Book Description

Leverage the power of SQL and Excel to perform business analysis

Three key efforts are essential to effectively transform data into actionable information: retrieving data with SQL, presenting data with Excel, and understanding statistics as the foundation of data analysis. Data mining expert Gordon Linoff focuses on these topics and shows you how SQL and Excel can be used to extract business information from relational databases. He begins by taking a look at how data is central to the task of understanding customers, products, and markets, and he then goes on to show you how to use that data to define business dimensions, store transactions about customers, and summarize important data to produce results. Along the way, he shares stories based on his personal experience in the field, intended to enrich your understanding of why some things work--and others don't.

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 geographicinformation 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

The companion Web site provides the data sets, Excel spreadsheets, and examples featured in the book.
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.

About the Author :

Gordon S Linoff has contributed to Data Analysis Using SQL and Excel as an author. GORDON S. LINOFF and MICHAEL J. A. BERRY are the founders of Data Miners Inc. (www.data-miners.com), a consulting firm specializing in data mining. They provide analytic CRM consulting for customer-centric companies on and off the Web. They are the authors of Data Mining Techniques and Mastering Data Mining (both from Wiley).

Book Details


Title: Data Analysis Using SQL and Excel
Publisher: Wiley Publishing
Author: Gordon S Linoff
Edition: Paperback
Language: English
ISBN:

0470099518

EAN:

9780470099513

No. of Pages: 645
Publish Date: 2007-9-1
Binding: Paperback
Deliverable Countries: This product ships to United Arab Emirates, Australia, Belgium, Bahrain, Switzerland, China, Germany, Spain, Finland, France, Hong Kong, Indonesia, India, Japan, Kenya, Kuwait, Sri Lanka, Malaysia, Netherlands, New Zealand, Russia, Saudi Arabia, Singapore, Thailand, South Africa.

Customer Reviews : Data Analysis Using SQL and Excel

Be the first one to review this product!
Have you used this product?
    

Discussion : Data Analysis Using SQL and Excel

No Discussion has been started.  See Latest Discussions

Start a new Discussion

Topic Title :
Description :
Inferno: The New Robert Langdon Thriller
The book Data Analysis Using SQL and Excel by Gordon S Linoff (author) is published or distributed by Wiley Publishing [0470099518, 9780470099513]. This particular edition was published on or around 2007-9-1 date. Data Analysis Using SQL and Excel has Paperback binding and this format has 645 number of pages of content for use. This book by Gordon S Linoff is written in English language.
* The book summary and image may be of a different edition or binding of the same title.
* Book reviews are added by registered customers. They need not necessarily buy book.
* These books are NOT available for reading online or for free download in PDF or ebook format.
* Price can change due to reprinting, price change by publisher or sourcing cost change for imported books.

www.infibeam.com/Books is the biggest online bookstore in India for sale of books at best price - fiction, literature, audiobooks, study guides, novels, story books, rare books, textbooks and books by popular authors. These are available in various editions and bindings e.g. paperback and at best discount.
Facebook Twitter Infibeam Blog Google Plus Pinterest
Newsletter Subscription

All Stores

Books

Your Account


Contact Us

Help


Others

Payment Options


Payment Options

Safe & Secure Shopping

Safe and Secure Shopping
Infibeam sites: BuildaBazaar.com | Picsquare.com     Copyright © 2007-2013 Infibeam.com and Affiliates