Data Analysis Using SQL and Excel

ISBN-10: 0470099518

ISBN-13: 9780470099513

Edition: 2008

Authors: Gordon S. Linoff

List price: $45.00 Buy it from $21.57
This item qualifies for FREE shipping

*A minimum purchase of $35 is required. Shipping is provided via FedEx SmartPost® and FedEx Express Saver®. Average delivery time is 1 – 5 business days, but is not guaranteed in that timeframe. Also allow 1 - 2 days for processing. Free shipping is eligible only in the continental United States and excludes Hawaii, Alaska and Puerto Rico. FedEx service marks used by permission."Marketplace" orders are not eligible for free or discounted shipping.

30 day, 100% satisfaction guarantee

If an item you ordered from TextbookRush does not meet your expectations due to an error on our part, simply fill out a return request and then return it by mail within 30 days of ordering it for a full refund of item cost.

Learn more about our returns policy

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 dont. 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 The companion Web site provides the data sets, Excel spreadsheets, and examples featured in the book.
New Starting from $48.20
what's this?
Rush Rewards U
Members Receive:
coins
coins
You have reached 400 XP and carrot coins. That is the daily max!
Study Briefs

Limited time offer: Get the first one free! (?)

All the information you need in one place! Each Study Brief is a summary of one specific subject; facts, figures, and explanations to help you learn faster.

Add to cart
Study Briefs
Periodic Table Online content $4.95 $1.99
Add to cart
Study Briefs
Medical Terminology Online content $4.95 $1.99
Add to cart
Study Briefs
SQL Online content $4.95 $1.99
Customers also bought
Loading
Loading
Loading
Loading
Loading
Loading
Loading
Loading
Loading
Loading

Book details

List price: $45.00
Copyright year: 2008
Publisher: John Wiley & Sons, Incorporated
Publication date: 10/1/2007
Binding: Paperback
Pages: 744
Size: 7.75" wide x 9.50" long x 1.75" tall
Weight: 2.552
Language: English

Foreword
Acknowledgments
Introduction
A Data Miner Looks at SQL
What's In a Table? Getting Started with Data Exploration
How Different Is Different?
Where Is It All Happening? Location, Location, Location
It's a Matter of Time
How Long Will Customers Last? Survival Analysis to Understand Customers and Their Value
Factors Affecting Survival: The What and Why of Customer Tenure
Customer Purchases and Other Repeated Events
What's in a Shopping Cart? Market Basket Analysis and Association Rules
Data Mining Models in SQL
The Best-Fit Line: Linear Regression Models
Building Customer Signatures for Further Analysis
Appendix Equivalent Constructs Among Databases
Index
Free shipping on orders over $35*

*A minimum purchase of $35 is required. Shipping is provided via FedEx SmartPost® and FedEx Express Saver®. Average delivery time is 1 – 5 business days, but is not guaranteed in that timeframe. Also allow 1 - 2 days for processing. Free shipping is eligible only in the continental United States and excludes Hawaii, Alaska and Puerto Rico. FedEx service marks used by permission."Marketplace" orders are not eligible for free or discounted shipping.

Learn more about the TextbookRush Marketplace.

×