Data Analysis Using SQL and Excel

Knowledge into effective action is required for business analysis tools. This book and business information extracted from relational databases to store data to identify aspects of business transactions and offer customers more to use it to help you use SQL and Excel. When and why do the design and analysis using SQL and Excel to obtain useful results, and results should be similar to how the company to perform some type of analysis are described in each chapter.

Back cover

Harness the power of SQL and Excel to perform business analysis

Three major efforts are required for efficient conversion of knowledge to action: Import data from Excel data with SQL, the presentation and understanding of statistics as the basis for data analysis. Data mining expert Gordon Linoff focuses on these issues, SQL and shows you how to use Excel to extract business information from relational databases. Start taking a look at the amount of data, customers, products and markets is central to the task of understanding the dimensions of business relationships to customers and then the store will show you how to use these data to identify and summarize important data to produce results. On the way, it aims to improve understanding of why some things work and others' stories based on personal experience in the field, to share.

When and why to design and how to perform the analysis using SQL and Excel to obtain useful results and outcomes for what they can expect to look like some type of business to conduct the analysis described in each section. Throughout the book, the essential features of Excel are highlighted, interesting uses of Excel graphics are explained, and processing of data streams and graphical representation of data in SQL Server is used to show you how.

SQL and Excel, SQL, and advice to share data analysis / mining on the Excel Data Analysis Using Alerts and technical asides. The book discusses:

• How to describe the structure of an entity-relationship diagrams, data
• Ways to use SQL to create SQL queries
• This means, as the descriptive statistics and chi-square p-values
• How to analyze data, including geographic information
• The basic ideas of risk and the probability of survival
• Data structures, how to summarize what he looks like a client at some point in
• Several variants of linear regression
• Companion Website, data sets, Excel spreadsheets and provides examples in the book.

About the Author

Gordon S. Linoff data miners, Inc., a consulting firm specializing in data mining is one of the founders. Data mining techniques that bestseller, Second Edition, and Mastering Data Mining (Wiley both) is co-author. This, customer relations, marketing and managing the implementation of data mining techniques to business problems that have more than a decade.