SQL Queries for Mere Mortals(R): A Hands-On Guide to Data Manipulation in SQL (2nd Edition) by John L. Viescas |
by Galit Shmueli
|
by Timothy Zapawa
|
Pivot Table Data Crunching for Microsoft Office Excel 2007 (Business Solutions) by Bill Jelen |
How to Measure Anything: Finding the Value of "Intangibles" in Business by Douglas W. Hubbard |
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:
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.
See all Editorial Reviews
Product Details
Would you like to update product info or give feedback on images?
|
![]() |
85% buy the item featured on this page: Data Analysis Using SQL and Excel $39.74 |
![]() |
5% buy SQL Queries for Mere Mortals(R): A Hands-On Guide to Data Manipulation in SQL (2nd Edition) $34.64 |
![]() |
4% buy Sams Teach Yourself SQL in 10 Minutes (3rd Edition) $13.59 |
![]() |
3% buy SQL Cookbook (Cookbooks (O'Reilly)) $26.37 |
Tags Customers Associate with This Product(What's this?)Click on a tag to find related items, discussions, and people.
|
|
Share your thoughts with other customers:
|
||||||||||||||||||||||
Most Helpful Customer Reviews
Share your thoughts with other customers: Create your own review
|
|
|
This product's forum
(1 discussion)
Active discussions in related forums
|
|   |   |   |   | |||||||
|
|
You have no recently viewed items or searches.
After viewing product detail pages or search results, look here to find an easy way to navigate back to pages you are interested in. Look to the right column to find helpful suggestions for your shopping session. |
|
| ||
| ||
| ||
| ||