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.

Data Analysis Using SQL and Excel

Computers & Technology

Linoff, Gordon S.

Programming Languages

wiley

The leading introductory book on data mining, fully updated and revised! When Berry and Linoff wrote the first edition of Data Mining Techniques in the late 1990s, data mining was just starting to move out of the lab and into the office and has since grown to become an indispensable tool of modern business. This new edition--more than 50% new and revised-- is a significant update from the previous one, and shows you how to harness the newest data mining methods and techniques to solve common business problems. The duo of unparalleled authors share invaluable advice for improving response rates to direct marketing campaigns, identifying new customer segments, and estimating credit risk. In addition, they cover more advanced topics such as preparing data for analysis and creating the necessary infrastructure for data mining at your company. 
<ul>
<li>Features significant updates since the previous edition and updates you on best practices for using data mining methods and techniques for solving common business problems</li> <li>Covers a new data mining technique in every chapter along with clear, concise explanations on how to apply each technique immediately</li> <li>Touches on core data mining techniques, including decision trees, neural networks, collaborative filtering, association rules, link analysis, survival analysis, and more</li> <li>Provides best practices for performing data mining using simple tools such as Excel</li> </ul>
Data Mining Techniques, Third Edition covers a new data mining technique with each successive chapter and then demonstrates how you can apply that technique for improved marketing, sales, and customer support to get immediate results. Exercises and data sets to accompany this book are available at jmp.com/en_us/academic/data-mining-techniques.html

Data Mining Techniques: For Marketing, Sales, and Customer Relationship Management

Business & Money

Berry, Michael J. A.

Marketing & Sales

Who will remain a loyal customer and who won't? What kind of marketing approach is most likely to increase sales? What can customer buying patterns tell us about improving our inventory control? What type of credit approval process will work best for us and our customers? The answers to these and all your crucial business questions lie buried in your company's information systems. This book supplies you with powerful tools for mining them. Data Mining Techniques thoroughly acquaints you with the new generation of data mining tools and techniques and shows you how to use them to make better business decisions. One of the first practical guides to mining business data, it describes techniques for detecting customer behavior patterns useful in formulating marketing, sales, and customer support strategies. While database analysts will find more than enough technical information to satisfy their curiosity, technically savvy business and marketing managers will find the coverage eminently accessible. Here's your chance to learn all about: * How leading companies across North America are using data mining to beat the competition * How each tool works, and how to pick the right one for the job * Seven powerful techniques -cluster detection, memory-based reasoning, market basket analysis, genetic algorithms, link analysis, decision trees, and neural nets * How to prepare data sources for data mining, and how to evaluate and use the results you get Data Mining Techniques shows you how to quickly and easily tap the gold mine of business solutions lying dormant in your information systems.

Data Mining Techniques: For Marketing, Sales, and Customer Support

Management & Leadership

A practical guide to data mining using SQL and Excel Data Analysis Using SQL and Excel, 2nd Edition shows you how to leverage the two most popular tools for data query and analysis―SQL and Excel―to perform sophisticated data analysis without the need for complex and expensive data mining tools. Written by a leading expert on business data mining, this book shows you how to extract useful business information from relational databases. You'll learn the fundamental techniques before moving into the "where" and "why" of each analysis, and then learn how to design and perform these analyses using SQL and Excel. Examples include SQL and Excel code, and the appendix shows how non-standard constructs are implemented in other major databases, including Oracle and IBM DB2/UDB. The companion website includes datasets and Excel spreadsheets, and the book provides hints, warnings, and technical asides to help you every step of the way. Data Analysis Using SQL and Excel, 2nd Edition shows you how to perform a wide range of sophisticated analyses using these simple tools, sparing you the significant expense of proprietary data mining tools like SAS. <ul>
<li>Understand core analytic techniques that work with SQL and Excel</li> <li>Ensure your analytic approach gets you the results you need</li> <li>Design and perform your analysis using SQL and Excel</li> </ul>
Data Analysis Using SQL and Excel, 2nd Edition shows you how to best use the tools you already know to achieve expert results.

See the best price to sell, buy, or rent books by Linoff, Gordon S.. BookScouter helps to compare book prices from 25+ online bookstores and 30+ buyback vendors with a single search.

Books by Linoff, Gordon S.

See the best price to sell, buy, or rent books by Linoff, Gordon S.. BookScouter helps to compare book prices from 25+ online bookstores and 30+ buyback vendors with a single search.

Data Analysis Using SQL and Excel

Data Mining Techniques: For Marketing, Sales, and Customer Relationship Management

Data Mining Techniques: For Marketing, Sales, and Customer Support

Data Analysis Using SQL and Excel